In the previous article, we have to seen Recovering Primary Database Datafile using Standby Database if it’s not deleted from Standby Database.

Recover Data File in Primary Database in Data Guard Environment

Here we will see what if datafile gets corrupted or deleted from Standby Database.

Step 1: In the below code, we can see When I’m trying to query the job table it gives me the error, file# 5 is not accessible.

In this case shut down database and start it in a mount stage.

Step 2: start the database in mount stage

Step 3: Restore datafile from backup

Step 4: If all archive logs after the restoration of a data file are present in default location then start MRP process.

We can see here after starting recovery we can access the job table.

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:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

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