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