915572Feb 6, 2012 2:48 PM
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: datafile 1: 'D:\Oracle\ORADATA\...\SYSTEM01.DBF' (The file also changes for my datafiles). 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 DBRECOVER.com . They have a data recovery tool (PRM-DULDBRECOVER for Oracle)/service .
DBRECOVER Recovery Options
For Oracle incidents, start with the DBRECOVER for Oracle trial to verify table visibility, row previews, and export readiness on copied datafiles. For MySQL and InnoDB incidents, DBRECOVER for MySQL is free software and can inspect.ibd files, ibdata1, and database directories locally.
When the case is urgent, preserve the original files first, work from copies, and contact paid emergency support with the database version, platform, error messages, file list, and recovery objective.