Q
Manage Learn to apply best practices and optimize your operations.

How to recover archive logs in Standby database

A SearchOracle.com member asks, "In Standby database, if some archive logs are missing (could not be transferred), then how do you recover?"

In Standby database, if some archive logs are missing (could not be transferred), then how do you recover?
If you are missing archived redo logs, then your Standby database will not be in a consistent state. Even if you were able to skip over the missing log files, some transactions in the new archived redo log files may have a dependency on the missing redo log files. So in this case, you should recreate your Standby from a good backup of your production database. Then apply all archived redo logs since that backup. You might need to generate a new backup of your production database if your most recent backup was taken at some point in time before your missing redo logs were generated.

Dig Deeper on Oracle database administration

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close