问题描述
Oracle 12C 的alert日志中经常会出现上面的内容,网上查了下资料说是丢失在线日志的话会报这个,但是数据库一直正常,请问下有没有其他的可能导致这个问题出现.
2019-03-29T06:00:11.889260+08:00
JS(3):*****************************************************************
JS(3):An internal routine has requested a dump of selected redo.
JS(3):This usually happens following a specific internal error, when
JS(3):analysis of the redo logs will help Oracle Support with the
JS(3):diagnosis.
JS(3):It is recommended that you retain all the redo logs generated (by
JS(3):all the instances) during the past 12 hours, in case additional
JS(3):redo dumps are required to help with the diagnosis.
JS(3):*****************************************************************
JS(3):TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2635 (43552) VALUES LESS THAN (TO_DATE(' 2019-03-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
JS(3):TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2638 (43552) VALUES LESS THAN (TO_DATE(' 2019-03-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-29T06:00:17.356580+08:00
CUSTOMER(4):TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2512 (43552) VALUES LESS THAN (TO_DATE(' 2019-03-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
CUSTOMER(4):TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2515 (43552) VALUES LESS THAN (TO_DATE(' 2019-03-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-29T06:00:21.172319+08:00
Thread 2 advanced to log sequence 2224 (LGWR switch)
Current log# 4 seq# 2224 mem# 0: +DATA/ORCL/ONLINELOG/group_4.271.990480273
Current log# 4 seq# 2224 mem# 1: +FIR/ORCL/ONLINELOG/group_4.260.990480275
2019-03-29T06:00:21.396229+08:00
Archived Log entry 4319 added for T-2.S-2223 ID 0x85e56dfd LAD:1
2019-03-29T06:05:50.374349+08:00
PAYENGINE(7):TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2552 (43552) VALUES LESS THAN (TO_DATE(' 2019-03-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PAYENGINE(7):TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2555 (43552) VALUES LESS THAN (TO_DATE(' 2019-03-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-29T06:05:55.308549+08:00
CASHIER(5):TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2696 (43552) VALUES LESS THAN (TO_DATE(' 2019-03-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
CASHIER(5):TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2699 (43552) VALUES LESS THAN (TO_DATE(' 2019-03-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-29T06:15:53.038840+08:00
SUPERGW(6):TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2432 (43552) VALUES LESS THAN (TO_DATE(' 2019-03-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
SUPERGW(6):TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2435 (43552) VALUES LESS THAN (TO_DATE(' 2019-03-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-29T07:15:55.038356+08:00
Thread 2 advanced to log sequence 2225 (LGWR switch)
Current log# 3 seq# 2225 mem# 0: +DATA/ORCL/ONLINELOG/group_3.270.990480273
Current log# 3 seq# 2225 mem# 1: +FIR/ORCL/ONLINELOG/group_3.259.990480273
2019-03-29T07:15:55.230514+08:00
Archived Log entry 4320 added for T-2.S-2224 ID 0x85e56dfd LAD:1
2019-03-29T08:16:06.792036+08:00
Thread 2 advanced to log sequence 2226 (LGWR switch)
Current log# 4 seq# 2226 mem# 0: +DATA/ORCL/ONLINELOG/group_4.271.990480273
Current log# 4 seq# 2226 mem# 1: +FIR/ORCL/ONLINELOG/group_4.260.990480275
2019-03-29T08:16:07.001665+08:00
Archived Log entry 4321 added for T-2.S-2225 ID 0x85e56dfd LAD:1
WARNING: too many parse errors, count=430 SQL hash=0x750004bb
PARSE ERROR: ospid=45899, error=933 for statement:
2019-03-16T10:10:45.045954+08:00
DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name
Additional information: hd=0x1b983b748 phd=0x1b983cea0 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0
2019-03-16T10:10:45.046067+08:00
----- PL/SQL Call Stack -----
object line object
handle number name
0x10fad5b48 259 type body SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION
0x1efdb6970 2134 package body SYS.PRVT_ADVISOR.COMMON_DELETE_TASK
0x1efdb6970 7342 package body SYS.PRVT_ADVISOR.DELETE_EXPIRED_TASKS
0x12f291ee0 1 anonymous block
专家解答
官方表示如果数据库正常运行,日志正常归档,可以直接忽略这个消息。
或者是通过升级不让该消息出现在告警日志中。