Re: RMAN Restore and Recovery Scenario

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Michael42 wrote:
> 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
>

Restore controlfile from <name of your backup set goes here>

followed by restore spfile, startup mount, restore and recover database.

Nothing beats experience, though, so my advice is to get hold of a playground server, and test this (and all 37 other) scenarios. Of course, documentation is at the well known locations:
http://www.oracle.com/pls/db102/to_toc?pathname=backup.102%2Fb14194%2Ftoc.htm&remark=portal+%28Books%29

• -- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFG0DJLLw8L4IAs830RAuM3AJ9vR1sXQYof68rh87uYPwI2hc1HAACfdAqq RkLvmKxMiWqkOZpHqkZv7Ws=
=pKUF
-----END PGP SIGNATURE----- Received on Sat Aug 25 2007 - 08:44:43 CDT