DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: cant set fast_start_mttr_target parameter

Threaded View

  1. #3
    Join Date
    Feb 2003
    Location
    Peru
    Posts
    39
    FAST_START_MTTR_TARGET:
    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.

    Note:
    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:

    LOG_CHECKPOINT_TIMEOUT
    LOG_CHECKPOINT_INTERVAL
    FAST_START_IO_TARGET

    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.

    (extracted from tahiti.oracle.com)

    I am forgetting something?
    Last edited by gvillaran; 09-24-2004 at 12:18 PM.
    Gustavo Villaran

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width