Urgent, please: what are my options???

From: Eugene Pipko <eugene.pipko_at_unionbay.com>
Date: Fri, 23 Jan 2009 12:31:14 -0800
Message-ID: <34DB87F47199374280ADFD2968CDBCFA87D4CF4C09_at_MAIL01KT.seattlepacificindustries.com>

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:31:14 CST

Original text of this message