oracle 11.2.0.1 rac 的 active dataguard的啟動步驟
以下參考oracle 官方文件:
The COMPATIBLE database initialization parameter must be set to 11.0 or higher to use
the real-time query feature of the Active Data Guard option.
A physical standby database instance cannot be opened if Redo Apply is active on a
mounted instance of that database. Use the following SQL statements to stop Redo
Apply, open a standby instance read-only, and restart Redo Apply:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE OPEN;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
以下參考:http://hi.baidu.com/lichangzai/blog/item/bfee39543c154f4d574e0029.html
1. 開啟物理DG時查詢功能(active dataguard)。
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE OPEN;
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ ONLY
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ ONLY WITH APPLY
也就是說,在正常啟動 physical standby database後,需要再執行幾個語句,才能將physical standby database 變為active dataguard狀態
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/161195/viewspace-1053685/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 11g rac 的 active dataguard的啟動步驟Oracle
- 1、啟動oracle的步驟Oracle
- ORACLE啟動步驟Oracle
- oracle啟動的三個步驟Oracle
- Oracle 啟動的三個步驟Oracle
- Oracle10g RAC 關閉及啟動步驟Oracle
- Oracle DataGuard切換步驟Oracle
- 手動進行oracle rac vip 漂移的步驟 。Oracle
- 【RAC】啟動/關閉CRS, OHAS, ASM & RDBMS 的步驟ASM
- VMware中配置ORACLE DATAGUARD步驟Oracle
- Oracle:RAC關閉、啟動、重啟步驟:10g、11gOracle
- Oracle11g RAC (ASM) 及Active Dataguard開啟與關閉 [final]OracleASM
- Step By Step of Configuring Oracle 11gR2 (11.2.0.1) RAC to RAC DataguardOracle
- Oracle資料庫啟動步驟Oracle資料庫
- oracle 伺服器啟動步驟Oracle伺服器
- ORACLE 10G DATAGUARD實戰步驟Oracle 10g
- oracle 啟動 關閉步驟詳解Oracle
- Remove Oracle Rac (11.2.0.1)REMOracle
- ORACLE RAC OCFS(步驟簡要)Oracle
- 最簡單的11g Active DataGuard(ADG)搭建配置過程(專案步驟)
- Oracle 11g Active DataguardOracle
- Oracle 11g dataguard 配置簡約步驟Oracle
- Oracle 11.2 RAC改IP步驟Oracle
- oracle rac + dataguardOracle
- oracle 10.2.0.4 rac 升級到oracle 10.2.0.5 rac步驟Oracle
- 在aix oracle rac 環境下,增加lv的步驟AIOracle
- dataguard手動switchover切換步驟及注意的問題 轉
- Oracle11gR2 Active DataGuardOracle
- Oracle資料庫例項啟動步驟分析Oracle資料庫
- 關於Oracle10g RAC 的開啟關閉標準步驟問題Oracle
- ORACLE DataGuard 關閉啟動Oracle
- Oracle RAC叢集解除安裝步驟Oracle
- Oracle 11.2 RAC改 Private IP步驟Oracle
- RAC資料庫啟用歸檔和閃回的步驟資料庫
- Linux Oracle 11g Dataguard配置詳細步驟LinuxOracle
- Oracle active dataguard ORA-01555Oracle
- 關閉開啟Oracle10g RAC(OCFS2)系統步驟Oracle
- 轉貼:上週ORACLE RAC培訓時的安裝RAC的詳細步驟(一)Oracle