2.3.7 FAST_START_MTTR_TARGET

11g在这个参数的设置上应该发生了变化，以下是11.2.0.1.0的生产数据的查询数据。fast_start_mttr_target 参数被默认设置为0了，但是ESTIMATED_MTTR 为84

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

 

SQL> show parameter fast;

NAME                                 TYPE       VALUE
------------------------------------ ---------- ------------------------------
fast_start_io_target                 integer    0
fast_start_mttr_target               integer    0
fast_start_parallel_rollback         string     LOW
SQL> select RECOVERY_ESTIMATED_IOS REIO,
  2  ACTUAL_REDO_BLKS ARB,
  3  TARGET_REDO_BLKS TRB,
  4  LOG_FILE_SIZE_REDO_BLKS LFSRB,
  5  LOG_CHKPT_TIMEOUT_REDO_BLKS LCTRB,
  6  LOG_CHKPT_INTERVAL_REDO_BLKS LCIRB,
  7  FAST_START_IO_TARGET_REDO_BLKS FSIOTRB,
  8  TARGET_MTTR TMTTR,
  9  ESTIMATED_MTTR EMTTR,
 10  CKPT_BLOCK_WRITES CBW
 11  from v$instance_recovery;

      REIO        ARB        TRB      LFSRB      LCTRB      LCIRB    FSIOTRB
---------- ---------- ---------- ---------- ---------- ---------- ----------
     TMTTR      EMTTR        CBW
---------- ---------- ----------
    125358    2596385    3010023    3397383    3010023
         0         84   20871841