Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SMON: following errors trapped and ignored:

RE: SMON: following errors trapped and ignored:

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Wed, 24 May 2006 17:17:09 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF3F5D46@MSXVS04.trivadis.com>


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
Received on Wed May 24 2006 - 10:17:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US