We have an Oracle 10g running on a RedHat ES4. Yesterday one of my colleague mistakenly removed all the files under oradata folder. Now we have most datafiles in hand, no control files and redo logs, and we don't have system01.dbf.Is this possible to recover the database with only datafiles we have?
Thx a lot!
Answer
You still have two workarounds of this problem.
There are tools that can extract data from Oracle datafiles when they can't be recovered with usual techniques, as in your case.
If your data is critical for your organization then you can do either of the following
- call to Oracle Support:http://www.oracle.com/support/contact.htmlAnd ask them for Data Recovery UnLoader (DUL) tool. It is a tool that is owned by Oracle and you must pay to use it. It can extract data directly from Oracle datafiles.
- Use third-party tool (similar to DUL and based on DUL) that is called: PRM-DUL (Database Unloading by Data Extraction). It is provided by a dutch company as a service. You can find more about the product on the company's site:https://s.dbrecover.com/dbrecover-for-oracle-latest-dist.zip
In both cases you must pay for this service but it is still an option for you if you really need to recover your lost data.
That's right, there are special tools, which can help in cases of real disaster. But you have to pay ...
It shows (shouldn't be a moralizing lecture) how important it is to backup your data on a regular basis.
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.