In-Oracle.com  -> Oracle DBA -> Oracle Database Backup and Recovery

-> RMAN incomplete recovery

 RMAN incomplete recovery (in ARCHIVELOG mode)

- Using the TIME parameter:

run { 
      shutdown immediate;
      startup mount;
      set until time "to_date('May 17 2008 10:20:09 pm','Mon DD YYYY HH:MI:SS am')";
      restore database;
      recover database;
      alter database open resetlogs;
}

- Using the SCN parameter:

run { 
      shutdown immediate;
      startup mount;
      set until scn 3400; 
      restore database;
      recover database;
      alter database open resetlogs;
}

- Using the SEQUENCE parameter:

run { 
      shutdown immediate;
      startup mount;
      set until sequence 12903;
      restore database;
      recover database;
      alter database open resetlogs;
}

NOTE: The incomplete recovery requires the database to be opened using the RESETLOGS option.

In-Oracle.com  -> Oracle DBA -> Oracle Database Backup and Recovery

-> RMAN incomplete recovery