Regular Block corruption
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Regular Block corruption

  1. #1
    Join Date
    May 2008
    Posts
    6

    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
    RegardsSabalesh Mahajan

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    id be checking out hardware problems

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width