oracle 11g active dataguard,配置Oracle 11g Active Dataguard

[oracle@dg2 ~]$ rman target sys/123456@dg1 auxiliary sys/123456@dg2 Recovery Manager: Release 11.2.0.3.0 - Production on Sun Apr 22 13:38:33 2012 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to tar

[oracle@dg2 ~]$ rman targetsys/123456@dg1auxiliarysys/123456@dg2Recovery Manager: Release 11.2.0.3.0 - Production on Sun Apr 22 13:38:33 2012

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

connected to target database: DG (DBID=1694605607)

connected to auxiliary database: DG (not mounted)

RMAN> duplicate target database for standby nofilenamecheck from active database;

Starting Duplicate Db at 2012-04-22-13:39:25

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=134 device type=DISK

contents of Memory Script:

{

backup as copy reuse

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

'/u01/app/oracle/product/11.2.0/db1/dbs/orapwdg' ;

}

executing Memory Script

Starting backup at 2012-04-22-13:39:26

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=19 device type=DISK

Finished backup at 2012-04-22-13:39:28

contents of Memory Script:

{

backup as copy current controlfile for standby auxiliary format

'/u01/app/oracle/oradata/dg/control01.ctl';

restore clone controlfile to '/u01/app/oracle/fast_recovery_area/dg/control02.ctl' from

'/u01/app/oracle/oradata/dg/control01.ctl';

}

executing Memory Script

Starting backup at 2012-04-22-13:39:29

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=TAG20120422T133929 RECID=1

STAMP=781277970

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

Finished backup at 2012-04-22-13:39:32

Starting restore at 2012-04-22-13:39:32

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: copied control file copy

Finished restore at 2012-04-22-13:39:34

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

"/u01/app/oracle/oradata/dg/temp01.dbf";

switch clone tempfile all;

set newname for datafile 1 to

"/u01/app/oracle/oradata/dg/system01.dbf";

set newname for datafile 2 to

"/u01/app/oracle/oradata/dg/sysaux01.dbf";

set newname for datafile 3 to

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

set newname for datafile 4 to

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

backup as copy reuse

datafile 1 auxiliary format

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

2 auxiliary format

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

3 auxiliary format

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

4 auxiliary format

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

sql 'alter system archive log current';

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/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-22-13:39:42

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=/u01/app/oracle/oradata/dg/system01.dbf tag=TAG20120422T133943

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

channel ORA_DISK_1: starting datafile copy

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

output file name=/u01/app/oracle/oradata/dg/sysaux01.dbf tag=TAG20120422T133943

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

channel ORA_DISK_1: starting datafile copy

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

output file name=/u01/app/oracle/oradata/dg/undotbs01.dbf tag=TAG20120422T133943

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

channel ORA_DISK_1: starting datafile copy

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

output file name=/u01/app/oracle/oradata/dg/users01.dbf tag=TAG20120422T133943

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

Finished backup at 2012-04-22-13:45:05

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=1 STAMP=781278308 file name=/u01/app/oracle/oradata/dg/system01.dbf

datafile 2 switched to datafile copy

input datafile copy RECID=2 STAMP=781278308 file name=/u01/app/oracle/oradata/dg/sysaux01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=3 STAMP=781278308 file name=/u01/app/oracle/oradata/dg/undotbs01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=4 STAMP=781278308 file name=/u01/app/oracle/oradata/dg/users01.dbf

Finished Duplicate Db at 2012-04-22-13:45:29

RMAN> exit

Recovery Manager complete.

本文原创发布php中文网，转载请注明出处，感谢您的尊重！