Visit Counter

Saturday, June 2, 2012

Oracle Database Point In Time Recovery
















Database point-in-time recovery (DBPITR) restores the database from backups prior to the target time
for recovery, then use incremental backups and redo to roll the database forward to the target time.





Recover Archive Redo Logs Files



Catalog the missing archives to the controlfile as follow.


RMAN> catalog archivelog '/ora_dat/arc/1_14372_694624922';


RMAN> catalog start with '/ora_dat/arc' noprompt;


RMAN> list archivelog from sequence 14372 until sequence 14446;


RMAN>  run
{
set until sequence 14446;
recover database;
}

RMAN>

SQL> shutdown immediate;

SQL> alter database open resetlogs;

SQL>