dataguard激活备库为readwrite

若开启闪回

利用flashback 停止dg 建立restore_scn  停止容灾端 进行读写测试 再flashback到restore_scn 开启dg

准备阶段：

dr:

select flashback_on from v$database;

show parameter db_recovery_file

select process,status from v$managed_standby;

alter database recover managed standby database cancel;

create restore point restore_scn guarantee flashback database;

pr:

ALTER SYSTEM ARCHIVE LOG CURRENT;

ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=DEFER;

激活备库

dr:

ALTER DATABASE ACTIVATE STANDBY DATABASE;

ALTER DATABASE OPEN;

使用激活的数据库用于报表或测试

恢复dataguard：

dr：

shutdown immediate

startup mount

flashback database to restore point restore_scn;

alter database convert to physical standby;

select status from v$instance;

shutdown immediate

startup  

alter database recover managed standby database disconnect from session;

pr:

ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=enable;

测试dataguard是否可用

若未开闪回

1、ALTER DATABASE FAILOVER TO 'BSO_CC';

2、ALTER DATABASE CONVERT TO SNAPSHOT STANDBY; --这个要使用FRA

3、ALTER DATABASE ACTIVATE STANDBY DATABASE;