当DG进行failover之后重新恢复DG(利用rman11gduplicate的ADG特性)(二)

2014-11-24 09:21:33 · 作者: · 浏览: 1
bf";

set newname for datafile 3 to

"/u01/app/oracle/oradata/felix/undotbs01.dbf";

set newname for datafile 4 to

"/u01/app/oracle/oradata/felix/users01.dbf";

set newname for datafile 5 to

"/u01/app/oracle/oradata/felix/example01.dbf";

backup as copy reuse

datafile 1 auxiliary format

"/u01/app/oracle/oradata/felix/system01.dbf" datafile

2 auxiliary format

"/u01/app/oracle/oradata/felix/sysaux01.dbf" datafile

3 auxiliary format

"/u01/app/oracle/oradata/felix/undotbs01.dbf" datafile

4 auxiliary format

"/u01/app/oracle/oradata/felix/users01.dbf" datafile

5 auxiliary format

"/u01/app/oracle/oradata/felix/example01.dbf" ;

sql 'alter system archive logcurrent';

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to/u01/app/oracle/oradata/felix/temp01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 26-MAR-14

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

input datafile file number=00001name=/u01/app/oracle/oradata/felix/system01.dbf

output filename=/u01/app/oracle/oradata/felix/system01.dbf tag=TAG20140326T162424

channel ORA_DISK_1: datafile copy complete,elapsed time: 00:02:05

channel ORA_DISK_1: starting datafile copy

input datafile file number=00002name=/u01/app/oracle/oradata/felix/sysaux01.dbf

output filename=/u01/app/oracle/oradata/felix/sysaux01.dbf tag=TAG20140326T162424

channel ORA_DISK_1: datafile copy complete,elapsed time: 00:01:36

channel ORA_DISK_1: starting datafile copy

input datafile file number=00005name=/u01/app/oracle/oradata/felix/example01.dbf

output filename=/u01/app/oracle/oradata/felix/example01.dbf tag=TAG20140326T162424

channel ORA_DISK_1: datafile copy complete,elapsed time: 00:01:06

channel ORA_DISK_1: starting datafile copy

input datafile file number=00003name=/u01/app/oracle/oradata/felix/undotbs01.dbf

output filename=/u01/app/oracle/oradata/felix/undotbs01.dbf tag=TAG20140326T162424

channel ORA_DISK_1: datafile copy complete,elapsed time: 00:00:25

channel ORA_DISK_1: starting datafile copy

input datafile file number=00004name=/u01/app/oracle/oradata/felix/users01.dbf

output filename=/u01/app/oracle/oradata/felix/users01.dbf tag=TAG20140326T162424

channel ORA_DISK_1: datafile copy complete,elapsed time: 00:00:15

Finished backup at 26-MAR-14

sql statement: alter system archive logcurrent

contents of Memory Script:

{

switch clone datafile all;

}

executing Memory Script

datafile 1 switched to datafile copy

input datafile copy RECID=2 STAMP=843236998file name=/u01/app/oracle/oradata/felix/system01.dbf

datafile 2 switched to datafile copy

input datafile copy RECID=3 STAMP=843236998file name=/u01/app/oracle/oradata/felix/sysaux01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=4 STAMP=843236998file name=/u01/app/oracle/oradata/felix/undotbs01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=5 STAMP=843236998file name=/u01/app/oracle/oradata/felix/users01.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=6 STAMP=843236998file name=/u01/app/oracle/oradata/felix/example01.dbf

Finished Duplicate Db at