[Oracle][Data Guard]Oracle11g Active Data Guard#3Check redo apply

[Oracle][Data Guard]Oracle11g Active Data Guard#2Check redo apply


这篇来测试11g data guard最大的改变,这也是小弟最期待已久的功能。

取消redo apply process

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

image

如还有session请先结束所有session

alter database recover managed standby database finish;

open physics standby db read only

alter database open read only;

image

在physocs standby 开启状态下,尝试Open redo apply

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

image

成功开启redo apply后测试是否同步

Insert data(65225)--先塞数据

Alter system switch logfile;--手动交换logfile seq

开启状态下查看apply状况

SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME,t.APPLIED FROM V$ARCHIVED_LOG t ORDER BY SEQUENCE#;

image

image

image

运行正常;physics db可以在open read only mode下顺便redo apply 大大提高physics db可用性。

下篇小弟将测试Physics standby convert to Snapshot standby。