Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> (no subject)
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
![]() |
![]() |