Q: complete and utter weird database errors (crashing!)

From: Gary Assa <gsa_at_li.net>
Date: 1997/01/06
Message-ID: <5ar8d5$n7@linet01.li.net>#1/1

This is what appears in our alert file.

Notice the KCF error (?)

What is this, oracle or unix?

How can I find out what lies at that block, because almost every time that that database crashes, we get this block showing up. We have even moved tablespace around to different disks, and still the same block appeared.

We have a raid system, which may be the cause. Who the hell really knows what a raid does internally anyway?

Notice also that out redo log files are mirrored from a regular disk to a raid.

Please help???

.
.
.

Thu Jan 2 23:01:25 1997
Thread 1 advanced to log sequence 455
  Current log# 2 seq# 455 mem# 0: /oracle7/data/TX01/dbf/redo_02.dbf   Current log# 2 seq# 455 mem# 1: /raid0/TX01/dbf/redo_02b.dbf Thu Jan 2 23:20:10 1997

• here is that KCF error

KCF: write/open error dba=80000aa block=aa online=1

     file=2 /raid1/TX01/dbf/rbs_01.dbf
     error=7376 txt: 'SVR4 Error: 5: I/O error

Additional information: 170
Additional information: 3'
Automatic datafile offline due to write error on file 2: /raid1/TX01/dbf/rbs_01.dbf
KCF: write/open error dba=180003fd block=3fd online=1

     file=6 /raid1/TX01/dbf/ts02_01.dbf
     error=7376 txt: 'SVR4 Error: 5: I/O error

Additional information: 1021
Additional information: 3'
Automatic datafile offline due to write error on file 6: /raid1/TX01/dbf/ts02_01.dbf
Thu Jan 2 23:22:01 1997
Errors in file /oracle7/admin/TX01/bdump/tx01_smon_726.trc: ORA-00376: file 2 cannot be read at this time ORA-01110: data file 2: '/raid1/TX01/dbf/rbs_01.dbf'
.
.
.

-- 
=========================================================
            http://www.li.net/~gsa/index.html
This is my signature file, not part of this mail message.

Received on Mon Jan 06 1997 - 00:00:00 CST