ITPub博客

Oracle 11GR2 Duplicate from Backup

原创 Oracle 作者:abstractcyj 时间:2018-11-09 18:40:48 0 删除 编辑

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


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8520577/viewspace-2219486/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2010-01-26

  • 博文量
    537
  • 访问量
    762233