Recovering when redolog file is lost

How to recover database when redo files were lost

Previously we have taken the HOT backup to /u01/oracle/app/oradata/pavan/database_1/HOT_BKP/ path. When online redo logs got missed then can create them on OS level and recover it.

1. Before proceeding with recovery operation we need to create the REDO LOG  file in offline(this step is not mandatory)

SQL>SHUT IMMEDIATE

 ~  cd /u01/oracle/app/oradata/pavan/database_1/

 ~  touch redo03.log

2. Now we shall be doing recovery operation

SQL>STARTUP MOUNT

SQL>RECOVER DATABASE UNTIL CANCEL;

Here redo logs wont be created. in the next step when i use Resetlogs option then redo log then it  will be created

4. Open the database with reset logs Check status of database;

SQL>ALTER DATABASE OPEN RESETLOGS;
you can check now in the os prompt that missed redolog file is created.

SQL> SELECT STATUS FROM V$INSTANCE;

STATUS

------------

OPEN