Oracle Database Discussions

All,
Target database is mdm2 single instance
duplicate databsae is MDM1 2 node RAC.

Please confirm if this is the right command to create a duplicate database DUPLICATE TARGET DATABASE TO mdm1 NOFILENAMECHECK;


[oracle@rs1pre91dvdbaa01 ~]$ rman target sys/***@mdm2 auxiliary /

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Oct 20 15:41:26 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: MDM (DBID=1483762860)
connected to auxiliary database: MDM (not mounted)

RMAN> DUPLICATE TARGET DATABASE TO mdm1 NOFILENAMECHECK;

Starting Duplicate Db at 20-10-2010 15:46:15
using channel ORA_AUX_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/20/2010 15:46:19
RMAN-05520: database name mismatch, auxiliary instance has MDM, command specifie d MDM1

RMAN> DUPLICATE TARGET DATABASE TO mdm;

Starting Duplicate Db at 20-10-2010 15:46:32
using channel ORA_AUX_DISK_1

contents of Memory Script:
{
sql clone "alter system set control_files =
''+MDMDG1/mdm1/controlfile/current.311.732444665'', ''+MDMDG2/mdm1/controlfile /current.374.732444665'' comment=
''Set by RMAN'' scope=spfile";
sql clone "alter system set db_name =
''MDM'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile;
alter clone database mount;
}
executing Memory Script

sql statement: alter system set control_files = ''+MDMDG1/mdm1/controlfile/cu rrent.311.732444665'', ''+MDMDG2/mdm1/controlfile/current.374.732444665'' commen t= ''Set by RMAN'' scope=spfile

sql statement: alter system set db_name = ''MDM'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area 835104768 bytes

Fixed Size 2217952 bytes
Variable Size 629147680 bytes
Database Buffers 197132288 bytes
Redo Buffers 6606848 bytes

Starting restore at 20-10-2010 15:46:52
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=401 instance=MDM11 device type=DISK

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece +MDMDG2/mdm2/autobackup/2010_1 0_18/s_732738360.307.732738361
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece +MDMDG2/md m2/autobackup/2010_10_18/s_732738360.307.732738361
ORA-19505: failed to identify file "+MDMDG2/mdm2/autobackup/2010_10_18/s_7327383 60.307.732738361"
ORA-17503: ksfdopn:2 Failed to open file +MDMDG2/mdm2/autobackup/2010_10_18/s_73 2738360.307.732738361
ORA-15012: ASM file '+MDMDG2/mdm2/autobackup/2010_10_18/s_732738360.307.73273836 1' does not exist

failover to previous backup

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /backups/rman/rman_bck/Mon/MDM 2/MDM2_6flqpcn2_1_1.ctl_sby_bkp
channel ORA_AUX_DISK_1: piece handle=/backups/rman/rman_bck/Mon/MDM2/MDM2_6flqpc n2_1_1.ctl_sby_bkp tag=TAG20101018T182434
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+MDMDG1/mdm1/controlfile/current.311.732444665
output file name=+MDMDG2/mdm1/controlfile/current.374.732444665
Finished restore at 20-10-2010 15:46:56

database mounted

contents of Memory Script:
{
set until scn 1911950;
set newname for clone datafile 1 to new;
set newname for clone datafile 2 to new;
set newname for clone datafile 3 to new;
set newname for clone datafile 4 to new;
set newname for clone datafile 5 to new;
set newname for clone datafile 6 to new;
set newname for clone datafile 7 to new;
set newname for clone datafile 8 to new;
set newname for clone datafile 9 to new;
set newname for clone datafile 10 to new;
set newname for clone datafile 11 to new;
set newname for clone datafile 12 to new;
set newname for clone datafile 13 to new;
set newname for clone datafile 14 to new;
set newname for clone datafile 15 to new;
restore
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 20-10-2010 15:47:01
using channel ORA_AUX_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/20/2010 15:47:01
RMAN-05556: not all datafiles have backups that can be recovered to SCN 1911950
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN> duplicate target database for standby;

Starting Duplicate Db at 20-10-2010 15:47:11
using channel ORA_AUX_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/20/2010 15:47:11
RMAN-05500: the auxiliary database must be not mounted when issuing a DUPLICATE command

RMAN> duplicate target database for standby;

Starting Duplicate Db at 20-10-2010 15:47:58
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN> exit