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.
-
#OracleDBA #OracleDataGuard #Failover #Switchover
-
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?
-
Your comments encourage us to produce quality content, please take a second and say ‘Hi’ in the comments and let me and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;)
-
Link to full course: https://dbagenesis.com/p/oracle-12c-data-guard-administration
Link to all DBA courses: https://dbagenesis.com/courses
Link to real-time projects: https://dbagenesis.com/p/projects
Link to support articles: https://support.dbagenesis.com
-
DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!!
DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course.
-
Facebook: https://www.facebook.com/dbagenesis/
Instagram: https://www.instagram.com/dbagenesis/
Twitter: https://twitter.com/DbaGenesis
Website: https://dbagenesis.com/
Contact us: https://dbagenesis.com/p/contact
-
Start your DBA Journey Today !!

Видео How to perform step by step manual failover | Oracle Data Guard канала DBA Genesis