RMAN Restore and Recovery Scenario

From: Michael42 <melliott42_at_yahoo.com>
Date: Sat, 25 Aug 2007 05:24:44 -0700
Message-ID: <1188044684.967670.240330@x40g2000prg.googlegroups.com>

Hello,

I have a question on restoring a database using RMAN:

Pre Disaster Environment
1. Using a standard non-RAC Oracle 10.2.03 database on a UNIX Sun Solaris 10 system.

2. There is a recent RMAN full backup of the database.
3. Archive logs and the control file are backed up using RMAN.
4. The RMAN backup files go to disk.
5. The RMAN backups use the databases control file for its cataloging.

The Control File Record Keep Time (CFRKT) is set to 45 days.

Disaster Scenario
1. An event causes the entire Sun UNIX file system to be corrupt. The only solution is to reinstall the OS and then the Oracle database product. Then rebuild the database.
2. The disk system that holds the RMAN backup files is not effected by the event and can be used.

Question
After the OS, Oracle 10g database product has been re-installed and the database rebuilt, how can I use my RMAN files to restore and recover the database?

In a standard restore operation the steps are generally:

UNIX> $ORACLE_HOME/bin/rman target / nocatalog
RMAN> shutdown abort;
RMAN> startup mount;
RMAN> restore database;
RMAN> recover database;
RMAN> alter database open;

My thought is that something must be done to get the RMAN "catalog" information from the backed up control file but I am not sure of the steps.

What can you recommend?

Thanks,

Michael Received on Sat Aug 25 2007 - 07:24:44 CDT