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: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis
30 июл 2024
