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

preview_player
Показать описание
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 :

My other series on YouTube:
===========================

Mastering OEM 13c (Full Series):

Setting up OEM Notification, Monitoring and Alerting:

Oracle VirtualBox Virtual Machines:
Рекомендации по теме
Комментарии
Автор

Very informative video keed uploading..

Dancewithsaigite
Автор

Good explanation thanks for sharing video.I have one doubt here current scn is not same both primary standby difference is 1276.

PavanKumar-fteq
Автор

it was very nice explanation, thank you.

yrvzpoy
Автор

Hello, If i am not correct we need to catalog the backup pieces .. After restoring control file we need to catalog backup pieces then existing datafiles . then we need to recover database. Please confirm on this
Recovery of Standby DB Command Sequence


SQL> shutdown immediate
SQL> startup nomount

RMAN> RESTORE STANDBY CONTROLFILE FROM
alter database mount;

catalog start with

SWITCH DATABASE TO COPY;

RMAN> recover database noredo;


Check the SCN’s in primary and standby:

shashiranjancse