告警日志提示FAST

告警日志提示FAST

查看告警日志，发现有提示FAST_START_MTTR_TARGET过低问题

如下：

Fri Jan 06 09:10:40 2017
Archived Log entry 216246 added for thread 1 sequence 108168 ID 0xa33043e3 dest 1:
Fri Jan 06 09:10:42 2017
LNS: Standby redo logfile selected for thread 1 sequence 108169 for destination LOG_ARCHIVE_DEST_2
Fri Jan 06 09:11:35 2017
FAST_START_MTTR_TARGET 60 is set too low, using minimum achievable MTTR 61 instead.
Fri Jan 06 09:12:25 2017
FAST_START_MTTR_TARGET 60 is set too low, using minimum achievable MTTR 61 instead.
Fri Jan 06 09:13:25 2017
FAST_START_MTTR_TARGET 60 is set too low, using minimum achievable MTTR 61 instead.
Fri Jan 06 09:14:35 2017
FAST_START_MTTR_TARGET 60 is set too low, using minimum achievable MTTR 61 instead.
Fri Jan 06 09:15:25 2017
FAST_START_MTTR_TARGET 60 is set too low, using minimum achievable MTTR 61 instead.
Fri Jan 06 09:16:26 2017
FAST_START_MTTR_TARGET 60 is set too low, using minimum achievable MTTR 61 instead.
Fri Jan 06 09:17:26 2017
FAST_START_MTTR_TARGET 60 is set too low, using minimum achievable MTTR 61 instead.
Fri Jan 06 09:17:47 2017

查看参数值，修改后

SQL>show parameter FAST_START_MTTR_TARGET


NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
fast_start_mttr_target     integer 60
SQL>alter system set fast_start_mttr_target=120;


System altered.

不再提示：

MTTR advisory was temporarily turned off because FAST_START_MTTR_TARGET was altered.
ALTER SYSTEM SET fast_start_mttr_target=120 SCOPE=BOTH;