這篇來測試11g data guard最大的改變，這也是小弟最期待已久的功能。
取消redo apply process
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

如還有session請先結束所有session
alter database recover managed standby database finish;

open physics standby db read only
alter database open read only;

在physocs standby 開啟狀態下，嘗試Open redo apply
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

成功開啟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#;



運作正常；physics db可以在open read only mode下順便redo apply 大大提高physics db可用性。

下篇小弟將測試Physics standby convert to Snapshot standby。