Corrupted Database - possible fix
azizJun 26 2011 — edited Jun 27 2011Spec:
Windows 2008 R2 64bits
Oracle 11.2.0.1
One of our clients just confirm that one of their production databases is down.
After investigating, we found ora-00600 error - possible corruption.
Did the following:
- Tried to recover database from backup (no real backup only dump files)
- Tried to create new control file, but can't because all datafiles are fuzzy
- Found out that database is not in archivelog mode and so there is no archived log files
Our only options thus far:
- Recreate database from dump files
- Edit init file to ignore corruption ( using allowresetlogs_corruption = true )
Your input:
- What would you suggest that will be the best possible and fastest was the get the database up and running (1st option or second option?
Edited by: 868332 on Jun 26, 2011 5:37 AM