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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.