Re: supress message on alert.log

From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Fri, 4 Dec 2009 13:45:10 -0600 (CST)
Message-ID: <fffecbccaf97187edb0cbb8f0a79f154.squirrel_at_society.servebeer.com>

The message means you have altered the default value of fast_start_mttr_target to be > 0, which turns on MTTR advisory.

A Google search and/or a doc search would show you:

You should disable or remove the FAST_START_IO_TARGET, LOG_CHECKPOINT_INTERVAL, and LOG_CHECKPOINT_TIMEOUT parameters when using FAST_START_MTTR_TARGET. Setting these parameters to active values interferes with FAST_START_MTTR_TARGET, resulting in a different than expected value V$INSTANCE_RECOVERY.TARGET_MTTR. Basically, use one method or the other -- you have both.

HTH! GL! Rich

> we have one ORACLE 10GR2 database due to we setup "log_checkpoint_interval =
> 10000" (vendor request). alert.log every minute have following message show
> up:
>
> MTTR advisory is disabled because either FAST_START_IO_TARGET or
> LOG_CHECKPOINT_INTERVAL is set
>
> does there has way to supress this message from alert.log?
>
> Thanks.

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

Received on Fri Dec 04 2009 - 13:45:10 CST