Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> (no subject)

(no subject)

From: Naik, Sandesh <Sandesh.Naik_at_compaq.com>
Date: Fri, 9 Jun 2000 10:30:30 -0500
Message-Id: <10523.108430@fatcity.com>


Hi,
 I am having interesting ( and annoying ) problem here.  We have a database which does not open with resetlogs after a incomplete recovery.
We do not have any more logs to apply.
We are getting this errors
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01194: file 9 needs more recovery to be consistent ORA-01110: data file 9: '/db11/ORACLE/BRZRPT/bus_d_00.dbf' SVRMGR>
Here is the specifics of database and server: SCO_SV 3.2 2 i386 5005
System = SCO_SV
Release = 3.2v5.0.4
KernelID = 97/09/03
Machine = i80386
BusType = ISA
Serial = B55677611
Users = 5005
OEM# = 0
Origin# = 1
NumCPU = 2
Oracle7 Server Release 7.3.4.4.0 - Production PL/SQL Release 2.3.4.4.0 - Production
CORE Version 3.5.4.0.0 - Production
TNS for AT&T System V/386: Version 2.3.2.1.0 - Production NLSRTL Version 3.2.4.0.0 - Production

All ideas are welcome except we do not want to corrupt the database and open it. So I do not want to use _allow_restelog_corruption parameter.

Thanks
-Sandesh

Sandesh Naik
Oracle Database Administrator
Compaq Computer Corporation
Phone: (281) 518-3844 Received on Fri Jun 09 2000 - 10:30:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US