Subscribe YouTube Channel For More Live Tutorials

What is the Difference between Switchover and Failover in Oracle Dataguard?

What is the Difference between Switchover and Failover in Oracle Dataguard?

Simply...we can say..

Switch Over  - is a planned activity
FailOver - Unplanned Activity.
  • A switchover is a role reversal between the primary database and one of its standby databases. A switchover guarantees no data loss and is typically done for planned maintenance of the primary system. During a switchover, the primary database transitions to a standby role, and the standby database transitions to the primary role.
  • A failover is done when the primary database (all instances of an Oracle RAC primary database) fails or has become unreachable and one of the standby databases is transitioned to take over the primary role. Failover may or may not result in data loss depending on the protection mode in effect at the time of the failover.