Oracle Data Guard – Recover Standby Database Using Incremental Backup – Resolve Log Gap

Channel Avatar
Comment
X
Share
Oracle Data Guard - Recover Standby Database Using Incremental Backup - Resolve Log Gap
Oracle Data Guard – Recover Standby Database Using Incremental Backup – Resolve Log Gap
In this video we are going to talk about how to recover from a situation when the archived logs are deleted before they were applied on the standby and there is no backup of the archived logs available. This situation will develop a log gap in the standby causing it to be out of sync with the primary. I will demonstrate using an incremental backup from the primary, how we can resolve the log gap and bring the standby database back into sync with the primary.

The series /”You – The Oracle Expert/” is for Oracle enthusiasts where I cover different Oracle database related topics.

Oracle data guard is an indispensable part of oracle’s high availability solutions. In a real world scenario the Primary and Physical standby databases reside on geographically different locations or different data centers to make sure that even if one region goes completely down, your database is still available and intact. In this tutorial I am using a virtual environment for demonstration purpose.

Commands and SQLs used :
https://docs.google.com/document/d/1CL_-K2v_3H4ufyMb0rbrjmK_pln0Fv4sFLawGebKvRQ/edit?uspsharing

My other series on YouTube:

Mastering OEM 13c (Full Series):
https://www.youtube.com/playlist?listPLgWj5dy2RoFZLk49TIxMjW5g8C5K0ntjq

Setting up OEM Notification, Monitoring and Alerting:
https://youtu.be/j9bA-xagpsY

Oracle VirtualBox Virtual Machines:
https://www.youtube.com/playlist?listPLgWj5dy2RoFZTLn2tIdZ-P0Yhj_WbOQ9U

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 *