In this Post, We will see How enabling Flashback helps us in case of Primary Database resetlogs.

Flashback Database and it’s Benefits in Data Guard Environment

Here I am simulating a scenario of Point in Time Recovery.

My standby database is in sync with Primary Database and I have restored an old backup in Primary Database and doing incomplete media recovery.

Now of course as this is incomplete media recovery I need to open my database with resetlogs.

Step 1: recovery with until sequence clause.

Step 2: Open Database with a resetlogs option :

Step 3: I am trying to start recovery on a standby database.

Now see what alert log says when I applied recovery :

Alert log says MRP detected orphaned datafiles !!

Now here flashback will help us.

Find SCN that is 2 number less than resetlogs_change#.

1.On PRIMARY :

2. Query the V$DATABASE to check current scn number.

We can see here standby SCN is greater than Primary SCN.

3. Flashback database to SCN we have determined in Step 1.

ALERT LOG at time of flashback database .

4. Now we can start recovery on standby.

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel : https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.