暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

12c An internal routine has requested a dump of selected redo

原创 问题归档 2019-04-14
4078

问题描述

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

专家解答

官方表示如果数据库正常运行,日志正常归档,可以直接忽略这个消息。

或者是通过升级不让该消息出现在告警日志中。

最后修改时间:2019-04-14 14:36:09
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论