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

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <eugene.pipko@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 23 Jan 2009 23:54:47 -0500

Was that a normal shutdown?


Did you include the phrase "using backup controlfile"?





From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Eugene Pipko
Sent: Friday, January 23, 2009 3:31 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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


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



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



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


Other related posts: