RMAN Complete Recovery

Database Disaster Recovery

Scenario

Backup was successful Wednesday night, RMAN backup started 22:00 GMT, and Tape backup started 11.30 GMT. Thursday morning due to disaster whole database box was lost.

Restore procedure from RMAN

1. Build new box from tape backup
2. Restore the Oracle software from tape
3. Restore the last three days RMAN backups
4. Test to see Oracle Software are valid, see if Sqlplus, rman works
5. Start the listener
6. Make sure all the databases are down, they mightily be partly up since they auto start when the box is booted
7. Follow the below RMAN recovery procedure

Export the SID e.g. export ORACLE_SID=P1AR

rman

connect catalog rman/@RMANPRD.jpldbpr01

connect target /

startup nomount;

set dbid=22397860;

restore controlfile from autobackup;

restore database;

alter database mount;

recover database;

alter database open resetlogs;

8. Test the restore

Take a RMAN backup