Oracle DB cannot restart due to missing REDO-file

Hello,

I have a big problem with my Oracle DB (V 9.1): the service cannot start and when trying to connect Oracle error message "ORA-01033" pops up, saying
"ORACLE initialization or shutdown in progress". In the log file is written:
"Errors in file c:\oracle\admin\DBNAME\bdump\DBNAME_lgwr_480.trc:

ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\ORACLE\ORADATA\DBNAME\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: File cannot be opened
O/S-Error: (OS 2) System cannot find the specified file"

This was casued because I deleted the 3 REDO-logfiles REDO01.log, REDO02.log and REDO03.log of my database (I am no real DBA, I thought Oracle only needs this files if one wants to recover a DB!).

Apparently, Oracle recreated REDO01.LOG, but not the other two files and now has problems to even start the DB.

Is there any way (e.g. nologging adjustments in init.ora) to get my DB started again?

Any help will be appreciated! Thanks in advance, Thomas Received on Sun Jan 16 2005 - 10:55:46 CST