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

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

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

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?

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

Regards
Vijay