database point-in-time recovery (DBPITR) - Log Sequence–Based Recovery

In this post I want to explain how to do Log sequence-Based recovery. In this case we want to recover whole database from last good backup but, we don’t have all the archivelog files and also we don’t have backup of all archivelog files. Hence Rman allows you to apply redo up specific archive redo log file by specifying sequence number.

·         Recover Steps:

To get the Sequence Number you can use the below query with time:-

SQL>select sequence#, first_change#, first_time from v$log_history order by first_time;

RMAN> rman target /

RMAN> startup mount;

RMAN> run{

2> set until sequence <SEQUENCE NUMBER> thread <THREAD NUMBER>;

3> restore database;

4> recover database;

5> }

RMAN> alter database open resetlogs;