Re: SMON: following errors trapped and ignored:

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Wed, 24 May 2006 09:59:13 -0500
Message-ID: <BAY107-F94F3ED5970C9C1BBD1D2997980@phx.gbl>

That is the entry from the trace file. It appears over and over.

"SMON trapped and ignored.."

this appears in the alert log:

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'

In the trace file it has the SMON statement with the ORA- error.

Sorry about the confusion.

thanks.
>Hi Joe,
>
> Any trace file produced?
>
> I would open a SR with Support.
>
> Regards,
>
>- Kirti
>
>
>--- Joe Smith <joe_dba_at_hotmail.com> wrote:
>
> > Has anybody ever seen this message in their alert log? This is
>9.2.0.5.0 on
> > Sun8 64-bit. I cloned this db from one server to a new server and
>recreated
> > the control file. I noticed this entry in the alert log:
> >
> > *** SESSION ID:(5.1) 2006-05-23 07:52:27.372
> > *** 2006-05-23 07:52:27.372
> > SMON: following errors trapped and ignored:
> > 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'
> > *** 2006-05-23 07:57:34.668
> >
> >
> > Everything works fine. I can shut down and startup, I ever did a full
>hot
> > backup through RMAN.
> >
> > SMON will trap errors with corrupt blks in the system tbs? And you
>don't
> > have to worry about them?
> >
> > thanks.
> >
> > _________________________________________________________________
> > Don’t just search. Find. Check out the new MSN Search!
> > http://search.msn.click-url.com/go/onm00200636ave/direct/01/
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam? Yahoo! Mail has the best spam protection around
>http://mail.yahoo.com
>--
>http://www.freelists.org/webpage/oracle-l
>
>

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 - 09:59:13 CDT