Recover user.dbf file
I have a oracle xe database. The alfresco server is supposed to be communicating with this oracle database. But the oracle database doesn't startup.
How can i recover all the data from the oracle databse?
Networks
I have a oracle xe database. The alfresco server is supposed to be communicating with this oracle database. But the oracle database doesn't startup.
How can i recover all the data from the oracle databse?
by tvarsenburg Accepted solution
by peconet tietokoneet Accepted solution
This is probably not the appropriate time to be sarcastic, but, recovery without backups are not supported. You know that you should have tested your recovery strategy, and that you should always backup a corrupted database before attempting to restore/recover it.
Nevertheless, Oracle Consulting can sometimes extract data from an offline database using a utility called DUL (Disk UnLoad - Life is DUL without it!). This utility reads data in the data files and unloads it into SQL*Loader or export dump files. Hopefully you'll then be able to load the data into a working database.
Note that DUL does not care about rollback segments, corrupted blocks, etc, and can thus not guarantee that the data is not logically corrupt. It is intended as an absolute last resort and will most likely cost your company a lot of money!
DUDE (Database Unloading by Data Extraction) is another non-Oracle utility that can be used to extract data from a dead database. More info about DUDE is available at
http://www.ora600.be/
More here:
http://preview.tinyurl.com/qjce5o
Please post back if you have any more problems or questions.
If this information is useful, please mark as helpful. Thanks.
This discussion is closed to new replies.
Sort by Trending