Erased REDO01.LOG and REDO03.LOG by mistake!
Posted on 2004-10-20
Please, help me.
I use Oracle 9.2 and don't find svrmgr utility
By mistake, I erased these two files:
But E:\ORACLE\ORADATA\OEA1\REDO02.LOG is still there.
Now I have an error on Oracle when trying to connect as any user:
ORA-01033: ORACLE initialization or shutdown in progress
I checked on
And it says:
Wed Oct 20 12:20:59 2004
Errors in file e:\oracle\admin\oea1\bdump\oea1_lgwr_3328.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'E:\ORACLE\ORADATA\OEA1\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-313 signalled during: alter database open...
What can I do? I can't recuperate REDO01.LOG or REDO03.LOG and don' like to re-install Oracle again...