Please visit for Videos, Free posts, Books, Webinar and Free forum … ALL about Oracle!

Performing a recovery after a RESETLOGS operation

The resetlogs clause is required in most incomplete recovery to open the database.
In versions prior to 10g, this command invalidated the backups you already have.
From Oracle 10g, this problem has been fixed and the process behind the “”resetlogs” command has been reviewed. In order to demonstrate that, I have simulated 2 successive disasters.
The explanation of the commands performed in this demonstration is in the scope of this article.

You can see in the last screen, the second recover without “resetlogs” have reset the logs from the last available archivelog. In this demonstration, the complete recovery succeed using the backup made before the first apply of the “resetlogs” command. As a conclusion, from 10g it is possible to perform a complete recovery using the backup performed before the incomplete recovery (with resetlogs command).
It’s possible to Perform a recovery after a RESETLOGS operation using the same backup.
(Sorry about the quality of the images, you can watch them better by clicking on them. I will soon replace them by screens with better quality).


1 Comment »

  1. Hello, Sorry but I dont understand exactly what happened to you.
    Could you explain more?

    Comment by orawiss — January 23, 2011 @ 8:11 pm | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: