查看告警日志,发现有提示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;