First page Back Continue Last page Graphics

Flashback Database TO BEFORE RESETLOGS


Notes:

Release 2 of Oracle 10g introduces the “TO BEFORE RESETLOGS” clause of the FLASHBACK DATABASE statement. It provides an easy way to flashback across a RESETLOGS operation – to restore to the previous incarnation of the database. (It is actually supported by the same new architecture that supports the “simplified recovery across resetlogs operations”, discussed later in this lesson.) The FLASHBACK DATABASE TO BEFORE RESETLOGS statement provides an easy way to undo an OPEN RESETLOGS operation.
You can see available incarnations by querying the V$DATABASE_INCARNATION view.
See Chapter 7 of the Backup and Recovery Basics manual for more information and examples of this feature. Also refer to the Oracle Backup and Recovery Reference 10g Release 2 and the Oracle Database SQL Reference 10g Release 2 for syntax and more information on the FLASHBACK DATABASE statement.