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

Comments

Please log in to comment

Answers

0
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
Answer this question or Comment on this question for clarity