Oracle Database Role transition – switchover and failoverRole using DGMGRL

Channel Avatar
Comment
X
Share
Oracle Database Role transition - switchover and failoverRole using DGMGRL
Oracle Database Role transition – switchover and failoverRole using DGMGRL
A switchover is a role reversal between the primary database and one of its standby databases. A switchover guarantees no data loss. This 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. The transition occurs without having to reenable either database.

A failover is when the primary database (all instances of a RAC primary database) fails and one of the standby databases is transitioned to take over the primary role. Failover is performed only in the event of a catastrophic failure of the primary database, and there is no possibility of recovering the primary database in a timely manner. Failover may or may not result in data loss depending on the protection mode in effect at the time of the failover.

The switchback does not exists as it is a switchover but in the reserve order, which would restore the database back on its original server.

In this video we will test DG switchover, reverse switchover (switchback) and failover using DG broker.

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *