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

cherry-zcw · July 03, 2019 · 1 hits

[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。

No Reply at the moment.
You need to Sign in before reply, if you don't have an account, please Sign up first.