What is the FAST_START_MTTR_TARGET initialization parameter?
What is the FAST_START_MTTR_TARGET initialization parameter?
Rating:
The FAST_START_MTTR_TARGET initialization parameter is used to specify the amount of time (in seconds) a database should take to perform a crash or instance recovery. The value set for the FAST_START_MTTR_TARGET initialization parameter is internally converted to a set of parameters that modify the operation of Oracle in such a way that recovery time is as close to this estimate as possible.
The FAST_START_IO_TARGET, LOG_CHECKPOINT_INTERVAL, and LOG_CHECKPOINT_TIMEOUT initialization parameters should not be used when using the FAST_START_MTTR_TARGET initialization parameter. Setting these parameters to active values obstructs the normal functioning of the FAST_START_MTTR_TARGET initialization parameter, resulting in unexpected results.
The maximum value that can be set for the FAST_START_MTTR_TARGET initialization parameter is 3600. If a value greater than 3600 is set, Oracle automatically rounds it to 3600.
Rating:
Other articles
- What is checkpoint process (CKPT)?
- What is a control file?
- How is a checkpoint related to the cache recovery phase of a recovery process?
- What is an inconsistent backup?
- What is a full backup?
