In Data Guard,choose switchover or failover?
Switchover
Allows the primary database to switch roles with one of its standby databases.There is no data loss during a switchover. After a switchover, each database continues to participate in the Data Guard configuration with its new role.
Failover
Transitions a standby database to the primary role in response to a primary database failure. If the primary database was not operating in either maximum protection mode or maximum availability mode before the failure, some data loss may occur. After a failover, the failed database no longer participates in the Data Guard configuration.
During any role transition, the amount of downtime required to complete the operation, the potential for data loss, and the effects on other standby databases in the configuration are determined by:
The state of the primary database just before the transition
The state of the standby database selected for the role transition at the time of the transition
If the selected standby database is configured as a physical standby database or a logical standby database
If the role transition is a switchover or a failover
How much redo data remains to be applied to the selected standby database
Whether or not a standby redo log is configured on the standby database
Whether or not redo log files were previously created for the target standby database
The goal is to perform the role transition as quickly as possible with little or no data loss.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/38542/viewspace-923789/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Data Guard Switchover and Failover Best PracticesAI
- Data Guard中快速Switchover,Failover的一些建議AI
- How to configure Client Failover after Data Guard Switchover or Failover [ID 316740.1]clientAI
- data guard switchover on solaris 10
- oracle10g data guard role transition_physical_logical_switchover_failoverOracleAI
- 不停機 data guard 以及 switchover
- Oracle Data Guard Failover(activate)OracleAI
- data guard failover on solaris 10AI
- DATA GUARD物理STANDBY的 SWITCHOVER切換
- 10g Data Guard physical standby的主備庫角色轉換測試(switchover & failover)AI
- 【DG】Data Guard主備庫Switchover切換
- DATA GUARD物理備庫的SWITCHOVER切換
- DATA GUARD物理STANDBY的 SWITCHOVER切換[zt]
- 【DataGuard】物理Data Guard之Failover轉換AI
- DATA GUARD物理STANDBY的FAILOVER切換AI
- data guard物理備份方式中的switchover轉換
- 玩轉Data Guard的switchover後切不回主庫
- Data Guard Broker系列之六:Fast-Start FailoverASTAI
- Data Guard高階玩法:通過閃回恢復switchover主庫
- switchover和failover的區別AI
- Oracle 12c Data guard 物理主備庫正常切換(switchover)流程Oracle
- Oracle 11g Data guard 物理主備庫正常切換(switchover)流程Oracle
- Data Guard高階玩法:通過閃回恢復failover備庫AI
- Oracle Data Guard快速啟動故障切換 - fast-start failover(FSFO)OracleASTAI
- [20160222]Oracle 11G Data Guard FailoverOracleAI
- Oracle 12c Data guard 物理備庫應急切換(failover)流程OracleAI
- Oracle 11g Data guard 物理備庫應急切換(failover)流程OracleAI
- Performing a Switchover to a Physical Standby Database and failoverORMDatabaseAI
- dataguard switchover & failover steps (rac)AI
- DATA GUARD部署模式——DATA GUARD概念和管理模式
- 【DataGuard】使用Grid Control對Oracle物理Data Guard進行Switchover切換Oracle
- 介紹ORACLE DATA GUARD——DATA GUARD概念和管理Oracle
- DG學習筆記(8)_Switchover and Failover筆記AI
- Data guard搭建
- oracle data guard!!Oracle
- oracle9i(9204)data guard(dg)_logical standby_failover操作指南OracleAI
- 盛哥學習 Data Guard 第三篇《物理standby之switchover 無損切換》
- 【DG】DG之Switchover和Failover的區別AI