Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Recovering a Backup Made Before a RESETLOGS

703998Aug 19 2009 — edited Aug 20 2009
Hi all,

This is a doubt that i'm having with 9i Rman.

Following is from the "9i Recovery manager user's guide":

"You must reset the online redo logs after performing recovery with a backup control file or performing incomplete recovery. After you open a database with the RESETLOGS option, *you cannot typically use the backups of the database made before the RESETLOGS was performed*. Oracle Corporation strongly recommends that you take a full database backup after resetting the online redo logs.

If you experience media failure after a RESETLOGS but before performing a backup, then you may be forced to perform media recovery on a backup taken prior to the last database RESETLOGS. *You should not rely on the procedure to perform media recovery through RESETLOGS as a normal recovery strategy*. Rather, you should resort to it only in a worst-case scenario, such as when no backups are available from after the RESETLOGS."

The same document has a example (page10-45) Recovering a Backup Made Before a RESETLOGS

My questions are,

So if it can be done why do they say "you cannot typically use..." "you should not rely on..." etc.?

Is it a must to have a control file backup of the previous incarnation for the recovery to work as in the Example?

thanks,
Dam
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 17 2009
Added on Aug 19 2009
7 comments
1,770 views