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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【DG】Data Guard主備庫Switchover切換
- openGauss主備切換之switchover與failoverAI
- MySQL高可用之MHA切換測試(switchover & failover)MySqlAI
- Oracle 19C Data Guard基礎運維-07 failover後閃回恢復dg架構Oracle運維AI架構
- Oracle Data Guard Broker元件Oracle元件
- Oracle Data Guard簡介Oracle
- 單機搭建Data Guard
- oracle 19c使用dgmgrl來執行switchover和failover切換OracleAI
- 【DG】Data Guard搭建(physical standby)
- 1 關於 Oracle Data GuardOracle
- 2 Oracle Data Guard 安裝Oracle
- 1 Oracle Data Guard Broker 概念Oracle
- bd_ticket_guard_client_dataclient
- Oracle Data Guard和Broker概述Oracle
- 使用Data Guard Broker進行Data Guard物理備用庫配置(Oracle 19c)Oracle
- 8 Oracle Data Guard Broker 屬性Oracle
- 9 Oracle Data Guard 故障診斷Oracle
- Bd-Ticket-Guard-Client-Data逆向client
- oracle 11g data guard維護Oracle
- 4.1.6 Oracle Restart 與 Oracle Data Guard 整合OracleREST
- 【DATAGUARD】Oracle19c Data Guard BrokerOracle
- 2 開始實用 Oracle Data GuardOracle
- 19 Oracle Data Guard 相關檢視Oracle
- 6 Oracle Data Guard Protection Modes 保護模式Oracle模式
- 【DG】Data Guard主備庫Failove切換AI
- 15 Oracle Data Guard Scenarios 保護場景OracleiOS
- A Oracle Data Guard Broker 升級和降級Oracle
- Oracle 12.2 How to Generate AWRs in Active Data Guard Standby DatabasesOracleDatabase
- Oracle Data Guard Feature 12cR2系列(二)Oracle
- Oracle Data Guard Feature 12cR2系列(一)Oracle
- 【ASK_ORACLE】Oracle Data Guard(一)DG架構Oracle架構
- 18 與Oracle Data Guard 相關的SQL語句OracleSQL
- [20221111]19c配置Data Guard Broker問題.txt
- 使用Broker管理Data Guard——停用、改保護模式等模式
- 需要了解的Data Guard理論知識(一)
- 需要了解的Data Guard理論知識(二)
- 需要了解的Data Guard理論知識(三)
- 【mos 1265700.1】Oracle Patch Assurance - Data Guard Standby-First Patch ApplyOracleAPP
- [20201110]How to get the Data Guard broker configuration from a SQL query.txtSQL