Recovering a Backup Made Before a RESETLOGS
703998Aug 19 2009 — edited Aug 20 2009Hi 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