Software Question

How to restore damage dbf file?

05/06/2015 3287 views
Hi, we have here a problem and hope you will be able to help us. Here´s the issue:

1-We tried last month to backup our Oracle Express database files (the ones contained in /XE) by copying them to another directory.
2-Last week we needed those files because of a bad query that erased us some data.
3-We intended to restore database just by overwriting that current *.dbf files with the ones in our backup.
4-Since then, Oracle refuses to start or open connections. (We tried with Oracle SQL developer, the web management console host:8080/apex, etc) with the same results.

We know the data is still intact and there's no corruption cause through the DBViewer tool (intended to take out money for recovery) we were able to test our *.dbf files.
I also want to mention that I DON'T know:
 a-What's a Control File
 b-What's a Password File
 c-What's a Parameter File
 d-Where is the Data Pump tool located and how does it work
 e-How to read the init.ora file in order to correct the problem

At last, I should mention that I have a complete backup of all the oracle express directory (Flash Recovery Area, Data and all included) and I'm not able to restore my database from that "physical structure" by overwriting a working oracle copy (cause int that case I just mess up all my oracle).

My questions:

1-How can I (step by step for dummies) restore tables, schemas, users, privileges from my oracle files (*.dbf and the other ones) in a fresh oracle installation.
2-If it's possible to restore my production database just by "editing some config files" just they correctly point into my dbf's.
3-Why the Oracle instance appears to be running but it refuses connections when I overwrite the *.dbf files.
4-How can I possibly use some mentioned tools as Data Dump, DUL, ntxtract, aul (some dul clone), and WHERE TO FIND THEM.
5-Any other possible solutions or further guidance will be really helpful.
0 Comments   [ + ] Show comments


All Answers

If you have all the archivelogs since creating the new DBF file (including the archivelogs during the creation itself), you can re-create it from scratch with the "alter database create file" command.

Your other option is to recover everything you can, and drop the datafile offline. Then just work on making sure everything else is consistent.
Well, you have a couple options.

DBF Restore Toolbox used to restore files in this format, as well as look for informationhttp://www.filerepairforum.com/forum/databases/databases-aa/dbase-iv-clipper-foxpro/1150-information-from-damaged-dbf
Answered 05/17/2015 by: robdalas
White Belt

This content is currently hidden from public view.
Reason: Member has been banned from the site banned by admin For more information, visit our FAQ's.


There are two workarounds by the means of which you can easily restore damaged DBF files. Both of them are listed below:

  1. Manual Method.
  2. DBF Recovery Tool.

The manual method is quite lengthy and time-consuming so it is not recommended workaround. But you can use DBF Recovery Software to easily restore DBF files in one go.

Answered 05/11/2020 by: aakshitr1
Yellow Belt

This content is currently hidden from public view.
Reason: Member has been banned from the site banned by admin For more information, visit our FAQ's.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ