In Oracle : RMAN incomplete recovery

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle DBA

Real Application Cluster (RAC) Maintenance tasks Backup and Recovery Database Architecture Replication Oracle Performance Tuning Oracle DBA - Other articles Oracle scripts/ Selects for DBA Oracle Errors (ORA-nnnnn)

The last articles in the site (HOT)

The most visited articles in the site

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

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.