Oracle 11GR2 Duplicate from Backup

最新推荐文章于 2022-09-14 17:08:58 发布
最新推荐文章于 2022-09-14 17:08:58 发布
阅读量240 收藏
点赞数
文章标签： 数据库

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8520577/viewspace-2219486/

congsong2560
关注
Oracle 11G ADG 搭建 RAC to Single 详细教程（RMAN DUPLICATE）
LuciferLiu_DBA
12-06 1万+
Oracle ADG
Linux环境上部署Oracle11gR2并搭建ADG，成功实践
DoubleJing的博客
11-07 2113
一.搭建环境 虚拟机系统： CentOS6.10(final)（64位） 数据库版本： Oracle 11gR2 11.2.0.4 （64位） IP地址规划： 192.168.88.111 192.168.88.112 SID:fsda SID:fsdb db_name:pri db_name:pri db_unique_name:fsda db_unique_...
duplicate database 复制数据库
lyfhehe的博客
03-26 1121
duplicate database 关于复制数据库的几点总结： 1、Starting with Oracle Database 12c, the version of the RMAN client, target database, and auxiliary database must be the same. 也就是说不能在不同的版本上使用复制数据库的方式 2、测试过程中，在...
duplicate 数据库 from backupset [oracle 11.2.0.3 + asm] => [oracle 11.2.0.3 + fs ]
weixin_30740295的博客
05-11 117
参考 rhel64_11gr2_asm.txt 安装好另一台机器的rhel6.4，gi software，rdbms software。 vi /etc/hosts 10.1.1.35 asmnode 10.1.1.36 asmnodedup 在asmnode 节点 查看initdbasm.ora 文件，确保target database 处于归档模式，否则d...
ORACLE 11R2 安装过程。
热门推荐
Rhys learn oracle！
04-01 2万+
系统环境：    ORACLE 11G R2 11.2.0.3.0 + SUSE 10 SP4    oracle software 下载地址：http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html    suse linux下载地址：https://www.suse.com/zh-
Oracle11g ADG部署 duplicate方式（超级详细）
weixin_52444902的博客
09-14 3769
oracle11g版本ADG详细部署
Windows Server 2012 R2环境下配置oracle-11gR2-DataGuard详细过程
gugu0627的博客
08-27 1669
配置前准备 服务器环境 1、VMware Workstation Pro搭建的两台虚拟机，操作系统为Windows Server 2012 R2 ，数据库为Oracle 11g/ 2、主库ip为192.168.43.130 备库ip为192.168.43.129 3、在安装oracle时，主库安装数据库，备库只安装软件 4、oracle安装的路径在E盘，具体安装路径是E:\app\Administrator\，实例名是orcl 5、数据文件放在E:\app\Administrator\orada
Oracle 11gR2 Dataguard配置
Fred、的窃窃私语
04-17 1601
首先关于异构平台搭建DATAGUARD的相关文档参见：http://blog.csdn.net/tianlesoftware/article/details/7241488  本文Win7 64位与Win7 32位 Oracle 11gR2没有影响。 Primary主要参数： 操作系统：window7 64bit 数据库名db_name：orcl1234 实例名oracle_si
Oracle11gR2——RMAN复制数据库的实施
wang_san_shi的专栏
01-12 639
1、测试方法 target database通过rman备份到NFS中，备份信息注册到catalog database，复制过程仅连接auxiliary database（不需要target database以及catalog database），通过备份文件路径，实现复制。 名词解释：auxiliary database（辅助数据库）：将备份复制到的数据库；target databa
Windows 10 环境下oracle 11g r2 dg配置详解
zl386119974的专栏
06-13 2877
Windows 10 环境下oracle 11g r2 dg配置详解 目录 1.主库设置归档模式： 1 2.硬件与数据库安装 2 3.主备库配置过程 2 3.1主库配置 2 3.2备库配置 8 3.3复制主库 10 4.验证是否搭建成功 11 4.1主、备库执行查询命令 11 5 关于 switchover（正常主备切换） 11 (1)首先查询主库切换状态 11 (2)在...
Oracle11gR2使用RMAN duplicate复制数据库——Backup-based database duplicate
weixin_33813128的博客
11-08 277
本实例测试ORACLE 11g使用rman复制数据库。11g的RMAN duplicate可以通过Active database duplicate和Backup-based duplicate两种方法实现。这里的测试使用的是Backup-based duplicate。 应用场景。基于Active database duplicate参考http:/...
oracle同步数据adg_Oracle 11g ADG 部署(duplicate)快速参考
weixin_36371906的博客
02-02 852
本文旨在指导客户完成Oracle 11g的ADG部署工作，主库环境已具备，备库环境已安装完成数据库软件。环境：RHEL 6.8 + Oracle 11.2.0.41.确认主库运行在归档模式这里设置归档存放路径为/u01/arch：mkdir /u01/archchown oracle:oinstall /u01/archSQL>archive log listalter system set...
oracle 11gR2配置ADG (搭建oracle dataguard)
－=海 阔 天 空=－
02-15 3725
感悟 1.从事数据库软件的使用维护工作，看起来似乎很简单，输入几条常用的命令即可解决问题，但是问题在于当系统出现了异常报错时，就变得手足无措不敢进行新的操作，甚至硬着头皮操作，越搞越糟。这些现象说明，我们对软件的运行原理了解的不多，知其然，但不知其所以然。平时看再多的文本资料，不如动手多去实践探索原理本质更有效。 2. 搭建vmware workstation练习环境要舍得投资升级电脑配置。之前，碍于电脑配置低，运行速度慢，重启虚拟机都得等好几分钟，严重影响练习时的效率和心情，对个人来说是一种摧残。一直
oracle 11g ADG部署过程
一束阳光
07-20 6085
一：实验环境介绍 虚拟机系统：    RHEL Linux 6.4（64位） 数据库版本：    Oracle 11gR2 11.2.0.4 （64位） IP地址规划： 主数据库 10.54.22.105  SID：pri db_name:pri db_unique_name：pri 备份数据库 10.54.22.106  SID：std db_name:pri db_u...
Oracle 11g 使用duplicate from active database 创建物理ADG
Fengg--Focus Oracle
02-22 9881
1、概述： 之前使用冷备的方式搭建了一个物理ADG环境，但是由于冷备需要停库。因此在一些大型库上使用这种技术就不怎么实用了，而使用duplicatefrom active database则必免了这种情况，它只需要短暂的重启库让主库参数文件生效，就能完成ADG的搭建。   2、环境说明 Oracle：11.2.0.1.0 OS：redhat 5.7 Primary IP:192.168
oracle rman丢失归档备份集的不完全恢复
冰封郁金香
07-22 1796
如果说要想改成其他的实例名，可以在恢复成功后，用nid命令修改。----------------分割线-------------------------上面看到备份集的SCN是234189095，因为归档备份丢失，所以只能恢复到这个SCN。-----如果是路径不一致要用下面的脚本指定新路径---------------控制文件里，所以如果在恢复的时候，如果实例名不一致，恢复的时候会报错。-----如果是路径相同直接恢复---------------成功启动数据库，且启动过程中alert日志无报错。...
Oracle 11gR2 使用 RMAN duplicate from active database 复制数据库
我思，故我在！--My data life
04-12 1181
在Oracle 10g下，我们可以使用RMAN duplicate 命令创建一个具有不同DBID 的复制库。 到了Oracle 11gR2， RMAN 的duplicate 有2种方法实现：        1. Active database duplication         2. Backup-based duplication        Active database du
Oracle 11gR2 dataguard搭建说明 --- duplicate方式
木苒的博客
09-30 1585
Oracle 11gR2 dataguard 介绍 Oracle 11gR2 dataguard搭建说明 --- rman方式 1.配置参数文件 主库参数文件 dg.__db_cache_size=26709327872 dg.__java_pool_size=134217728 dg.__large_pool_size=134217728 dg.__oracle_base='/o...
Oracle 11g ADG备库重建
jzzw的博客
05-19 2350
早上接到医院电话，医院的一台备机网断了，恢复网络重启服务器后备库登陆不上了，看了下alert Beginning Standby Crash Recovery. Serial Media Recovery started Managed Standby Recovery starting Real Time Apply Media Recovery Waiting for thread 1 s...
Oracle 11gR2 DataGuard Duplex模式搭建详解
Oracle 11gR2 DataGuard是一种高可用性解决方案，它允许在一个数据库实例（主库）发生故障时，将数据的读写操作切换到另一个备用实例（ standby），以确保业务连续性和数据完整性。本文档详细介绍了如何使用...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值