We recently had a disaster scenario. Someone deleted the entire Oracle installation including the backup, all with Linux rm command.
We saved the files with some undelete utility (reiserfsck --rebuild-tree). Unfortunately some files are missing or are corrupt.
I have all the datafiles, but
- some of them are 1 day old
- some of them are 2 days old
- two are even 1 month old (SYSTEM and UNDO; basically we have an entire valid backup from 1 month, but that's too old)
Is there any way to put these files together so Oracle will work?
Is there any tool (except Oracle's DUL) that can extract data from a dbf file into text, CSV, XML, SQL,... anything?
The data is extremely important so any help from you Oracle experts would be appreciated.
Thanks you very much in advance.
Answer
PRM-DUL is an alternative DUL option, find it here:DBRECOVER for Oracle
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.