Data Block Corrupt
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Data Block Corrupt

  1. #1
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    Data Block Corrupt

    Hi,

    I got error in a file. Folowing is the error text :

    Corrupt block relative dba: 0x2c81d2e8 file=178. blocknum=119528.
    Fractured block found during buffer read
    Data in bad block - type:6. format:2. rdba:0x2c81d2e8
    last change scn:0x0000.08951989 seq:0x1 flg:0x02
    consistancy value in tail 0x187d0601
    check value in block header: 0x0, check value not calculated
    spare1:0x0, spare2:0x0, spare2:0x0


    This is and Index Datafile.

    What are the Options I am having ??

    Regards
    Vijay
    --------------------------
    The Time has come ....

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    copy the datafile to another hard disk, if possible

    or

    create a datafile for the indx tablespace on another hard disk and recreate indexes.

    HTH.

  3. #3
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    Data Block Corrupt

    Hi

    I did ANALYZE INDEX IND_NAME VALIDATE STRUCTURE

    it didn't gave me any error.

    What can I understand from this ??

    Regards
    Vijay
    --------------------------
    The Time has come ....

  4. #4
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    This problem could be because of a RAM problem. Was there any change made to the memory chips of your box?

    Check this out on metalink...
    http://metalink.oracle.com/metalink/...p_id=56827.996

  5. #5
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Try running db verify against the datafile.

    dbv file=filename BLOCKSIZE=db_block_size

    see if it shows any error

    if you are sure that an index is corrupted and there is no corruption in the base table, then just drop and recreate the index.

    HTH
    Last edited by adewri; 02-18-2003 at 03:27 AM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  6. #6
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    Hi,

    I ran validate stru on base table as well.
    Everything looks ok and fine.

    Do i still need to run dbverify on that file ??

    vijay
    --------------------------
    The Time has come ....

  7. #7
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    ur choice, its ur database...
    any way running dbverify won't bite you...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  8. #8
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    Hi,

    I did dbverify on that file. But is from last backup.

    Can I run dbv on online file ???
    --------------------------
    The Time has come ....

  9. #9
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Yes you can run DBV online, however it is designed to be used when the database is closed so it might report errors where blocks are being updated.

    Also it may impact on performance.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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