Urgent, please: what are my options???

  • From: Eugene Pipko <eugene.pipko@xxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 23 Jan 2009 12:31:14 -0800

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???

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2009