RE: SMON: following errors trapped and ignored:

From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
To: <joe_dba@xxxxxxxxxxx>
Date: Wed, 24 May 2006 17:17:09 +0200

Joe

>ORA-00604: error occurred at recursive SQL level 1
>ORA-01578: ORACLE data block corrupted (file # 1, block # 1874)
>ORA-01110: data file 1: '/dba02/oradata/orcl/system01.dbf'

Just for curiosity... What does the following query returns?

SELECT owner, segment_name, segment_type
FROM dba_extents
WHERE file_id = 1
AND 1874 BETWEEN block_id AND block_id+blocks-1;

And, if you have an output, what does an ANALYZE TABLE|CLUSTER|INDEX ... 
VALIDATE STRUCTURE on that segment return?


Regards,
Chris
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: SMON: following errors trapped and ignored:
From: Joe Smith

RE: SMON: following errors trapped and ignored:

Other related posts: