Corrupt block relative dba: in alert log
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Corrupt block relative dba: in alert log

  1. #1
    Join Date
    Jun 2006
    Posts
    40

    Exclamation Corrupt block relative dba: in alert log

    hi,
    in our production database I've found following error in alert log

    Corrupt block relative dba: 0x0bc0e06f (file 47, block 57455)
    Fractured block found during buffer read
    Data in bad block -
    type: 6 format: 2 rdba: 0x0bc0e06f
    last change scn: 0x0846.c10e6c06 seq: 0x1 flg: 0x06
    consistency value in tail: 0x0c2a1045
    check value in block header: 0xcf4a, computed block checksum: 0xc74
    spare1: 0x0, spare2: 0x0, spare3: 0x0

    ***

    Reread of rdba: 0x0bc0e06f (file 47, block 57455) found same corrupted data
    Fri Aug 18 09:57:01 2006
    Thread 1 advanced to log sequence 83159
    Current log# 3 seq# 83159 mem# 0

    ***
    then I tried this query to find out corrupted block:
    select tablespace_name, segment_type, owner, segment_name from dba_extents
    where file_id =47
    and 57455 between block_id and block_id + blocks - 1;

    After tht I've found tht it is index.

    Now whether i've rebuild tht index or drop and then create again to solve this error.

    Thanks in advance.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    either

    and use dbms_repair to 'fix' the corrupted blocks

  3. #3
    Join Date
    Jun 2006
    Posts
    259
    Quote Originally Posted by minal_yawale
    Fractured block found during buffer read
    Data in bad block -
    type: 6 format: 2 rdba: 0x0bc0e06f
    last change scn: 0x0846.c10e6c06 seq: 0x1 flg: 0x06
    consistency value in tail: 0x0c2a1045
    check value in block header: 0xcf4a, computed block checksum: 0xc74
    spare1: 0x0, spare2: 0x0, spare3: 0x0
    Type 6 --- This is a data block.
    Format 2: -- Contains Index data.
    Format 1: -- Contains table data.

    You could run
    "analyze index validate structure" Just to be sure...

    A split block can occur due to restoring from a hot backup. Did you do this?

    I'd also validate the table as well.

    Simple solution: drop and recreate the bad index.

  4. #4
    Join Date
    Jun 2006
    Posts
    40
    Can u pls tell me how to use tht dbms_repair to fix the corrupted block

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    search for dbms_repair on maetalink or otn, funnily enough its all documented for you

  6. #6
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Quote Originally Posted by minal_yawale
    Can u pls tell me how to use tht dbms_repair to fix the corrupted block
    Detecting and Repairing Data Block Corruption
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  7. #7
    Join Date
    Jun 2006
    Posts
    259
    Why do you want to use dbms_repair? drop and re-create the index will be simpler, and your guaranteed the problem is resolved.

    Not only should he "fix" the block (pick a solution). But also ask the question why was it corrupted in the first place?

  8. #8
    Join Date
    Jun 2006
    Posts
    40
    When I tried to rebuild the index I got following error:

    ORA-01578: ORACLE data block corrupted (file # 47, block # 57455)

    ORA-01110: data file 47: 'INDX2_12.DBF'

    Please let me know your views on same and also the steps to resolve this error.

    Thanks for your time.

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    drop and re-create - not rebuild

  10. #10
    Join Date
    Jun 2006
    Posts
    40
    Can u pls tell me how much time will it take to drop and recreate the index of 10 GB with noparellel clause?

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