Database Restore after Server's storage crash

Posted by PDSERVICE on Apr 18, 2017 In

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

answer:

If the database was backed up just using symantec to backup the files in noarchivelog and this wasn't integrated with a database shutdown then none of your backups are going to be consistent. Symantec is no different to any other tool that backs up files at the os level. You may be able to open your inconsistent database using some underscore parameters to bypass some of the checks the database is trying to do or you may be able to get access to PRM-DUL( http://www.parnassusdata.com/) or some other utility that can extract data from an unopened database but you'll need to contact oracle support for any of these. In any case any data you do extract is likely to be inconsisent. If you know your application/database was doing nothting during the time the backusp were taken then forcing the database open may be an option - but you'll need to do a full export from it and load it into a new database to get back into a 'good' state.

Good luck - this is a situation no-one wants to be in.....

You are here

Database Restore after Server's storage crash

Database Restore after Server's storage crash