Q

Point-in-time recovery

Full point-in-time recovery isn't possible with a corrupted archive log file.

I'm taking cold backups weekly (Sundays) and the database is running on archive log mode. Now my database crashed on Saturday night, and I'm applying my archive files to recover it. But I found that out of 1,000 archive files, the 997th file is corrupted. Now will it be possible to get point-in-time recovery? And if yes then please let me know how.
No, full point-in-time recovery won't be possible with a corrupted archive log file. You'll have to stop after the 996th file.
This was last published in December 2003

Dig Deeper on Oracle database backup and recovery

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close