-
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
:)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|