Oracle 11GR2 Duplicate from Backup

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

connected to recovery catalog database

connected to auxiliary database: testDUP (not mounted)

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

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

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/，如需轉載，請註明出處，否則將追究法律責任。

Oracle 11GR2 Duplicate from Backup

相關文章