RE: SMON: following errors trapped and ignored:

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Wed, 24 May 2006 11:43:23 -0500
Message-ID: <BAY107-F5F29AE647BEFA2476F83597980@phx.gbl>

The query returns this:

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

SQL> col segment_name for a30
SQL> /

OWNER                          SEGMENT_NAME                   SEGMENT_TYPE
------------------------------ ------------------------------ 
------------------
SYS                            SMON_SCN_TO_TIME               CLUSTER

SQL>
>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

---

Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 24 2006 - 11:43:23 CDT