RE: SMON: following errors trapped and ignored:

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