dataguard switchover & failover steps (rac)
角色轉換前的準備工作
l 檢查各資料庫的初始化引數,主要確認對不同角色相關的初始化引數都進行了正確的配置。
l 確保可能成為primary 資料庫的standby 伺服器已經處於archivelog 模式。
l 確保standby 資料庫的臨時檔案存在並匹配primary 資料庫的臨時檔案
l 確保standby 資料庫的RAC 例項只有一個處於open 狀態。(對於rac 結構的standby 資料庫,在角色轉換時只能有一個例項startup。其它rac 例項必須統統shutdown,待角色轉換結束後再startup)
switchover 執行順序先切換主庫,然後切換備庫。
select switchover_status from v$database;
在主庫進行切換,執行如下命令:
===========
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
shutdown immediate;
startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect from session;
alter database recover managed standby database cancel;
alter database open;
alter database recover managed standby database disconnect from session;
===========
檢視切換後的狀態
select DATABASE_ROLE,open_mode from v$database;
在備庫對角色進行切換,在備庫執行如下命令:
===========
sqlplus / as sysdba
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;
=============
select * from v$database;
SELECT * FROM V$DATAGUARD_STATUS;
failover
alter database recover managed standby database finish force;
alter database commit to switchover to primary;
alter database open;
[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/70612/viewspace-1057323/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 邏輯 rac standby和物理 rac standby的switchover 和 failoverAI
- DataGuard SwitchOver
- Oracle 10g DataGuard物理主備切換-switchover與failoverOracle 10gAI
- RAC+Dataguard環境中JDBC Failover配置JDBCAI
- DataGuard:Physical Standby Switchover
- In Data Guard,choose switchover or failover?AI
- dataguard角色轉換—switchover
- Dataguard Physical Standy Switchover
- 10g_dataguard_switchover
- DataGuard:Logical Standby Switchover
- switchover和failover的區別AI
- Data Guard Switchover and Failover Best PracticesAI
- DataGuard:Physical Standby FailoverAI
- Performing a Switchover to a Physical Standby Database and failoverORMDatabaseAI
- Oracle dataguard failover 實戰OracleAI
- 10g_dataguard_failoverAI
- DataGuard:Logical Standby FailoverAI
- DG學習筆記(8)_Switchover and Failover筆記AI
- Dataguard物理Standby Switchover 角色轉換
- oracle dataguard 進行switchover測試Oracle
- Dataguard failover切換實驗AI
- DataGuard模擬FailOver實驗AI
- 【DG】DG之Switchover和Failover的區別AI
- Oracle DataGuard switchover切換一例Oracle
- 【DataGuard】Oracle 11g physical standby switchoverOracle
- 【DATAGUARD】物理dg的switchover切換(五)
- How to configure Client Failover after Data Guard Switchover or Failover [ID 316740.1]clientAI
- openGauss主備切換之switchover與failoverAI
- Oracle Dataguard故障轉移(failover)操作OracleAI
- oracle11g dataguard完全手冊--switchoverOracle
- Oracle 11g Active Dataguard Switchover實驗Oracle
- oracle rac + dataguardOracle
- 【DataGuard】Oracle 11g DataGuard 角色轉換(一)物理備庫SwitchoverOracle
- oracle11g dataguard完全手冊--failover &active dataguard(完)OracleAI
- MySQL高可用之MHA切換測試(switchover & failover)MySqlAI
- Oracle RAC Failover 詳解OracleAI
- oracle rac failover 詳解OracleAI
- oracle rac failover的疑惑OracleAI