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

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

On May 5, 10:00 am, "" <> wrote:
> > 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:
Thanks. That was a new feature of RMAN 10g apparently. I haven't tested it so I have not any clue about your problem. Received on Mon May 05 2008 - 03:29:38 CDT

Original text of this message