Restoring & Recovering database using HOT backup

How to restore/recover database using HOT backup?

From the above steps we have taken the HOT backup to /u01/oracle/app/oradata/pavan/database_1/HOT_BKP/ path. Now whenever a datafile got missed, deleted, corrupted, overridden or disk errors occurred then database will not be in a position to follow smooth transactions.In this case we need to recover the database by restoring the backup file from /u01/oracle/app/oradata/pavan/database_1/HOT_BKP/ to /u01/oracle/app/oradata/pavan/database_1/.

1. Before proceeding with recovery operation we need to shut down the database.

SQL>SHUT IMMEDIATE/SHUT ABORT

2. Now copy the files from backup location to datafiles location. This is restoration of database.

cp   /u01/oracle/app/oradata/pavan/database_1/HOT_BKP/*.dbf /u01/oracle/app/oradata/pavan/database_1/

3. Put the database in mount state

SQL>startup mount

4. Now we shall be doing recovery operation

SQL>recover database until cancel using backup controlfile;

In this process it will start applying all available archivelogs to the database and recovers it. we need to cancel once all archive logs are applied.

Enter cancel for cancelling the operation

5. Bringup the database in open mode with resetlogs

SQL>ALTER DATABASE OPEN RESETLOGS;

SQL> SELECT STATUS FROM V$INSTANCE;

STATUS

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

OPEN