Recovery with only Oracle Datafiles?

Posted by PDSERVICE on Apr 18, 2017 In

We have an Oracle 10g running on a RedHat ES4. Yestoday one of my colleague mistakingly removed all the files under oradata folder. Now we have most data files in hand, no control files and redo logs, and we don't have system01.dbf.Is this possible to revcory 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.html and 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: http://zcdn.parnassusdata.com/DUL5108.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.

You are here

Recovery with only Oracle Datafiles?

Recovery with only Oracle Datafiles?