Re: Oracle DB cannot restart due to missing REDO-file

T. Lehrmann wrote:
> 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

You now know differently.

The simplest way to attempt (and that is what this is, an attempt) to get your database running again would be to copy your existing REDO01.LOG to REDO02.LOG and REDO03.log and see if Oracle will start. I cannot guarantee this to work, as the file header would be duplicated for each copied redo log.

You may be stuck recreating your database from scratch.

I hope you either have an export of your current data or have nothing of consequence stored in this database.
In the future do not be quite so careless again.

David Fitzjarrell Received on Sun Jan 16 2005 - 11:27:34 CST