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.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
closed as not a real question by Mark Storey-Smith, Aaron Bertrand♦, Mat, dezso, Phil 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.
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.