-
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
:)
-
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."
-
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
:)
-
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 03:48 PM.
HTH.
Shripad Godbole
OCP DBA (8,8i,9i)
"Let's document it and call it a feature."
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|