Corrupt block!

[mquesada]

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 ..

[sgodbole]

Yes, page number is the block number in the error messages.

[mquesada]

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???

[sgodbole]

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?

[vijay8282]

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