Oracle Database Discussions

Hi Experts,

I found the following statement in alert log. my database version 11.2.0.2.0 - 64bit.

FAST_START_MTTR_TARGET 60 is set too low, using minimum achievable MTTR 61 instead- in my alertlog.

I found that Whenever you set fast_start_mttr_target to a nonzero value, and while MTTR advisory is ON, Oracle Corporation recommends that you disable (set to 0) the following parameters:

LOG_CHECKPOINT_TIMEOUT

LOG_CHECKPOINT_INTERVAL

FAST_START_IO_TARGET

The Values i found in my database.

fast_start_mttr_target integer 60

log_checkpoint_interval integer 100000

log_checkpoint_timeout integer 1200

fast_start_io_target integer 0

My question is shall i need to do perform any action, what i found in alert log. I read about the fast_start_mmtr_target according to my understanding

The fast_start_mttr_target defines the effective mean time to recovery (MTTR) target, expressed in seconds.

The default for fast_start_mttr_target is 300 seconds (5 Minutes). and maximum we can give 3600 ( 1 Hour).

Administrators specify a target (bounded) time to complete the cache recovery phase of recovery with the fast_start_mttr_target initialization parameter.

Please suggest your thoughts.

Thanks in Advance.