4.7. Performing a Recovery after a RESETLOGS Operation

The RESETLOGS clause is required in most incomplete recovery situations to open the database. This clause resets the redo log sequence for the Oracle database. In versions prior to Oracle 10g, this was a critical point because this invalidated your ability to use the backups prior to the use of RESETLOGS to recover again past the point of issuing the RESETLOGS. This is one of the reasons Oracle support always advised customers to take backup immediately following incomplete recovery.

In Oracle 10g, this problem has been remedied. Oracle has made revisions to the process of recovering through the RESETLOGS point. This new feature is internal to the recovery process; you don't need to do anything. ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.