DG 切换演练测试

准备：
记录 incarnation 号
rman target /
list incarnation;
若时间变更，需要恢复之前的incarnation
reset database to incarnation 旧号码；

演练激活：10.32.68.45
主：10.0.72.106/108
备：10.17.4.51
灾备：10.32.68.45

备库操作：(10.32.68.45)
一、检查并开启备库闪回功能
(1)
show parameter recovery;
SQL> show parameter recovery;

NAME TYPE VALUE

db_recovery_file_dest string +REDO
db_recovery_file_dest_size big integer 159612M
recovery_parallelism integer 0
(2)
select flashback_on from v$database;
SQL> select flashback_on from v$database;

FLASHBACK_ON

NO

alter database recover managed standby database cancel;
shutdown immediate;

startup mount
alter database flashback on;
alter database open;
alter database recover managed standby database using current logfile disconnect;

select OPEN_MODE from v$database;
select flashback_on from v$database;

注意：首先切主库归档

二、主数据库切归档，设置归档传输延迟(10.17.4.51)
(1)
alter system archive log current;
(2)
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_3=DEFER;
(3)
show parameter log_archive_dest_state_3;

三、备库取消日志同步，设置scn断点
(1)
alter database recover managed standby database cancel;
(2)
create restore point hfbudb_scn guarantee flashback database;

四、激活备库
(1)
ALTER DATABASE ACTIVATE STANDBY DATABASE;
(2)
alter database open;
(3)
select open_mode from v$database;

验证1：
在备库创建、insert、删除测试表，表明备库可用：
create table test_0917 (id number);
insert into test_0917 values(1);
commit;
select * from test_0917;
drop table test_0917;

验证2：
主库创建测试表：
create table test_0917 (id number);
待dg恢复运行后，查看主库创建的表是否可以正常同步到备库

恢复备库操作：
五、恢复物理备库到dataguard状态
(1)
shutdown immediate
startup mount
(2)shhxdb_scn
flashback database to restore point hfbudb_scn;
(3)
alter database convert to physical standby;
(4)
shutdown immediate;
startup mount
alter database open;
alter database recover managed standby database using current logfile disconnect;
(5)
修改主库
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_3=enable;

六、检测dataguard状态

select thread#, max(sequence#) from v$archived_log where applied=’YES’group by thread#;
待日志号同步之后，检查验证2中创建的表是否已经同步到备库，验证通过后，主库删除测试表：
drop table test_0917;