RE: Urgent, please: what are my options???

From: Michael Fontana <>
Date: Fri, 23 Jan 2009 14:55:28 -0600 (CST)
Message-ID: <>

Eugene, looks like you unfortunately have a "perfect storm" in unrecoverable database terms.  

I am pretty certain you are going to have to rebuild your database. There are certain hidden (underline prefix)

Init parameters you can use to bypass log file checking, but they rarely work.  

You would have to call Oracle support to use these in a way supported by the vendor.  

If the database is running in archivelog mode, you could enter the command "recover database" and it might be able to come up after that with a resetlogs.  

I'd back up whatever pieces you have right now before calling Oracle or trying anything else.  

Ironically, if you had not shut it down when you had discovered this error, you may have been able to export all the data.

From: [] On Behalf Of Eugene Pipko
Sent: Friday, January 23, 2009 2:31 PM
To: ''
Subject: Urgent, please: what are my options???  

Hi all,

I have a 9i on Windows2003 with no backup.

Database was open while drive where redo logs resided was gone. So I lost all redo logs.

I shutdown d/b, mounted it, backed up controlfile to trace.

Recreated control file, but when I try to open resetlogs d/base I receive an error:  

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'D:\ORACLE_SAN\DATA\SYSTEM\REPD_SYSTEM_01.DBF'  

What are my options besides rebuilding d/base???  


P Please consider the environment before printing this e-mail.  

Received on Fri Jan 23 2009 - 14:55:28 CST

Original text of this message