Hi, i have a little problem, i cant set the fast_start_mttr_target parameter to other value
than "0", i dont know why.
i have set log_checkpoint_interval=0,log_checkpoint_timeout=0 and fast_start_mttr_target=600,
and when i startup the database, i see the alert and it say's fast_start_mttr_target = 0, you
type show parameters fast_start_mttr_target and says "0" too.
The FAST_START_MTTR_TARGET initialization parameter simplifies the configuration of recovery time from instance or system failure. This parameter lets you specify the number of seconds crash or instance recovery is expected to take. The FAST_START_MTTR_TARGET is internally converted to a set of parameters that modify the operation of Oracle such that recovery time is as close to this estimate as possible.
You should disable or remove the FAST_START_IO_TARGET, LOG_CHECKPOINT_INTERVAL, and LOG_CHECKPOINT_TIMEOUT initialization 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 in the TARGET_MTTR column of the V$INSTANCE_RECOVERY view.
other notes :
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:
Because these initialization parameters either override FAST_START_MTTR_TARGET or potentially drive checkpoints more aggressively than FAST_START_MTTR_TARGET does, they can interfere with the simulation.
Are you using standard edition or enterprise edition? The feature is not available in standard edition.
PS: Next time, please don't be cryptic when folks are trying to help you. Post the *query* and the results..not just the result.