Ask the Expert

Point-in-time recovery

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.

    Requires Free Membership to View

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 first published in December 2003

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: