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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
