ORA-29855 from ORA-01578 (ODCIINDEXCREATE, data block corrupted)
Date: Fri, 31 Jan 2003 12:28:23 -0600
Message-ID: <Pine.LNX.4.42.0301311149260.25306-100000_at_macbeth.tirone.com>
In creating an intermedia text index in Oracle 8.1.6, after the process ran for quite a while, it stop with this error:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-20000: interMedia Text error: ORA-01578: ORACLE data block corrupted (file # 5, block # 168382) ORA-01110: data file 5: '/o03/oradata/<dbid>/users01.dbf' ORA-06512: at "CTXSYS.DRUE", line 126 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 54 ORA-06512: at line 1 (DBD ERROR: OCIStmtExecute)
(I replaced the database name with <dbid>)
It quite large index, at the time of stopping, the DR$...$I table created for the intermedia text has size of 473.75 MB. The index are created from a LOB field, I think the LOB segment of it has the size of 661.375 MB.
I checked already that the corrupt block is indeed part of the DR$...$I table.
Somewhere in this newsgroup I read that sometime ORA-01578 can be caused by insufficient SGA. Is that true? Is that seems to be the case here? If it is, which part of SGA I should increase? At the moment of crash, the initial db_block_buffers is 2048 (x 8192) and initial shared_pool_size is 15728640. Total SGA is 56008688 bytes.
Should I really worried about the disks? There is no SCSI error logged (the system log is on separate disk and controller).
I am using Oracle 8.1.6 standard in RH Linux 7.3. The drive where the table space located is Fujitsu MAG3182MP 18.2 GB formatted with ext2, on controller Tekram DC-390U3W, driver sym53c8xx
Thanks!
-- S P Arif Sahari Wibowo _____ _____ _____ _____ /____ /____/ /____/ /____ arifsaha_at_yahoo.com _____/ / / / _____/ http://www.arifsaha.com/Received on Fri Jan 31 2003 - 19:28:23 CET