Skip to Main Content

Oracle Database Discussions

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!

Database Restore after Server's storage crash

969789Oct 21 2012 — edited Oct 31 2012
So after power failure storage crashed for good and the server is "close to death", no way services can be restored or anything. We have daily backup using symantec backup exec from the entire system. So we have the full storage restored to an exteral HD (where all the files for the DB are).

We got a new server and we try to replicate the oracle database on it. We are using the cold backup restore way with no luck, cause after all the steps at alter database open resetlogs; we get a consistency error. The recover says to use backup controlfile, the problem is there are none archivelogs in any of our backups.

Any suggestions?

We use:
Windows server 2003 R2
Oracle 11g

Thank you in advance for any insight.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 28 2012
Added on Oct 21 2012
25 comments
2,341 views