DG broker使用dgmgrl配置及start fast failover

Data guardbroker配置

http://docs.oracle.com/cd/E11882_01/server.112/e17023/cli.htm#i1005573

 

1.配置 dg_broker_config_filen(For RAC)

alter systemset dg_broker_start=false scope=both;

alter systemset dg_broker_config_file1='+DATA1/DGBROKE/DR1.DAT' scope=both;

alter systemset dg_broker_config_file2='+DATA1/DGBROKE/DR2.DAT' scope=both;

2开启闪回

SQL>select flashback_on from V$database;

 

FLASHBACK_ON

------------------

NO

 

ALTER SYSTEM SET UNDO_RETENTION=3600SCOPE=SPFILE;

SHUTDOWN IMMEDIATE;

STARTUP MOUNT;

SHOW PARAMETERUNDO;

ALTER SYSTEM SETDB_FLASHBACK_RETENTION_TARGET=4320 SCOPE=BOTH;

ALTER DATABASEARCHIVELOG;

ALTER SYSTEMSET db_recovery_file_dest='/u01/f