Re: restore database to older version after resetlog?

From: vm22 <vivekmarwaha_at_gmail.com>
Date: 2 Dec 2005 01:29:08 -0800
Message-ID: <1133515748.397702.158670@o13g2000cwo.googlegroups.com>

Hello,

Once you have done resetlogs, you create a new incarnation of the database. From Oracle documentation, and from common sense, you can go back to a previous incarnation of the database.

Here is an extract from Oracle Documentation: "RMAN can reset a database to a previous incarnation. For example, if you perform a RESETLOGS operation on database prod1 on Tuesday, you can use RMAN to reset the current database incarnation to Monday's incarnation and restore backups and archived redo logs associated with it. For this reason, backups from previous incarnations are in some cases still usable."

This is assuming that you are in archivelog mode and you still have the previous archivelogs. Received on Fri Dec 02 2005 - 03:29:08 CST