RMAN> run { allocate channel ch1 type disk; allocate channel ch2 type disk; allocate auxiliary channel ch3 type disk; allocate auxiliary channel ch4 type disk; duplicate target database for standby from active database DORECOVER; }2> 3> 4> 5> 6> 7> using target database control file instead of recovery catalog allocated channel: ch1 channel ch1: SID=82 instance=tintin1 device type=DISK allocated channel: ch2 channel ch2: SID=81 instance=tintin1 device type=DISK allocated channel: ch3 channel ch3: SID=63 device type=DISK allocated channel: ch4 channel ch4: SID=132 device type=DISK Starting Duplicate Db at 16-FEB-12 contents of Memory Script: { backup as copy reuse targetfile '/home/oracle/product/11.2.0/dbhome_1/dbs/orapwtintin1' auxiliary format '/home/oracle/product/11.2.0/dbhome_1/dbs/orapwsnowy1' ; } executing Memory Script Starting backup at 16-FEB-12 Finished backup at 16-FEB-12 contents of Memory Script: { backup as copy current controlfile for standby auxiliary format '+DATA/snowy/controlfile/current.261.775373819'; restore clone controlfile to '+FLASH/snowy/controlfile/current.309.775373819' from '+DATA/snowy/controlfile/current.261.775373819'; sql clone "create spfile from memory"; shutdown clone immediate; startup clone nomount; sql clone "alter system set control_files = ''+DATA/snowy/controlfile/current.261.775373819'', ''+FLASH/snowy/controlfile/current.309.775373819'' comment= ''Set by RMAN'' scope=spfile"; shutdown clone immediate; startup clone nomount; } executing Memory Script Starting backup at 16-FEB-12 channel ch1: starting datafile copy copying standby control file output file name=/home/oracle/product/11.2.0/dbhome_1/dbs/snapcf_tintin1.f tag=TAG20120216T043203 RECID=1 STAMP=775369925 channel ch1: datafile copy complete, elapsed time: 00:00:03 Finished backup at 16-FEB-12 Starting restore at 16-FEB-12 channel ch4: skipped, AUTOBACKUP already found channel ch3: copied control file copy Finished restore at 16-FEB-12 sql statement: create spfile from memory Oracle instance shut down connected to auxiliary database (not started) Oracle instance started Total System Global Area 1570009088 bytes Fixed Size 2228704 bytes Variable Size 419434016 bytes Database Buffers 1140850688 bytes Redo Buffers 7495680 bytes allocated channel: ch3 channel ch3: SID=63 device type=DISK allocated channel: ch4 channel ch4: SID=132 device type=DISK sql statement: alter system set control_files = ''+DATA/snowy/controlfile/current.261.775373819'', ''+FLASH/snowy/controlfile/current.309.775373819'' comment= ''Set by RMAN'' scope=spfile Oracle instance shut down connected to auxiliary database (not started) Oracle instance started Total System Global Area 1570009088 bytes Fixed Size 2228704 bytes Variable Size 419434016 bytes Database Buffers 1140850688 bytes Redo Buffers 7495680 bytes allocated channel: ch3 channel ch3: SID=63 device type=DISK allocated channel: ch4 channel ch4: SID=132 device type=DISK contents of Memory Script: { sql clone 'alter database mount standby database'; } executing Memory Script sql statement: alter database mount standby database contents of Memory Script: { set newname for clone tempfile 1 to new; switch clone tempfile all; 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; backup as copy reuse datafile 1 auxiliary format new datafile 2 auxiliary format new datafile 3 auxiliary format new datafile 4 auxiliary format new datafile 5 auxiliary format new datafile 6 auxiliary format new ; sql 'alter system archive log current'; } executing Memory Script executing command: SET NEWNAME renamed tempfile 1 to +DATA in control file 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 backup at 16-FEB-12 channel ch1: starting datafile copy input datafile file number=00006 name=+DATA/tintin/datafile/users.268.773586631 channel ch2: starting datafile copy input datafile file number=00004 name=+DATA/tintin/datafile/users.259.772440633 output file name=+DATA/snowy/datafile/users.262.775373887 tag=TAG20120216T043309 channel ch2: datafile copy complete, elapsed time: 00:06:05 channel ch2: starting datafile copy input datafile file number=00002 name=+DATA/tintin/datafile/sysaux.257.772440633 output file name=+DATA/snowy/datafile/sysaux.274.775374253 tag=TAG20120216T043309 channel ch2: datafile copy complete, elapsed time: 00:02:15 channel ch2: starting datafile copy input datafile file number=00001 name=+DATA/tintin/datafile/system.256.772440633 output file name=+DATA/snowy/datafile/users.266.775373887 tag=TAG20120216T043309 channel ch1: datafile copy complete, elapsed time: 00:08:36 channel ch1: starting datafile copy input datafile file number=00003 name=+DATA/tintin/datafile/undotbs1.258.772440633 output file name=+DATA/snowy/datafile/undotbs1.276.775374403 tag=TAG20120216T043309 channel ch1: datafile copy complete, elapsed time: 00:00:35 channel ch1: starting datafile copy input datafile file number=00005 name=+DATA/tintin/datafile/undotbs2.264.772440921 output file name=+DATA/snowy/datafile/undotbs2.277.775374439 tag=TAG20120216T043309 channel ch1: datafile copy complete, elapsed time: 00:00:07 output file name=+DATA/snowy/datafile/system.275.775374389 tag=TAG20120216T043309 channel ch2: datafile copy complete, elapsed time: 00:00:58 Finished backup at 16-FEB-12 sql statement: alter system archive log current contents of Memory Script: { backup as copy reuse archivelog like "+FLASH/tintin/archivelog/2012_02_16/thread_2_seq_81.308.775356909" auxiliary format "+FLASH" archivelog like "+FLASH/tintin/archivelog/2012_02_16/thread_2_seq_82.311.775374449" auxiliary format "+FLASH" archivelog like "+FLASH/tintin/archivelog/2012_02_16/thread_1_seq_187.310.775370551" auxiliary format "+FLASH" ; catalog clone start with "+FLASH"; switch clone datafile all; } executing Memory Script Starting backup at 16-FEB-12 channel ch1: starting archived log copy input archived log thread=2 sequence=81 RECID=37 STAMP=775356916 channel ch2: starting archived log copy input archived log thread=2 sequence=82 RECID=38 STAMP=775374454 output file name=+FLASH/snowy/archivelog/2012_02_16/thread_2_seq_82.313.775374457 RECID=0 STAMP=0 channel ch2: archived log copy complete, elapsed time: 00:00:01 channel ch2: starting archived log copy input archived log thread=1 sequence=187 RECID=39 STAMP=775370559 output file name=+FLASH/snowy/archivelog/2012_02_16/thread_1_seq_187.314.775374459 RECID=0 STAMP=0 channel ch2: archived log copy complete, elapsed time: 00:00:03 output file name=+FLASH/snowy/archivelog/2012_02_16/thread_2_seq_81.312.775374457 RECID=0 STAMP=0 channel ch1: archived log copy complete, elapsed time: 00:00:09 Finished backup at 16-FEB-12 searching for all files that match the pattern +FLASH List of Files Unknown to the Database ===================================== File Name: +flash/SNOWY/ARCHIVELOG/2012_02_16/thread_2_seq_81.312.775374457 File Name: +flash/SNOWY/ARCHIVELOG/2012_02_16/thread_2_seq_82.313.775374457 File Name: +flash/SNOWY/ARCHIVELOG/2012_02_16/thread_1_seq_187.314.775374459 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_16/thread_2_seq_81.308.775356909 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_16/thread_1_seq_187.310.775370551 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_16/thread_2_seq_82.311.775374449 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_2_seq_73.286.775285235 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_1_seq_182.287.775289543 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_2_seq_74.288.775293439 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_2_seq_75.289.775306809 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_1_seq_183.290.775306811 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_2_seq_76.291.775306811 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_2_seq_77.292.775310877 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_2_seq_78.293.775310879 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_1_seq_184.294.775306983 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_1_seq_185.301.775319309 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_2_seq_79.302.775323205 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_2_seq_80.305.775323479 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_1_seq_186.306.775319583 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_14/thread_2_seq_72.285.775216855 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_13/thread_1_seq_180.281.775126527 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_13/thread_2_seq_70.282.775173619 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_13/thread_2_seq_71.283.775173667 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_13/thread_1_seq_181.284.775176941 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_12/thread_2_seq_69.279.775080979 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_12/thread_1_seq_179.280.775077087 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_11/thread_2_seq_66.275.774957953 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_11/thread_1_seq_178.276.774954059 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_11/thread_2_seq_67.277.774986809 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_11/thread_2_seq_68.278.774994523 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_10/thread_2_seq_65.274.774842403 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_08/thread_2_seq_62.270.774735159 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_08/thread_2_seq_63.271.774735171 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_08/thread_1_seq_177.272.774731279 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_08/thread_2_seq_64.273.774741635 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_07/thread_1_seq_176.268.774582915 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_07/thread_2_seq_61.269.774626443 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_06/thread_2_seq_60.264.774511227 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_06/thread_1_seq_175.265.774528933 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_05/thread_2_seq_58.260.774475801 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_05/thread_2_seq_59.262.774483149 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_05/thread_1_seq_174.263.774479255 File Name: +flash/TINTIN/FLASHBACK/log_1.256.774428611 File Name: +flash/TINTIN/FLASHBACK/log_2.257.774428617 File Name: +flash/TINTIN/FLASHBACK/log_3.258.774432565 File Name: +flash/TINTIN/FLASHBACK/log_4.259.774432571 File Name: +flash/TINTIN/FLASHBACK/log_5.261.774475801 File Name: +flash/TINTIN/FLASHBACK/log_6.266.774536139 File Name: +flash/TINTIN/FLASHBACK/log_7.267.774543665 cataloging files... cataloging done List of Cataloged Files ======================= File Name: +flash/SNOWY/ARCHIVELOG/2012_02_16/thread_2_seq_81.312.775374457 File Name: +flash/SNOWY/ARCHIVELOG/2012_02_16/thread_2_seq_82.313.775374457 File Name: +flash/SNOWY/ARCHIVELOG/2012_02_16/thread_1_seq_187.314.775374459 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_16/thread_2_seq_81.308.775356909 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_16/thread_1_seq_187.310.775370551 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_16/thread_2_seq_82.311.775374449 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_2_seq_73.286.775285235 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_1_seq_182.287.775289543 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_2_seq_74.288.775293439 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_2_seq_75.289.775306809 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_1_seq_183.290.775306811 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_2_seq_76.291.775306811 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_2_seq_77.292.775310877 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_2_seq_78.293.775310879 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_1_seq_184.294.775306983 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_1_seq_185.301.775319309 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_2_seq_79.302.775323205 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_2_seq_80.305.775323479 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_15/thread_1_seq_186.306.775319583 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_14/thread_2_seq_72.285.775216855 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_13/thread_1_seq_180.281.775126527 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_13/thread_2_seq_70.282.775173619 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_13/thread_2_seq_71.283.775173667 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_13/thread_1_seq_181.284.775176941 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_12/thread_2_seq_69.279.775080979 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_12/thread_1_seq_179.280.775077087 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_11/thread_2_seq_66.275.774957953 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_11/thread_1_seq_178.276.774954059 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_11/thread_2_seq_67.277.774986809 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_11/thread_2_seq_68.278.774994523 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_10/thread_2_seq_65.274.774842403 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_08/thread_2_seq_62.270.774735159 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_08/thread_2_seq_63.271.774735171 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_08/thread_1_seq_177.272.774731279 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_08/thread_2_seq_64.273.774741635 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_07/thread_1_seq_176.268.774582915 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_07/thread_2_seq_61.269.774626443 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_06/thread_2_seq_60.264.774511227 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_06/thread_1_seq_175.265.774528933 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_05/thread_2_seq_58.260.774475801 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_05/thread_2_seq_59.262.774483149 File Name: +flash/TINTIN/ARCHIVELOG/2012_02_05/thread_1_seq_174.263.774479255 List of Files Which Where Not Cataloged ======================================= File Name: +flash/TINTIN/FLASHBACK/log_1.256.774428611 RMAN-07529: Reason: catalog is not supported for this file type File Name: +flash/TINTIN/FLASHBACK/log_2.257.774428617 RMAN-07529: Reason: catalog is not supported for this file type File Name: +flash/TINTIN/FLASHBACK/log_3.258.774432565 RMAN-07529: Reason: catalog is not supported for this file type File Name: +flash/TINTIN/FLASHBACK/log_4.259.774432571 RMAN-07529: Reason: catalog is not supported for this file type File Name: +flash/TINTIN/FLASHBACK/log_5.261.774475801 RMAN-07529: Reason: catalog is not supported for this file type File Name: +flash/TINTIN/FLASHBACK/log_6.266.774536139 RMAN-07529: Reason: catalog is not supported for this file type File Name: +flash/TINTIN/FLASHBACK/log_7.267.774543665 RMAN-07529: Reason: catalog is not supported for this file type datafile 1 switched to datafile copy input datafile copy RECID=1 STAMP=775374469 file name=+DATA/snowy/datafile/system.275.775374389 datafile 2 switched to datafile copy input datafile copy RECID=2 STAMP=775374469 file name=+DATA/snowy/datafile/sysaux.274.775374253 datafile 3 switched to datafile copy input datafile copy RECID=3 STAMP=775374469 file name=+DATA/snowy/datafile/undotbs1.276.775374403 datafile 4 switched to datafile copy input datafile copy RECID=4 STAMP=775374469 file name=+DATA/snowy/datafile/users.262.775373887 datafile 5 switched to datafile copy input datafile copy RECID=5 STAMP=775374469 file name=+DATA/snowy/datafile/undotbs2.277.775374439 datafile 6 switched to datafile copy input datafile copy RECID=6 STAMP=775374469 file name=+DATA/snowy/datafile/users.266.775373887 contents of Memory Script: { set until scn 9037204; recover standby clone database delete archivelog ; } executing Memory Script executing command: SET until clause Starting recover at 16-FEB-12 starting media recovery archived log for thread 1 with sequence 187 is already on disk as file +FLASH/snowy/archivelog/2012_02_16/thread_1_seq_187.314.775374459 archived log for thread 2 with sequence 82 is already on disk as file +FLASH/snowy/archivelog/2012_02_16/thread_2_seq_82.313.775374457 archived log file name=+FLASH/snowy/archivelog/2012_02_16/thread_1_seq_187.314.775374459 thread=1 sequence=187 archived log file name=+FLASH/snowy/archivelog/2012_02_16/thread_2_seq_82.313.775374457 thread=2 sequence=82 media recovery complete, elapsed time: 00:00:02 Finished recover at 16-FEB-12 Finished Duplicate Db at 16-FEB-12 released channel: ch1 released channel: ch2 released channel: ch3 released channel: ch4