Corrupt block!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Corrupt block!

  1. #1
    Join Date
    Nov 2002
    Location
    Argentina
    Posts
    24

    Thumbs down Corrupt block!

    SVRMGR> select count(*) from TLOCTION;
    COUNT(*)
    ----------
    ORA-01578: ORACLE data block corrupted (file # 20, block # 71164)
    ORA-01110: data file 20: '/dbsPROD/d2/popindex3.dbf'

    We found a corrupt block in an index of this table . we solve it by re-creating the index.
    But when run dbverfy utility we got this error when :

    DBVERIFY - Verification starting : FILE = /dbsPROD/d2/popindex0.dbf
    **** kdxcofbo = 32313 != 1056
    ---- end index block validation
    Page 145788 failed with check code 1
    **** kdxcofbo = 1735 != 1056
    ---- end index block validation
    Page 145800 failed with check code 1
    **** kdxcofbo = 1893 != 1056
    ---- end index block validation
    Page 145815 failed with check code 1

    The question is: the page number describe the block number , i.e. page# = block#?? if not .. is the block number written in the error message???

    Thank you all .. and sorry my english ..
    Marcelo Quesada
    :)

  2. #2
    Join Date
    Jan 2003
    Posts
    78
    Yes, page number is the block number in the error messages.
    HTH.
    Shripad Godbole
    OCP DBA (8,8i,9i)

    "Let's document it and call it a feature."

  3. #3
    Join Date
    Nov 2002
    Location
    Argentina
    Posts
    24
    but i run this query

    select segment_type, segment_name, owner
    from sys.dba_extents
    where file_id = 20 and
    (145788 between block_id
    and block_id + blocks - 1);

    20 = datafile#

    but it was no row selected .. is that possible???
    Marcelo Quesada
    :)

  4. #4
    Join Date
    Jan 2003
    Posts
    78
    If the corruption truly exists in the object, then ANALYZE INDEX/TABLE VALIDATE STRUCTURE should report an error as well. Try this. Did you droped and recreated the object or rebuild?
    Last edited by sgodbole; 02-13-2003 at 02:48 PM.
    HTH.
    Shripad Godbole
    OCP DBA (8,8i,9i)

    "Let's document it and call it a feature."

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

    Corruption

    Hi,

    I am also undergoing same kind of problem.

    I ran Validate Structure on myindex and in came fine. No errors reported.

    What should I understand from this ? It that error was not real
    ????

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

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