查看: 1285|回复: 4

RAC 一个节点重启

[复制链接]
论坛徽章:
0
发表于 2016-12-1 16:02 | 显示全部楼层 |阅读模式
数据库版本11.2.0.1
OS平台 AIX 6.1
在RAC 节点2中出现了如下告警,导致数据库实例重启。
Wed Nov 30 05:58:28 2016
Thread 2 advanced to log sequence 61678 (LGWR switch)
  Current log# 4 seq# 61678 mem# 0: +DATADG/orcl/onlinelog/group_4.272.830208823
Wed Nov 30 05:58:28 2016
Archived Log entry 136600 added for thread 2 sequence 61677 ID 0x50f0c7ec dest 1:
Wed Nov 30 07:04:18 2016
Reconfiguration started (old inc 84, new inc 86)
List of instances:
2 (myinst: 2)
Global Resource Directory frozen
* dead instance detected - domain 0 invalid = TRUE
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Wed Nov 30 07:04:18 2016
Wed Nov 30 07:04:18 2016
LMS 0: 1 GCS shadows cancelled, 0 closed, 0 Xw survived
LMS 1: 1 GCS shadows cancelled, 1 closed, 0 Xw survived
Wed Nov 30 07:04:18 2016
LMS 2: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Post SMON to start 1st pass IR
Wed Nov 30 07:04:19 2016
Instance recovery: looking for dead threads
Instance recovery: lock domain invalid but no dead threads
Wed Nov 30 07:04:40 2016
Reconfiguration started (old inc 86, new inc 88)
List of instances:
1 2 (myinst: 2)
Nested reconfiguration detected.
Global Resource Directory frozen
Communication channels reestablished
Wed Nov 30 07:04:42 2016
* domain 0 valid = 0 according to instance 1
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Wed Nov 30 07:04:42 2016
LMS 2: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Wed Nov 30 07:04:42 2016
Wed Nov 30 07:04:42 2016
LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Post SMON to start 1st pass IR
Wed Nov 30 07:04:54 2016
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
Wed Nov 30 07:04:57 2016
Instance recovery: looking for dead threads
Instance recovery: lock domain invalid but no dead threads
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xA51B0EE8] [PC:0x10414D37C, kcbo_get_qheader()+252] [flags: 0x0, count
: 1]
Errors in file /oracle/db/diag/rdbms/orcl/orcl2/trace/orcl2_smon_56361408.trc  (incident=768311):
ORA-07445: exception encountered: core dump [kcbo_get_qheader()+252] [SIGSEGV] [ADDR:0xA51B0EE8] [PC:0x10414D37C] [Address not mapped
to object] []
Incident details in: /oracle/db/diag/rdbms/orcl/orcl2/incident/incdir_768311/orcl2_smon_56361408_i768311.trc
Wed Nov 30 07:04:59 2016
Trace dumping is performing id=[cdmp_20161130070459]
Wed Nov 30 07:05:01 2016
Sweep [inc][768311]: completed
Sweep [inc2][768311]: completed
Wed Nov 30 07:05:01 2016
PMON (ospid: 63438998): terminating the instance due to error 474
Wed Nov 30 07:05:01 2016
opiodr aborting process unknown ospid (45220222) as a result of ORA-1092
Instance terminated by PMON, pid = 63438998
Wed Nov 30 07:06:21 2016
Starting ORACLE instance (normal)
sskgpgetexecname failed to get name


论坛徽章:
120
现任管理团队成员
日期:2011-05-07 01:45:08乌索普
日期:2019-02-14 23:54:04
发表于 2016-12-2 16:53 | 显示全部楼层
bug 7032266
11.2.0.1 怎么能用在生产系统中呢?

使用道具 举报

回复
认证徽章
论坛徽章:
36
数据库板块每日发贴之星
日期:2008-06-23 01:01:58奥运会纪念徽章:足球
日期:2012-08-21 19:26:212013年新春福章
日期:2013-02-25 14:51:24蜘蛛蛋
日期:2013-05-03 17:38:25一汽
日期:2013-08-19 16:12:56保时捷
日期:2013-10-18 23:41:21阿斯顿马丁
日期:2013-11-11 14:17:47大众
日期:2013-11-17 16:50:19问答徽章
日期:2014-01-13 00:25:10马上有车
日期:2014-08-03 11:06:20
发表于 2016-12-11 12:59 | 显示全部楼层
生产系统一定要基于基本版本应用PSU及GI PSU,进行安全加固。一旦出现故障及停机,将是对业务及运维人员的极大阻滞

使用道具 举报

回复
论坛徽章:
0
 楼主| 发表于 2017-2-20 10:06 | 显示全部楼层
的确查出来的是个BUG

使用道具 举报

回复
论坛徽章:
0
 楼主| 发表于 2017-2-20 10:06 | 显示全部楼层
zergduan 发表于 2016-12-2 16:53
bug 7032266
11.2.0.1 怎么能用在生产系统中呢?

嗯呢,的确这个版本的BUG很多的

使用道具 举报

回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 
京ICP备09055130号-4  北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表