Email: service@parnassusdata.com 7 x 24 online support!

Corrupt Data - Oracle 8i - Recovery

Corrupt Data - Oracle 8i - Recovery

 

915572Newbie


Hello, It seems that a RAID has failed on my old server and is causing the Oracle 8i database not to start. I understand this is an old product and is no longer supported but hopefully someone has some insight. I have both the two individual data MDF files that I used plus the SYSTEM01.MDF and such. Although I have a feeling they may be corrupted. I spent this weekend looking into a solution. I found some old CSV which I imported back but I am still missing loads of data. Is there any way to open the MDF for export, through maybe C#, or even a tool out there. I think the RAID corrupted the file, so its not as easy as Installing 8i again and the putting them back. (Tried that). I've tried many programs out there to view the MDF with no luck. 

When I load in with the 8i SQL Admin, I can see the database but when I try to open it says it is offline. When I try to turn it online I get : ORA-01110: data file 1: 'D:\ORACLE\ORADATA\...\SYSTEM01.DBF' (The file also changes for my data files). I can repair the SYSTEM01, but I cannot repair the individual database MDF files as I need that data. I have no problem paying for a solution if there is a company out there that can repair old databases and at least recover 90% of the data. Normally the file is 1.7Gigs but the actual use is around 300Megs. So it can't all be corrupt, right?
 

 
You can contact Parnassusdata.com . They have a data recovery tool(PRM-DUL  http://www.parnassusdata.com//service .