Performing Incomplete Recovery - RMAN Recipes for Oracle Database 12c - page 380

3. You initiate a point in time recovery prior to the time the database was opened with the

open resetlogs command:

RMAN> restore database until time
"to_date('28-aug-2012 08:22:00','dd-mon-rrrr hh24:mi:ss')";
When restoring datafiles, the prior command throws this error:

RMAN-03002: failure of restore command at ...
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time

In this situation you must restore and recover to a previous incarnation of your database.

Solution
Before starting, ensure that you set the NLS_DATE_FORMAT variable so that you can see the time component in
RMAN's output:

$ export NLS_DATE_FORMAT="DD-MON-RRRR HH24:MI:SS"

This will allow you to see the time component in RMAN's output.

Step 1: Run the List Incarnation Command
You have to restore a control file that knows about the incarnation of the database to which you want to restore.
Therefore, you first need to determine which incarnation you will be restoring to. Run the following command to
display incarnation information:

RMAN> list incarnation;

Here is some sample output:

DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
14 14 O12C 3415120612 PARENT 1376388 28-aug-2012 08:19
15 15 O12C 3415120612 CURRENT 1377144 28-aug-2012 08:35

For this example, we want to restore to the time of 8:22 (which would be incarnation 14, which is prior to the
current incarnation of 15).

Step 2: Shut Down the Database

RMAN> shutdown immediate;

Step 3: Start the Database in Nomount Mode
If you're not using a recovery catalog, start up this way:

RMAN> startup nomount;