2008/12/15

Recover Database with Only RMAN Hot Backup File

Database: 10.2.0.2.0
OS: RHEL 4

I needed to recover a database which was used 5 months ago. The only thing I have is
a tar ball including RMAN host backup files. No parameter files. No control files. No any other files.

I made it happed following steps like this:

1. create a pfile from some other similar databas.
2. Update the parameters according to the database being recovered.
3. Put the backup files into default RMAN backup directory ($ORACLE_HOME/dbs) and
change control file autobackup file name to default settings in RMAN (to '%F');
4. Startup nomount using pfile just created.
5. Restore spfile from autobackup.
6. Shutdown immediate and startup using new spfile.
7. Create pfile from spfile and update parameters accordingly to your local disk
structure.
8. Shutdown immediate and startup using new pfile.
9. Create spfile from pfile.
10.Restore control file from autobackup file.
11.You already got control files now, and following the normal recovery procedure to
do an imcomplete recovery and open database resetlogs.

No comments: