Recover Oracle DB after OS Drive Failure
Posted on 2005-02-26
We recently experienced a hard drive failure that caused our control files for our oracle 8i db to become corrupted. We tried several different things to attempt recovery (ie, changing from control01.ctl to 02 to 03, etc). After searching through several log files, we noticed a CRC error on the control files, which do not have the sql in a trace file (to rebuild the ctl file).
Unfortunately, the hard drive failure required a clean install of the system -- now running win 2k3 server, instead of 2k. Is there a way to recover the db using the dbf files from the old db that are not corrupted?
Thanks for any assistance.