Re: supress message on alert.log
Date: Fri, 4 Dec 2009 13:45:10 -0600 (CST)
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
> 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?