Help: one DB file often becomes unreadable

From: <yong321_at_yahoo.com>
Date: Fri, 18 Jun 1999 14:57:59 GMT
Message-ID: <7kdmpg$jcg$1@nnrp1.deja.com>

I got the following error on these dates 05/18, 06/09, 06/17 and 06/18 on Oracle 7.3.4.0.0 on NT4 SP4.

****************The error from SQL*Plus********************

SQL*Plus: Release 3.3.4.0.0 - Production on Thu Jun 17 08:53:34 1999

Connected to:
Oracle7 Workgroup Server Release 7.3.4.0.0 - Production With the distributed option
PL/SQL Release 2.3.4.0.0 - Production

SQL> select username from employees;
ERROR:
ORA-00376: file 6 cannot be read at this time ORA-01110: data file 6: 'D:\ORANT\DATABASE\LIVELINK.DBF'

no rows selected

Every time I find the error the next morning, I can run this to correct it:

d:\orant\bin\svrmgr23
[connect as internal]
recover tablespace livelink
alter database datafile 'D:\ORANT\DATABASE\LIVELINK.DBF' online;

Part of orclALRT.LOG and orclDBWR.TRC is attached at the end.

What could be wrong? Thanks very much for help.

Yong Huang

In orclALRT.LOG, after the above recovery, this is logged at the end of the file:
Wed Jun 16 22:38:10 1999
KCF: write/open error dba=0x60152cf block=0x152cf online=1

     file=6 D:\ORANT\DATABASE\LIVELINK.DBF
     error=9205 txt: 'OSD-04016: Error queuing an asynchronous I/O

request.
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.' Automatic datafile offline due to write error on file 6: D:\ORANT\DATABASE\LIVELINK.DBF
Thu Jun 17 08:54:17 1999
ALTER DATABASE RECOVER tablespace livelink Thu Jun 17 08:54:17 1999
Media Recovery Tablespace: LIVELINK
Media Recovery Start
Media Recovery Log
Recovery of Online Redo Log: Thread 1 Group 2 Seq 829 Reading mem 0 Mem# 0 errs 0: D:\ORANT\DATABASE\LOG3ORCL.ORA Mem# 1 errs 0: D:\ORANT\DATABASE\LOG4ORCL.ORA Media Recovery Complete
Completed: ALTER DATABASE RECOVER tablespace livelink Thu Jun 17 08:54:18 1999
alter database datafile 'D:\ORANT\DATABASE\LIVELINK.DBF' online

Completed: alter database datafile 'D:\ORANT\DATABASE\LIVELIN...
ORA-00376: file 6 cannot be read at this time
ORA-01110: data file 6: 'D:\ORANT\DATABASE\LIVELINK.DBF'

*************************************************************

In orclDBWR.TRC, this is logged at the end: Dump file D:\ORANT\RDBMS73\trace\orclDBWR.TRC Wed Jun 16 11:50:41 1999
ORACLE V7.3.4.0.0 - Production vsnsta=0 vsnsql=b vsnxtr=3
Windows NT V4.0, OS V5.101, CPU type 586 Oracle7 Workgroup Server Release 7.3.4.0.0 - Production With the distributed option
PL/SQL Release 2.3.4.0.0 - Production
Windows NT V4.0, OS V5.101, CPU type 586 Instance name: orcl

Redo thread mounted by this instance: 1

Oracle process number: 4

pid: 1e4

1999.06.16.22.38.10.133
SESSION ID:(1.3) 1999.06.16.22.38.09.733 KCF: write/open error dba=0x60152cf block=0x152cf online=1 file=6 D:\ORANT\DATABASE\LIVELINK.DBF error=9205 txt: 'OSD-04016: Error queuing an asynchronous I/O request. O/S-Error: (OS 33) The process cannot access the file becauseanother process has locked a portion of the file.' Automatic datafile offline due to write error on file 6: D:\ORANT\DATABASE\LIVELINK.DBF

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 18 1999 - 09:57:59 CDT