Oracle recovery from dbf uncorrupted files.

Posted by PDSERVICE on Apr 18, 2017 In

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 works

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,WHERE TO FIND THEM.

5-Any other possible solutions or further guidance will be really helpful.

an easy to use & GUI option DUL is PRM-DUL : http://www.parnassusdata.com/

You are here

Oracle recovery from dbf uncorrupted files.

Oracle recovery from dbf uncorrupted files.