Frank van Bortel wrote:
> -----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
>
Also it might be usefull to perform a separate controlfile backup into
the backup filesystem.
alter database backup controlfile to ...
Jan
Received on Sat Aug 25 2007 - 09:12:07 CDT
