Chinaunix首页 | 论坛 | 博客
  • 博客访问: 3672891
  • 博文数量: 715
  • 博客积分: 1860
  • 博客等级: 上尉
  • 技术积分: 7745
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-07 08:51
个人简介

偶尔有空上来看看

文章分类

全部博文(715)

文章存档

2023年(75)

2022年(134)

2021年(238)

2020年(115)

2019年(11)

2018年(9)

2017年(9)

2016年(17)

2015年(7)

2014年(4)

2013年(1)

2012年(11)

2011年(27)

2010年(35)

2009年(11)

2008年(11)

分类: Oracle

2021-11-29 22:58:51

oracle 12.1.0.2 rac 

分析一个集群重启故障时,发现ocssd.trc中的信息突然时间倒退了,而没有任何异常,看日志的时间戳:

  1. 2021-11-24 20:54:40.814556 : CSSD:1876809472: clssgmMbrDataUpdt: Processing member data change type 1, size 4 for group HB+ASM, memberID 8:2:2
  2. 2021-11-24 20:54:40.814563 : CSSD:1876809472: clssgmMbrDataUpdt: Sending member data change to GMP for group HB+ASM, memberID 8:2:2
  3. 2021-11-24 20:54:40.814800 : CSSD:1879045888: clssgmpcMemberDataUpdt: grockName HB+ASM memberID 8:2:2, datatype 1 datasize 4
  4. 2021-11-24 20:54:40.815186 : CSSD:1873655552: clssgmcpDataUpdtCmpl: Status 0 mbr data updt memberID 8:2:2 from clientID 2:31:4
  5. 2021-11-24 20:54:42.394549 : CSSD:1839511296: clssnmSendingThread: sending status msg to all nodes
  6. 2021-11-24 20:54:42.394601 : CSSD:1839511296: clssnmSendingThread: sent 5 status msgs to all nodes
  7. 2021-11-24 20:54:42.863374 : CSSD:1876809472: clssgmMbrDataUpdt: Processing member data change type 1, size 4 for group HB+ASM, memberID 8:2:2
  8. 2021-11-24 20:54:42.863382 : CSSD:1876809472: clssgmMbrDataUpdt: Sending member data change to GMP for group HB+ASM, memberID 8:2:2
  9. 2021-11-24 20:54:42.863597 : CSSD:1879045888: clssgmpcMemberDataUpdt: grockName HB+ASM memberID 8:2:2, datatype 1 datasize 4
  10. 2021-11-24 20:54:42.864076 : CSSD:1873655552: clssgmcpDataUpdtCmpl: Status 0 mbr data updt memberID 8:2:2 from clientID 2:31:4
  11. 2021-11-24 20:54:43.535713 : CSSD:1876809472: clssgmMbrDataUpdt: Processing member data change type 1, size 401 for group GR+N_2, memberID 2147483660:2:1
  12. 2021-11-24 20:54:43.535778 : CSSD:1876809472: clssgmSendEventsToMbrs: Group GR+N_2, member count 2, event master 0, event type 6, event incarn 107328, event member count 1, pids 22961, 30634,
  13. 2021-11-24 20:54:44.949724 : CSSD:1876809472: clssgmMbrDataUpdt: Processing member data change type 1, size 4 for group HB+ASM, memberID 8:2:2
  14. 2021-11-24 20:54:44.949732 : CSSD:1876809472: clssgmMbrDataUpdt: Sending member data change to GMP for group HB+ASM, memberID 8:2:2
  15. 2021-11-24 20:04:44.870844 : CSSD:1839511296: clssnmSendingThread: sent 5 status msgs to all nodes
  16. 2021-11-24 20:04:45.122266 : CSSD:1876809472: clssgmMbrDataUpdt: Processing member data change type 1, size 4 for group HB+ASM, memberID 8:2:2
  17. 2021-11-24 20:04:45.122274 : CSSD:1876809472: clssgmMbrDataUpdt: Sending member data change to GMP for group HB+ASM, memberID 8:2:2
  18. 2021-11-24 20:04:45.122473 : CSSD:1879045888: clssgmpcMemberDataUpdt: grockName HB+ASM memberID 8:2:2, datatype 1 datasize 4
  19. 2021-11-24 20:04:45.122859 : CSSD:1873655552: clssgmcpDataUpdtCmpl: Status 0 mbr data updt memberID 8:2:2 from clientID 2:31:4
  20. 2021-11-24 20:04:47.171136 : CSSD:1876809472: clssgmMbrDataUpdt: Processing member data change type 1, size 4 for group HB+ASM, memberID 8:2:2
  21. 2021-11-24 20:04:47.171144 : CSSD:1876809472: clssgmMbrDataUpdt: Sending member data change to GMP for group HB+ASM, memberID 8:2:2
  22. 2021-11-24 20:04:47.171368 : CSSD:1879045888: clssgmpcMemberDataUpdt: grockName HB+ASM memberID 8:2:2, datatype 1 datasize 4
  23. 2021-11-24 20:04:47.171789 : CSSD:1873655552: clssgmcpDataUpdtCmpl: Status 0 mbr data updt memberID 8:2:2 from clientID 2:31:4
  24. 2021-11-24 20:04:49.221572 : CSSD:1876809472: clssgmMbrDataUpdt: Processing member data change type 1, size 4 for group HB+ASM, memberID 8:2:2
  25. 2021-11-24 20:04:49.221584 : CSSD:1876809472: clssgmMbrDataUpdt: Sending member data change to GMP for group HB+ASM, memberID 8:2:2
  26. 2021-11-24 20:04:49.221840 : CSSD:1879045888: clssgmpcMemberDataUpdt: grockName HB+ASM memberID 8:2:2, datatype 1 datasize 4
  27. 2021-11-24 20:04:49.222266 : CSSD:1873655552: clssgmcpDataUpdtCmpl: Status 0 mbr data updt memberID 8:2:2 from clientID 2:31:4
  28. 2021-11-24 20:04:49.871622 : CSSD:1839511296: clssnmSendingThread: sending status msg to all nodes
  29. 2021-11-24 20:04:49.871676 : CSSD:1839511296: clssnmSendingThread: sent 5 status msgs to all nodes
  30. 2021-11-24 20:04:51.273273 : CSSD:1876809472: clssgmMbrDataUpdt: Processing member data change type 1, size 4 for group HB+ASM, memberID 8:2:2

从20:54一下“回退到 20:04,而且奇怪的是,多个ocssd.trc日期被改写为同一时间点了(就是故障时间)

这个ocssd.trc每当涨到50MB时就被归档到一个文件中,时间顺序应该是递增的,不应该是同一个时间点。
一开始以为时间被调整了。
用notepad++打开后搜索,发现信息重复多次



后来发现
12.1.0.2 clssdadr_bucketThread线程导致ocssd.bin CPU使用率过高的问题 (Doc ID 2364202.1)


补丁才32.8K

阅读(920) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~