Oracle异构Dataguard配置指南

q6542125

　　[oracle@dg3 ~]$ rman target sys/123456@dg3 auxiliary sys/123456@dg4

　　Recovery Manager:>　　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:>　　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:>　　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