11g新特性--active dataguard

lsq_008發表於2013-07-04
--在standby端
SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database open;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ ONLY

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ ONLY WITH APPLY

--在primary端刪除部分資料
SQL> select count(*) from test; 

  COUNT(*)
----------
    800000

SQL> delete from test where rownum<=1000;

1000 rows deleted.

SQL> commit;

Commit complete.

--在standby端查詢：
SQL> select count(*) from scott.test;

  COUNT(*)
----------
    800000

SQL> /

  COUNT(*)
----------
    799000

可見，在資料庫open的同時，仍然可以做apply

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/10972173/viewspace-765454/，如需轉載，請註明出處，否則將追究法律責任。

相關文章