Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle DB cannot restart due to missing REDO-file

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

From: Antoine BRUNEL <>
Date: Mon, 17 Jan 2005 01:38:25 +0100
Message-ID: <41eb0901$0$17653$>

Hi from Paris

if you losed online redo logs, you have two options: - do a full database restore, and apply archived up to when you dropped redo logs... this is an incomplete recovery (recover... until cancel) - open the database without doing the crash recover, which will introduce corruption (as commited transactions may have not been fully applyed to dbfiles)... this is an unsupported way, you have to open an iTar at Oracle Support, and ask them for _allow_resetlogs_corruption. Anyway after that, the current DB will be considered as unsupported, and you will have to export full the DB, and create a new to one to import data.

whatever option you take, take a whole backup before doing anything...

But: NEVER, NEVER, NEVER modify Oracle files with an hex editor... this would the perfect way to totally broke down you db....

"T. Lehrmann" <> a écrit dans le message de news:
> 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 - 18:38:25 CST

Original text of this message