We have oracle db which unfortunately we did'n make backup and all control files and other files except all data-files are damaged. Is there any solution to recover db from all of these intact data-files? Thank you for helping me.
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. Join them; it only takes a minute:
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Here's a link describing and solving the same problem, do note that you still have to make your own pfile, but that isn't hard. http://myracle.wordpress.com/2008/01/11/recover-database-without-control-files-and-redo-log-files/