Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

The Oracle database has been corrupted and both the data and backups were lost in the corruption. Is there anything I can do to recover my data? It would be terrible if it were all lost.

share|improve this question
    
Does Oracle have the ability to take backups? If so, do you have any of those? –  Aaron Bertrand May 22 '13 at 2:17
    
Without much more information about that "corruption" and how it was possible for both your backups and your database to become "corrupt", can't really say much. Please add more details to your question (by editing it). –  Mat May 22 '13 at 7:05
add comment

closed as not a real question by Mark Storey-Smith, Aaron Bertrand, Mat, dezso, FreshPhilOfSO May 22 '13 at 7:33

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

Can you define "corruption" and explain exactly what happened to the files?

If the data is really valuable (in which case you'll hopefully be investing a lot more in your backup and recovery to make sure that you can't lose your database and all your backups simultaneously), there are tools that may be able to salvage some of your data. Oracle Consulting (which you'd access via support) has a data unloader that they'll charge a small fortune to use. There are a handful of other such tools-- DUDE being the most well-known. Jonah Harris has a listing of other data unloaders that I know much less about. Realistically, none of these are going to be cheap. And there is no guarantee about how much data will be recoverable depending on the nature of the corruption.

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.