How to perform step by step manual failover Oracle Data Guard

Channel Avatar
Comment
X
Share
How to perform step by step manual failover Oracle Data Guard
How to perform step by step manual failover Oracle Data Guard
In manual failover, we can perform Complete Failover and Immediate Failover. In the complete #FailOver, it attempts to minimize #data loss by applying all #redo log generated on Primary #Database will be applied to a #standby database. This is the default method of failover.
In immediate failover, no additional data is applied on a standby database. This is fastest and we need to explicitly define this.

00:00 What is a Failover?
06:00 Crash primary database
08:08 Minimize data loss
09:17 Check for redo gap
11:00 Start failover
13:03 Check client query

Rebuild Primary
17:53 Rebuild Primary after failover
18:46 Find SCN at which standby become primary
21:24 Flashback crashed primary database
24:39 Convert crashed primary to physical standby
28:24 Revert to the original configuration
28:51 Perform manual switchover
29:07 Convert primary to standby
29:49 Convert standby to primary
30:14 On new standby-Initially your primary database:Start MRP
32:04 RMAN in Data Guard Configuration
32:39 How do you register a standby database to catolog?
33:00 Backup control file on primary
34:35 Set proper retention policy
35:49 How do you register with primary database with catalog?

Website: https://www.dbagenesis.com/
Facebook: https://www.facebook.com/dbagenesis/
Instagram: https://www.instagram.com/dbagenesis/
Twitter: https://twitter.com/DbaGenesis

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 *