Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question re applying archive logs

RE: Question re applying archive logs

From: <>
Date: Wed, 21 Nov 2007 07:49:58 -0700
Message-ID: <008f01c82c4d$cad12ff0$6401a8c0@BHAIRAVIPC01>

While I don't have first hand experience, I investigated this capability in the context of Dataguard; open read write, use the database, and flashback to before the resetlogs to continue with the old incarnation and redo application.

This may not be feasible since this may require setting up the flash recovery area and preserve those logs for flash back through reset logs, but it looks like the technology exists for you to do what you need.

-Krish ew.htm

Flashback Database Through RESETLOGS

Flashback Database through RESETLOGS allows flashback logs created prior to a RESETLOGS operation to be utilized for Flashback Database operations. In Oracle Database 10g Release 2, flashback logs are preserved after opening the database with RESETLOGS. This new feature is useful when a long-standing logical error is not discovered until after RESETLOGS is performed, and a flashback prior to RESETLOGS is needed. In an Oracle Data Guard environment, this capability allows a physical standby database that has been opened read-write to later flashback the changes and be converted back to a physical standby database. If a logical error is discovered after a switchover operation, the primary and standby databases can be flashed back to an SCN or a point in time prior to the switchover operation. <unquote>

-----Original Message-----
From: [] On Behalf Of sol beach
Sent: Tuesday, November 20, 2007 2:20 PM To:
Cc:; Subject: Re: Question re applying archive logs

Note:271916.1 - How to roll forward after coldbackup

IMO, the procedure above could be used in this situation.

On Nov 20, 2007 12:08 PM, Dennis Williams <> wrote:
> Bill,
> Sorry, but you can't apply redo logs on a database once you complete the
> recovery and open it. You'll need to start again.
> Have you considered Log Miner?
> Dennis Williams


Received on Wed Nov 21 2007 - 08:49:58 CST

Original text of this message