Re: DBPITR and ORA-16005 Error: database requires recovery.

From: <>
Date: Mon, 5 May 2008 01:00:48 -0700 (PDT)
Message-ID: <>

> Where have you read you can open the database in READONLY mode without
> any resetlogs in this situation?

OracleŽ Database Backup and Recovery Basics:

Sections 7.6.4 and 7.6.5.

 7.6.4 Database Point-in-Time Recovery Within the Current Incarnation.

"If the operation completes without errors, then your DBPITR has succeeded. You can open the database read-only and perform queries as needed to ensure that the effects of the logical corruption have been reversed. If not, you may have chosen the wrong target SCN."

7.6.5 Options After Database Point-in-Time Recovery.

"After a successful DBPITR, your choices are:

  • Export one or more objects from your database using an Oracle export utility such as Data Pump Export. You can then recover the database to the current point in time and re-import the exported objects, as a way to return these objects to their state prior to the unwanted change without abandoning all other changes.
  • Open your database for read-write, abandoning all changes after the target SCN. In such a case, you must open the database with the RESETLOGS option, as shown here: RMAN> ALTER DATABASE OPEN RESETLOGS; "
Received on Mon May 05 2008 - 03:00:48 CDT

Original text of this message