-
Regular Block corruption
Hi All,
Please Help
I am facing regular block corruption in production server in my index and table segments, most of the indexes have block corruption. i am having streams and my replicated data is healthy.
Hex dump of (file 55, block 323236) in trace file --some path--/trace/user/alitst_ora_2281530.trc
Corrupt block relative dba: 0x0dc4eea4 (file 55, block 323236)
Bad header found during buffer read
Data in bad block:
type: 6 format: 2 rdba: 0x0dc4bd94
last change scn: 0x0002.e023b263 seq: 0x1 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0xb2630601
check value in block header: 0xe86
computed block checksum: 0x0
Reread of rdba: 0x0dc4eea4 (file 55, block 323236) found same corrupted data
Wed Sep 10 05:12:37 2008
Corrupt Block Found
TSN = 10, TSNAME = INDX_TRN
RFN = 55, BLK = 323236, RDBA = 231009956
OBJN = 207632, OBJD = 207632, OBJECT = INDX_COMP_UP, SUBOBJECT =
SEGMENT OWNER = LISSIA_OWNER, SEGMENT TYPE = Index Segment
Please suggest some thing,
How to avoid / prevent. Now its regular on alternate nights.
I usually drops index and recreate them. it's my production database, last time i have set DB_BLOCK_CHECKING=LOW, and then my sysaux.dbf file goes for a toss.
Please suggest, as it is my production server i cant face so many downtimes
Lots of regards
Sabalesh Mahajan
-
id be checking out hardware problems