To perform point-in-time recovery to the older incarnation

 To perform point-in-time recovery to the older incarnation, use the following steps:

 

There are two requirements for this type of a point-in-time recovery:

• You must reset the current incarnation of the database back to the incarnation to which your

target SCN belongs.

• You must use the control file from the older incarnation that contains the target SCN.

1. Find out the incarnation key for the incarnation that was current at the time you want to

recover your database to.

 You can find it in the incarnation key column of the output of RMAN’s  LIST INCARNATION command.

 Let’s say our incarnation key value for this example is 5.

2. Start the database in the following way:

RMAN> STARTUP FORCE NOMOUNT;

3. Reset the current incarnation to the incarnation that was current at the point in time that

you want to recover to:

RMAN> RESET DATABASE TO INCARNATION 5;

4. Restore the old control file from a backup and mount the database with the following

commands:

RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP;

RMAN> ALTER DATABASE MOUNT;

5. Restore and recover the database until the point in time or the SCN:

RMAN> RESTORE DATABASE;

RMAN> RECOVER DATABASE UNTIL SCN 1000;

6. Open the database after resetting the online log files:

RMAN> ALTER DATABASE OPEN RESETLOGS;

This feature comes in handy when you perform a point-in-time recovery or a recovery using a backup control file. 

In these cases, you can still use the backup from before the RESETLOGS operation.

:)