ORA-00368,00312,00353 error after a power blackout
Posted on 2004-10-13
i have an oracle 9iR2 on a Windows 2000 Server..this is a system test...i have no backups of this machine..and the oracle was started in NOARCHIVELOG mode..
yesterday we've got a power blackout so the server goes down suddenly.
On the power up oracle was no longer available..with the errors in the Title
ORA-00368, 00312, 00353 concearning the corruption of the redolog.
I've tryed many recovery solution, but with no good results, because for every solution i've tryed, i needed the backup or the archivelogs..
What can i do?
I know that there is an undocumented parameter to set on init.ota (i suppose it's the one located in c:\oracle\admin\instancename\pfile). The parameter is
_allow_resetlogs_corruption=TRUE ..but it's not working..i'm still getting those nasty errors..
Any tips on how and where to set this parameterto makes the oracle working?
Thank you in advance