Skip to Main Content

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!

How to restore from RMAN backup when the server has crashed.

myluismNov 20 2017 — edited Nov 23 2017

Hi all.

I have a Windows Server hosting an Oracle Database 11g.

Apparently the server has crashed . I don't have many details at this moment. I do not have access to the server now.

I have a series of backups to rely on, raging from cold backups, expdp (Full) and RMAN incremental update.

Assuming the server indeed crashed, the more suitable option would be restoring from RMAN.

Assuming reinstallation of the whole box and the backups are safe (they are stored separately on a NAS/SAN). i know i can easily restore from either expdp or cold backup.But the best option would be using RMAN and try restore /recovery.

This scenario is similar to "restore to another server procedure" i've seen on different places. Also on Windows it may be a good idea (or not???) to create a seed database with the same name and the try to restore / recovery.

I can also reproduce the same directory structure.

So excuse me for so many assumptions which may or may not be valid. Once i get to the server i'llĀ  diagnose the situation. Anyway under this possible scenario, could anyone recommend an action plan? How different would it be to restoring to another server?

Thanks in advance!!!! appreciated it deeply....!!!!

This post has been answered by EdStevens on Nov 22 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 20 2017
Added on Nov 20 2017
12 comments
3,082 views