what could cause an index to corrupt?

From: Guang Mei <gmei_at_proteome.com>
Date: Mon, 10 Sep 2001 15:42:03 -0400
Message-ID: <QE8n7.852$v6.113610@news.shore.net>

Hi,

We have Oracle 8.0.5.2.0 on Sun box with NetApp attched as storage (used as oracle datafiles)

We have twice seen a problem of index corruption after importing a schema. For example today I got:

SQL> select count(*) from MT.REFERERS;

COUNT(*)

3318

SQL> analyze table MT.REFERERS compute statistics; analyze table MT.REFERERS compute statistics *
ERROR at line 1:

ORA-01115: IO error reading block from file 14 (block # 262144)
ORA-01110: data file 14: '/oracle/u01/oradata/RPT1/indexes04.dbf'
ORA-27072: skgfdisp: I/O error

SVR4 Error: 25: Inappropriate ioctl for device Additional information: 262143

The file size of "indexes04.dbf" is 2048M. I had to drop the corrupted index and re-create it. So my questiuon is:

What could cause an index to corrupt? (datafile size too close to 2MB?)
What can I do to try to prevent this from happening again?

TIA. Guang Received on Mon Sep 10 2001 - 14:42:03 CDT