Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

recovering a 9i database into 11g from a destroyed database

758486Mar 7 2010 — edited Mar 10 2010

Our 9i database was recently lost due to the computer being physically damaged. I have a recent full database backup made via RMAN, but I have never tried to restore/ recover a database from this type of backup. In recreating the old setup we have reinstalled Windows XP and upgraded to 11g and am hoping to recover the database into this setup.

I have two files that RMAN created, a snapshot control file (with the name sncf[SID].ora) and a much larger file with no prefix. We have also recovered the hard drive that Oracle resided upon, but I'm assuming the RMAN backup may be the easier method to recover the database. The documents I've read don't seem to cover the situation of recovery using a backup made on a different database. Is there a way to tell RMAN to use these specific files for its recovery attempts, or should I move them to the new database folder and use a simple RESTORE (or RECOVER?) command.

Thanks for your help,
brian

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 7 2010

Added on Mar 7 2010

#11g, #9i, #performance-availability, #recovery-manager-rman, #rman

14 comments

3,945 views