Recovering database that crashed an hour after backup was taken

I took a logical backup at 5 o'clock and then a physical backup at 6 o'clock. My database crashed at 7 o'clock. What can I recover?

    Requires Free Membership to View

Are you running in archive log mode? If not, then you can only restore up to the point your backup was taken, i.e., 6:00. If you are running in archive log mode, then you can restore your datafiles from the backup and roll forward to the point of failure.

This was first published in February 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.