Performing Database-Level Recovery

In this post I want to explain how to do complete database level recovery when we have lost all the datafiles.

For performing Database level recovery you should have the following conditions:

1.       We have online redo log files.
2.       We have a healthy backup.
3.       We have all archived redo logfiles.

Now we do recovery steps:

1.     Start database in nomount state:

Sql> shut  immediate;

Sql> startup nomount;

2.     Restore control file :

RMAN> restore controlfile from autobackup;

3.     Mount database:

RMAN>alter database mount;

4.     Restore and Recover database:

RMAN>run

{

Restore database;

Recover database;

}

5.     Open database with resetlogs option:

SQL> alter database open resetlogs;

All Steps :

RMAN> connect target /

RMAN> startup nomount;

RMAN> restore controlfile from autobackup;

RMAN> alter database mount;

RMAN> restore database;

RMAN> recover database;

RMAN> alter database open resetlogs;