Home  >  Oracle Database Administration (DBA)  >  Backup & Recovery  >  RMAN Incomplete Recovery (in ARCHIVELOG mode)

Note: The article ( named RMAN Incomplete Recovery (in ARCHIVELOG mode) ) was taken from www.in-oracle.com.

- 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.

Note: The article ( named RMAN Incomplete Recovery (in ARCHIVELOG mode) ) was taken from www.in-oracle.com.