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   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity


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

Please log in to comment
This content is currently hidden from public view.
Reason: Removed by member request
For more information, visit our FAQ's.


Checkout the below the guide how to recover .dbf file, seesteps...

1. Open the dBase command line from the Windows Start menu.

2. Log into the local dBase software with your username and password.

3. Click on the dBase command line section of the window that is open.

4. Type "dbf /recover yourDbaseFile.dbf" into the command line, where"yourDbaseFile.dbf" is the name of the dBase file whose tables arecorrupted.

Press "Enter." dBase takes some time (ranging from a few minutes to afew hours, depending on the size of the database) to analyze and repair thefile and its contents. You are alerted when this process is finished.

If this doesn't work, you may check out a third party tool.One such good tool is DBF Recovery Tool. This software support all type ofwindows versions. Check out the free trail demo version in which you can getthe recovery of data in free: DBF Recovery Tool

Answered 05/12/2017 by: virat8586
Green Belt

Please log in to comment