Oracle 11GR2 Duplicate from Backup

来源：这里教程网时间：2026-03-03 12:12:50 作者：

mkdir -p /u01/app/oracle/oradata/test/onlinelog/ mkdir -p /u01/app/oracle/oradata/test/datafile/ 创建pfile test.__db_cache_size=1845493760 test.__java_pool_size=16777216 test.__large_pool_size=16777216 test.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment test.__pga_aggregate_target=805306368 test.__sga_target=2415919104 test.__shared_io_pool_size=0 test.__shared_pool_size=503316480 test.__streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/test/adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.control_files='/u01/app/oracle/oradata/test/control01.ctl','/u01/app/oracle/fast_recovery_area/test/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='testdup' *.db_unique_name='testdup' *.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area' *.db_recovery_file_dest_size=42949672960 *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)' *.open_cursors=300 *.pga_aggregate_target=1G *.processes=1500 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=3G *.undo_tablespace='UNDOTBS1' *._no_recovery_through_resetlogs=true #*.db_create_file_dest='/u01/app/oracle/oradata/test/' *.log_file_name_convert='+DATA/testdb','/u01/app/oracle/oradata/test','+FRA/testdb','/u01/app/oracle/oradata/test' *.db_file_name_convert='+DATA/testdb','/u01/app/oracle/oradata/test' 注意db_unique_name, db_name与源库要不同将数据库启动至nomount状态 [oracle@test test]$ rman catalog rman/rman@catadb auxiliary / Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 9 18:47:57 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to recovery catalog database connected to auxiliary database: testDUP (not mounted) RMAN> RMAN> RMAN> run{ 2> allocate auxiliary channel 'dev1' type 'sbt_tape' parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=testdb)'; allocate auxiliary channel 'dev2' type 'sbt_tape' parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=testdb)'; allocate auxiliary channel 'dev3' type 'sbt_tape' parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=testdb)'; allocate auxiliary channel 'dev4' type 'sbt_tape' parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=testdb)'; allocate auxiliary channel 'dev5' type 'sbt_tape' parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=testdb)'; send device type 'sbt_tape' 'NO_AUTO_DEVICE_SELECTION=1'; send device type 'sbt_tape' 'CHDEV=testdb1_gw>test_gw_15_90;wuxi_drtestdb_gw>test_gw_15_90'; set until sequence 3072 thread 2; duplicate database test dbid 1219727298 to testdup; release channel 'dev1'; release channel 'dev2'; release channel 'dev3'; release channel 'dev4'; release channel 'dev5'; }3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> allocated channel: dev1 channel dev1: SID=1707 device type=SBT_TAPE channel dev1: Omniback/182 allocated channel: dev2 channel dev2: SID=1992 device type=SBT_TAPE channel dev2: Omniback/182 allocated channel: dev3 channel dev3: SID=3 device type=SBT_TAPE channel dev3: Omniback/182 allocated channel: dev4 channel dev4: SID=286 device type=SBT_TAPE channel dev4: Omniback/182 allocated channel: dev5 channel dev5: SID=571 device type=SBT_TAPE channel dev5: Omniback/182 sent command to channel: dev1 sent command to channel: dev2 sent command to channel: dev3 sent command to channel: dev4 sent command to channel: dev5 sent command to channel: dev1 sent command to channel: dev2 sent command to channel: dev3 sent command to channel: dev4 sent command to channel: dev5 executing command: SET until clause Starting Duplicate Db at 20181109 18:48:12 contents of Memory Script: { sql clone "create spfile from memory"; } executing Memory Script sql statement: create spfile from memory contents of Memory Script: { shutdown clone immediate; startup clone nomount; } executing Memory Script Oracle instance shut down connected to auxiliary database (not started) Oracle instance started Total System Global Area 3206836224 bytes Fixed Size 2232640 bytes Variable Size 671092416 bytes Database Buffers 2516582400 bytes Redo Buffers 16928768 bytes allocated channel: dev1 channel dev1: SID=1423 device type=SBT_TAPE channel dev1: Omniback/182 allocated channel: dev2 channel dev2: SID=1707 device type=SBT_TAPE channel dev2: Omniback/182 allocated channel: dev3 channel dev3: SID=1991 device type=SBT_TAPE channel dev3: Omniback/182 allocated channel: dev4 channel dev4: SID=3 device type=SBT_TAPE channel dev4: Omniback/182 allocated channel: dev5 channel dev5: SID=286 device type=SBT_TAPE channel dev5: Omniback/182 contents of Memory Script: { set until scn 1278777273250; sql clone "alter system set db_name = ''test'' comment= ''Modified by RMAN duplicate'' scope=spfile"; sql clone "alter system set db_unique_name = ''testDUP'' 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 executing command: SET until clause sql statement: alter system set db_name = ''test'' comment= ''Modified by RMAN duplicate'' scope=spfile sql statement: alter system set db_unique_name = ''testDUP'' comment= ''Modified by RMAN duplicate'' scope=spfile Oracle instance shut down Oracle instance started Total System Global Area 3206836224 bytes Fixed Size 2232640 bytes Variable Size 671092416 bytes Database Buffers 2516582400 bytes Redo Buffers 16928768 bytes allocated channel: dev1 channel dev1: SID=1423 device type=SBT_TAPE channel dev1: Omniback/182 allocated channel: dev2 channel dev2: SID=1707 device type=SBT_TAPE channel dev2: Omniback/182 allocated channel: dev3 channel dev3: SID=1991 device type=SBT_TAPE channel dev3: Omniback/182 allocated channel: dev4 channel dev4: SID=3 device type=SBT_TAPE channel dev4: Omniback/182 allocated channel: dev5 channel dev5: SID=286 device type=SBT_TAPE channel dev5: Omniback/182 Starting restore at 20181109 18:48:31 channel dev1: starting datafile backup set restore channel dev1: restoring control file channel dev1: reading from backup piece c-1219727298-20181108-02 channel dev1: piece handle=c-1219727298-20181108-02 tag=TAG20181108T150218 channel dev1: restored backup piece 1 channel dev1: restore complete, elapsed time: 00:00:45 output file name=/u01/app/oracle/oradata/test/control01.ctl output file name=/u01/app/oracle/fast_recovery_area/test/control02.ctl Finished restore at 20181109 18:49:18 database mounted contents of Memory Script: { set until scn 1278777273250; set newname for datafile 1 to "/u01/app/oracle/oradata/test/datafile/system.269.955537675"; set newname for datafile 2 to "/u01/app/oracle/oradata/test/datafile/sysaux.259.955537689"; set newname for datafile 3 to "/u01/app/oracle/oradata/test/datafile/undotbs1.257.955537817"; set newname for datafile 4 to "/u01/app/oracle/oradata/test/datafile/users.263.955537675"; set newname for datafile 5 to "/u01/app/oracle/oradata/test/datafile/undotbs2.264.955537683"; set newname for datafile 6 to "/u01/app/oracle/oradata/test/datafile/t_newoa2012.258.955537815"; set newname for datafile 7 to "/u01/app/oracle/oradata/test/datafile/index_newoa2012.268.955537677"; set newname for datafile 8 to "/u01/app/oracle/oradata/test/datafile/patrol.267.955537675"; set newname for datafile 9 to "/u01/app/oracle/oradata/test/datafile/t_newoa2012.277.967367381"; set newname for datafile 10 to "/u01/app/oracle/oradata/test/datafile/t_newoa2012.279.980068971"; set newname for datafile 11 to "/u01/app/oracle/oradata/test/datafile/t_newoa2012.280.986462143"; 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 Starting restore at 20181109 18:49:22 channel dev1: starting datafile backup set restore channel dev1: specifying datafile(s) to restore from backup set channel dev1: restoring datafile 00001 to /u01/app/oracle/oradata/test/datafile/system.269.955537675 channel dev1: reading from backup piece shanghai_test_testdb_11203<testdb_12155:991662579:1>.dbf channel dev2: starting datafile backup set restore channel dev2: specifying datafile(s) to restore from backup set channel dev2: restoring datafile 00002 to /u01/app/oracle/oradata/test/datafile/sysaux.259.955537689 channel dev2: reading from backup piece shanghai_test_testdb_11203<testdb_12156:991662579:1>.dbf channel dev3: starting datafile backup set restore channel dev3: specifying datafile(s) to restore from backup set channel dev3: restoring datafile 00005 to /u01/app/oracle/oradata/test/datafile/undotbs2.264.955537683 channel dev3: reading from backup piece shanghai_test_testdb_11203<testdb_12158:991662579:1>.dbf channel dev4: starting datafile backup set restore channel dev4: specifying datafile(s) to restore from backup set channel dev4: restoring datafile 00003 to /u01/app/oracle/oradata/test/datafile/undotbs1.257.955537817 channel dev4: reading from backup piece shanghai_test_testdb_11203<testdb_12157:991662579:1>.dbf channel dev5: starting datafile backup set restore channel dev5: specifying datafile(s) to restore from backup set channel dev5: restoring datafile 00006 to /u01/app/oracle/oradata/test/datafile/t_newoa2012.258.955537815 channel dev5: reading from backup piece shanghai_test_testdb_11203<testdb_12159:991662579:1>.dbf channel dev1: piece handle=shanghai_test_testdb_11203<testdb_12155:991662579:1>.dbf tag=PRODUCTION channel dev1: restored backup piece 1 channel dev1: restore complete, elapsed time: 00:02:45 channel dev1: starting datafile backup set restore channel dev1: specifying datafile(s) to restore from backup set channel dev1: restoring datafile 00009 to /u01/app/oracle/oradata/test/datafile/t_newoa2012.277.967367381 channel dev1: reading from backup piece shanghai_test_testdb_11203<testdb_12161:991662579:1>.dbf channel dev2: piece handle=shanghai_test_testdb_11203<testdb_12156:991662579:1>.dbf tag=PRODUCTION channel dev2: restored backup piece 1 channel dev2: restore complete, elapsed time: 00:03:30 channel dev2: starting datafile backup set restore channel dev2: specifying datafile(s) to restore from backup set channel dev2: restoring datafile 00007 to /u01/app/oracle/oradata/test/datafile/index_newoa2012.268.955537677 channel dev2: reading from backup piece shanghai_test_testdb_11203<testdb_12160:991662579:1>.dbf channel dev3: piece handle=shanghai_test_testdb_11203<testdb_12158:991662579:1>.dbf tag=PRODUCTION channel dev3: restored backup piece 1 channel dev3: restore complete, elapsed time: 00:04:15 channel dev3: starting datafile backup set restore channel dev3: specifying datafile(s) to restore from backup set channel dev3: restoring datafile 00011 to /u01/app/oracle/oradata/test/datafile/t_newoa2012.280.986462143 channel dev3: reading from backup piece shanghai_test_testdb_11203<testdb_12163:991662580:1>.dbf channel dev4: piece handle=shanghai_test_testdb_11203<testdb_12157:991662579:1>.dbf tag=PRODUCTION channel dev4: restored backup piece 1 channel dev4: restore complete, elapsed time: 00:04:17 channel dev4: starting datafile backup set restore channel dev4: specifying datafile(s) to restore from backup set channel dev4: restoring datafile 00010 to /u01/app/oracle/oradata/test/datafile/t_newoa2012.279.980068971 channel dev4: reading from backup piece shanghai_test_testdb_11203<testdb_12162:991662580:1>.dbf channel dev2: piece handle=shanghai_test_testdb_11203<testdb_12160:991662579:1>.dbf tag=PRODUCTION channel dev2: restored backup piece 1 channel dev2: restore complete, elapsed time: 00:04:22 channel dev2: starting datafile backup set restore channel dev2: specifying datafile(s) to restore from backup set channel dev2: restoring datafile 00008 to /u01/app/oracle/oradata/test/datafile/patrol.267.955537675 channel dev2: reading from backup piece wuxi_testdb_11.2.0.3_drtestdb_131_166_step1<testdb_18717:991663706:1>.dbf channel dev2: ORA-19870: error while restoring backup piece wuxi_testdb_11.2.0.3_drtestdb_131_166_step1<testdb_18717:991663706:1>.dbf ORA-19507: failed to retrieve sequential file, handle="wuxi_testdb_11.2.0.3_drtestdb_131_166_step1<testdb_18717:991663706:1>.dbf", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: Vendor specific error: OB2_StartObjectRestoreFullName() failed ERR(-17 channel dev2: starting datafile backup set restore channel dev2: specifying datafile(s) to restore from backup set channel dev2: restoring datafile 00004 to /u01/app/oracle/oradata/test/datafile/users.263.955537675 channel dev2: reading from backup piece wuxi_testdb_11.2.0.3_drtestdb_131_166_step1<testdb_18716:991663697:1>.dbf channel dev3: piece handle=shanghai_test_testdb_11203<testdb_12163:991662580:1>.dbf tag=PRODUCTION channel dev3: restored backup piece 1 channel dev3: restore complete, elapsed time: 00:05:12 channel dev5: piece handle=shanghai_test_testdb_11203<testdb_12159:991662579:1>.dbf tag=PRODUCTION channel dev5: restored backup piece 1 channel dev5: restore complete, elapsed time: 00:10:52 channel dev1: piece handle=shanghai_test_testdb_11203<testdb_12161:991662579:1>.dbf tag=PRODUCTION channel dev1: restored backup piece 1 channel dev1: restore complete, elapsed time: 00:10:47 channel dev4: piece handle=shanghai_test_testdb_11203<testdb_12162:991662580:1>.dbf tag=PRODUCTION channel dev4: restored backup piece 1 channel dev4: restore complete, elapsed time: 00:11:25 channel dev2: ORA-19870: error while restoring backup piece wuxi_testdb_11.2.0.3_drtestdb_131_166_step1<testdb_18716:991663697:1>.dbf ORA-19507: failed to retrieve sequential file, handle="wuxi_testdb_11.2.0.3_drtestdb_131_166_step1<testdb_18716:991663697:1>.dbf", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: Vendor specific error: OB2_StartObjectRestoreFullName() failed ERR(-17 failover to previous backup channel dev1: starting datafile backup set restore channel dev1: specifying datafile(s) to restore from backup set channel dev1: restoring datafile 00004 to /u01/app/oracle/oradata/test/datafile/users.263.955537675 channel dev1: reading from backup piece shanghai_test_testdb_11203<testdb_12164:991662580:1>.dbf channel dev2: starting datafile backup set restore channel dev2: specifying datafile(s) to restore from backup set channel dev2: restoring datafile 00008 to /u01/app/oracle/oradata/test/datafile/patrol.267.955537675 channel dev2: reading from backup piece shanghai_test_testdb_11203<testdb_12165:991662580:1>.dbf channel dev1: piece handle=shanghai_test_testdb_11203<testdb_12164:991662580:1>.dbf tag=PRODUCTION channel dev1: restored backup piece 1 channel dev1: restore complete, elapsed time: 00:00:55 channel dev2: piece handle=shanghai_test_testdb_11203<testdb_12165:991662580:1>.dbf tag=PRODUCTION channel dev2: restored backup piece 1 channel dev2: restore complete, elapsed time: 00:00:55 Finished restore at 20181109 19:09:43 contents of Memory Script: { switch clone datafile all; } executing Memory Script datafile 1 switched to datafile copy input datafile copy RECID=38 STAMP=991768183 file name=/u01/app/oracle/oradata/test/datafile/system.269.955537675 datafile 2 switched to datafile copy input datafile copy RECID=39 STAMP=991768183 file name=/u01/app/oracle/oradata/test/datafile/sysaux.259.955537689 datafile 3 switched to datafile copy input datafile copy RECID=40 STAMP=991768183 file name=/u01/app/oracle/oradata/test/datafile/undotbs1.257.955537817 datafile 4 switched to datafile copy input datafile copy RECID=41 STAMP=991768183 file name=/u01/app/oracle/oradata/test/datafile/users.263.955537675 datafile 5 switched to datafile copy input datafile copy RECID=42 STAMP=991768183 file name=/u01/app/oracle/oradata/test/datafile/undotbs2.264.955537683 datafile 6 switched to datafile copy input datafile copy RECID=43 STAMP=991768183 file name=/u01/app/oracle/oradata/test/datafile/t_newoa2012.258.955537815 datafile 7 switched to datafile copy input datafile copy RECID=44 STAMP=991768183 file name=/u01/app/oracle/oradata/test/datafile/index_newoa2012.268.955537677 datafile 8 switched to datafile copy input datafile copy RECID=45 STAMP=991768183 file name=/u01/app/oracle/oradata/test/datafile/patrol.267.955537675 datafile 9 switched to datafile copy input datafile copy RECID=46 STAMP=991768183 file name=/u01/app/oracle/oradata/test/datafile/t_newoa2012.277.967367381 datafile 10 switched to datafile copy input datafile copy RECID=47 STAMP=991768183 file name=/u01/app/oracle/oradata/test/datafile/t_newoa2012.279.980068971 datafile 11 switched to datafile copy input datafile copy RECID=48 STAMP=991768183 file name=/u01/app/oracle/oradata/test/datafile/t_newoa2012.280.986462143 contents of Memory Script: { set until scn 1278777273250; recover clone database delete archivelog ; } executing Memory Script executing command: SET until clause Starting recover at 20181109 19:09:43 starting media recovery channel dev1: starting archived log restore to default destination channel dev1: restoring archived log archived log thread=2 sequence=3070 channel dev1: restoring archived log archived log thread=1 sequence=3231 channel dev1: restoring archived log archived log thread=2 sequence=3071 channel dev1: reading from backup piece shanghai_test_testdb_11203<testdb_12177:991663203:1>.dbf channel dev1: piece handle=shanghai_test_testdb_11203<testdb_12177:991663203:1>.dbf tag=PRODUCTION channel dev1: restored backup piece 1 channel dev1: restore complete, elapsed time: 00:01:45 archived log file name=/u01/app/oracle/fast_recovery_area/testDUP/archivelog/2018_11_09/o1_mf_1_3231_fybts2dv_.arc thread=1 sequence=3231 archived log file name=/u01/app/oracle/fast_recovery_area/testDUP/archivelog/2018_11_09/o1_mf_2_3070_fybts2dq_.arc thread=2 sequence=3070 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/fast_recovery_area/testDUP/archivelog/2018_11_09/o1_mf_2_3070_fybts2dq_.arc RECID=15653 STAMP=991768291 archived log file name=/u01/app/oracle/fast_recovery_area/testDUP/archivelog/2018_11_09/o1_mf_2_3071_fybts2f0_.arc thread=2 sequence=3071 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/fast_recovery_area/testDUP/archivelog/2018_11_09/o1_mf_1_3231_fybts2dv_.arc RECID=15652 STAMP=991768262 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/fast_recovery_area/testDUP/archivelog/2018_11_09/o1_mf_2_3071_fybts2f0_.arc RECID=15651 STAMP=991768231 media recovery complete, elapsed time: 00:00:39 Finished recover at 20181109 19:12:10 Oracle instance started Total System Global Area 3206836224 bytes Fixed Size 2232640 bytes Variable Size 671092416 bytes Database Buffers 2516582400 bytes Redo Buffers 16928768 bytes contents of Memory Script: { sql clone "alter system set db_name = ''testDUP'' comment= ''Reset to original value by RMAN'' scope=spfile"; sql clone "alter system reset db_unique_name scope=spfile"; shutdown clone immediate; startup clone nomount; } executing Memory Script sql statement: alter system set db_name = ''testDUP'' comment= ''Reset to original value by RMAN'' scope=spfile sql statement: alter system reset db_unique_name scope=spfile Oracle instance shut down connected to auxiliary database (not started) Oracle instance started Total System Global Area 3206836224 bytes Fixed Size 2232640 bytes Variable Size 671092416 bytes Database Buffers 2516582400 bytes Redo Buffers 16928768 bytes allocated channel: dev1 channel dev1: SID=1423 device type=SBT_TAPE channel dev1: Omniback/182 allocated channel: dev2 channel dev2: SID=1707 device type=SBT_TAPE channel dev2: Omniback/182 allocated channel: dev3 channel dev3: SID=1991 device type=SBT_TAPE channel dev3: Omniback/182 allocated channel: dev4 channel dev4: SID=3 device type=SBT_TAPE channel dev4: Omniback/182 allocated channel: dev5 channel dev5: SID=286 device type=SBT_TAPE channel dev5: Omniback/182 sql statement: CREATE CONTROLFILE REUSE SET DATABASE "testDUP" RESETLOGS ARCHIVELOG MAXLOGFILES 192 MAXLOGMEMBERS 3 MAXDATAFILES 1024 MAXINSTANCES 32 MAXLOGHISTORY 1168 LOGFILE GROUP 1 ( '/u01/app/oracle/oradata/test/onlinelog/group01_1.log', '/u01/app/oracle/oradata/test/onlinelog/group01_2.log' ) SIZE 1 G REUSE, GROUP 2 ( '/u01/app/oracle/oradata/test/onlinelog/group02_2.log', '/u01/app/oracle/oradata/test/onlinelog/group02_1.log' ) SIZE 1 G REUSE DATAFILE '/u01/app/oracle/oradata/test/datafile/system.269.955537675' CHARACTER SET AL32UTF8 sql statement: ALTER DATABASE ADD LOGFILE INSTANCE 'i2' GROUP 3 ( '/u01/app/oracle/oradata/test/onlinelog/group03_2.log', '/u01/app/oracle/oradata/test/onlinelog/group03_1.log' ) SIZE 1 G REUSE, GROUP 4 ( '/u01/app/oracle/oradata/test/onlinelog/group04_1.log', '/u01/app/oracle/oradata/test/onlinelog/group04_2.log' ) SIZE 1 G REUSE contents of Memory Script: { set newname for tempfile 1 to "/u01/app/oracle/oradata/test/tempfile/temp.271.955540229"; set newname for tempfile 2 to "/u01/app/oracle/oradata/test/tempfile/patrol_temp.265.955540229"; set newname for tempfile 3 to "/u01/app/oracle/oradata/test/tempfile/temp.278.970137809"; switch clone tempfile all; catalog clone datafilecopy "/u01/app/oracle/oradata/test/datafile/sysaux.259.955537689", "/u01/app/oracle/oradata/test/datafile/undotbs1.257.955537817", "/u01/app/oracle/oradata/test/datafile/users.263.955537675", "/u01/app/oracle/oradata/test/datafile/undotbs2.264.955537683", "/u01/app/oracle/oradata/test/datafile/t_newoa2012.258.955537815", "/u01/app/oracle/oradata/test/datafile/index_newoa2012.268.955537677", "/u01/app/oracle/oradata/test/datafile/patrol.267.955537675", "/u01/app/oracle/oradata/test/datafile/t_newoa2012.277.967367381", "/u01/app/oracle/oradata/test/datafile/t_newoa2012.279.980068971", "/u01/app/oracle/oradata/test/datafile/t_newoa2012.280.986462143"; switch clone datafile all; } executing Memory Script executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME renamed tempfile 1 to /u01/app/oracle/oradata/test/tempfile/temp.271.955540229 in control file renamed tempfile 2 to /u01/app/oracle/oradata/test/tempfile/patrol_temp.265.955540229 in control file renamed tempfile 3 to /u01/app/oracle/oradata/test/tempfile/temp.278.970137809 in control file cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/test/datafile/sysaux.259.955537689 RECID=1 STAMP=991768348 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/test/datafile/undotbs1.257.955537817 RECID=2 STAMP=991768348 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/test/datafile/users.263.955537675 RECID=3 STAMP=991768348 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/test/datafile/undotbs2.264.955537683 RECID=4 STAMP=991768348 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/test/datafile/t_newoa2012.258.955537815 RECID=5 STAMP=991768348 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/test/datafile/index_newoa2012.268.955537677 RECID=6 STAMP=991768348 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/test/datafile/patrol.267.955537675 RECID=7 STAMP=991768348 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/test/datafile/t_newoa2012.277.967367381 RECID=8 STAMP=991768348 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/test/datafile/t_newoa2012.279.980068971 RECID=9 STAMP=991768348 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/test/datafile/t_newoa2012.280.986462143 RECID=10 STAMP=991768348 datafile 2 switched to datafile copy input datafile copy RECID=1 STAMP=991768348 file name=/u01/app/oracle/oradata/test/datafile/sysaux.259.955537689 datafile 3 switched to datafile copy input datafile copy RECID=2 STAMP=991768348 file name=/u01/app/oracle/oradata/test/datafile/undotbs1.257.955537817 datafile 4 switched to datafile copy input datafile copy RECID=3 STAMP=991768348 file name=/u01/app/oracle/oradata/test/datafile/users.263.955537675 datafile 5 switched to datafile copy input datafile copy RECID=4 STAMP=991768348 file name=/u01/app/oracle/oradata/test/datafile/undotbs2.264.955537683 datafile 6 switched to datafile copy input datafile copy RECID=5 STAMP=991768348 file name=/u01/app/oracle/oradata/test/datafile/t_newoa2012.258.955537815 datafile 7 switched to datafile copy input datafile copy RECID=6 STAMP=991768348 file name=/u01/app/oracle/oradata/test/datafile/index_newoa2012.268.955537677 datafile 8 switched to datafile copy input datafile copy RECID=7 STAMP=991768348 file name=/u01/app/oracle/oradata/test/datafile/patrol.267.955537675 datafile 9 switched to datafile copy input datafile copy RECID=8 STAMP=991768348 file name=/u01/app/oracle/oradata/test/datafile/t_newoa2012.277.967367381 datafile 10 switched to datafile copy input datafile copy RECID=9 STAMP=991768348 file name=/u01/app/oracle/oradata/test/datafile/t_newoa2012.279.980068971 datafile 11 switched to datafile copy input datafile copy RECID=10 STAMP=991768348 file name=/u01/app/oracle/oradata/test/datafile/t_newoa2012.280.986462143 Reenabling controlfile options for auxiliary database Executing: alter database add supplemental log data Executing: alter database force logging contents of Memory Script: { Alter clone database open resetlogs; } executing Memory Script database opened Finished Duplicate Db at 20181109 19:12:52 released channel: dev1 released channel: dev2 released channel: dev3 released channel: dev4 released channel: dev5