oracle dg异构系统,Oracle异构Dataguard配置指南

[oracle@dg3 ~]$ rman targetRecovery Manager: Release 11.2.0.3.0 - Production on Mon Apr 30 17:16:42 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DG (DBID=1695308537)

connected to auxiliary database: DG (not mounted)

RMAN>duplicate target database for standby from active database;

Starting Duplicate Db at 2012-04-30-17:16:48

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=10 device type=DISK

contents of Memory Script:

{

backup as copy reuse

targetfile  '/u01/app/oracle/product/11.2.0/db1/dbs/orapwdg' auxiliary format

'C:\app\oracle\product\11.2.0\dbhome_1\DATABASE\PWDdg.ORA'   ;

}

executing Memory Script

Starting backup at 2012-04-30-17:16:49

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=22 device type=DISK

Finished backup at 2012-04-30-17:16:51

contents of Memory Script:

{

backup as copy current controlfile for standby auxiliary format  'C:\APP\ORACLE\ORADATA\DG\CONTROL01.CTL';

restore clone controlfile to  'C:\APP\ORACLE\FAST_RECOVERY_AREA\DG\CONTROL02.CTL' from

'C:\APP\ORACLE\ORADATA\DG\CONTROL01.CTL';

}

executing Memory Script

Starting backup at 2012-04-30-17:16:51

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

copying standby control file

output file name=/u01/app/oracle/product/11.2.0/db1/dbs/snapcf_dg.f tag=TAG20120430T171651 RECID=2

STAMP=781982213

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

Finished backup at 2012-04-30-17:16:58

Starting restore at 2012-04-30-17:16:58

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: copied control file copy

Finished restore at 2012-04-30-17:17:02

contents of Memory Script:

{

sql clone 'alter database mount standby database';

}

executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script:

{

set newname for tempfile  1 to

"C:\APP\ORACLE\ORADATA\DG\TEMP01.DBF";

switch clone tempfile all;

set newname for datafile  1 to

"C:\APP\ORACLE\ORADATA\DG\SYSTEM01.DBF";

set newname for datafile  2 to

"C:\APP\ORACLE\ORADATA\DG\SYSAUX01.DBF";

set newname for datafile  3 to

"C:\APP\ORACLE\ORADATA\DG\UNDOTBS01.DBF";

set newname for datafile  4 to

"C:\APP\ORACLE\ORADATA\DG\USERS01.DBF";

backup as copy reuse

datafile  1 auxiliary format

"C:\APP\ORACLE\ORADATA\DG\SYSTEM01.DBF"   datafile

2 auxiliary format

"C:\APP\ORACLE\ORADATA\DG\SYSAUX01.DBF"   datafile

3 auxiliary format

"C:\APP\ORACLE\ORADATA\DG\UNDOTBS01.DBF"   datafile

4 auxiliary format

"C:\APP\ORACLE\ORADATA\DG\USERS01.DBF"   ;

sql 'alter system archive log current';

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to C:\APP\ORACLE\ORADATA\DG\TEMP01.DBF in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 2012-04-30-17:17:12

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

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

output file name=C:\APP\ORACLE\ORADATA\DG\SYSTEM01.DBF tag=TAG20120430T171712

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

channel ORA_DISK_1: starting datafile copy

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

output file name=C:\APP\ORACLE\ORADATA\DG\SYSAUX01.DBF tag=TAG20120430T171712

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

channel ORA_DISK_1: starting datafile copy

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

output file name=C:\APP\ORACLE\ORADATA\DG\UNDOTBS01.DBF tag=TAG20120430T171712

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

channel ORA_DISK_1: starting datafile copy

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

output file name=C:\APP\ORACLE\ORADATA\DG\USERS01.DBF tag=TAG20120430T171712

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

Finished backup at 2012-04-30-17:22:51

sql statement: alter system archive log current

contents of Memory Script:

{

switch clone datafile all;

}

executing Memory Script

datafile 1 switched to datafile copy

input datafile copy RECID=2 STAMP=781982566 file name=C:\APP\ORACLE\ORADATA\DG\SYSTEM01.DBF

datafile 2 switched to datafile copy

input datafile copy RECID=3 STAMP=781982566 file name=C:\APP\ORACLE\ORADATA\DG\SYSAUX01.DBF

datafile 3 switched to datafile copy

input datafile copy RECID=4 STAMP=781982566 file name=C:\APP\ORACLE\ORADATA\DG\UNDOTBS01.DBF

datafile 4 switched to datafile copy

input datafile copy RECID=5 STAMP=781982567 file name=C:\APP\ORACLE\ORADATA\DG\USERS01.DBF

Finished Duplicate Db at 2012-04-30-17:23:50