Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

20

积分

0

好友

5

主题
1#
发表于 2012-12-14 11:56:32 | 查看: 6708| 回复: 2
服务器windows2008r2,数据库版本11.2.0.3

crsd日志中反复报错,只有这一种错误,直到重启后才恢复,这个报错是从ocr获取信息失败的报错吗?

2012-12-11 07:19:31.583: [  OCRMSG][4232]prom_rpc: possible OCR retry scenario
2012-12-11 07:19:31.583: [  OCRSRV][4232]proas_forward_request: PROM_TIME_OUT or Master Fail
2012-12-11 07:19:31.598: [  OCRMSG][3936]prom_send: Failed to send [12]
2012-12-11 07:19:31.598: [  OCRMSG][3936]GIPC error [12] msg [gipcretConnectionLost]
2012-12-11 07:19:31.598: [  OCRMSG][3936]prom_rpc: CLSC send failure..ret code 203
2012-12-11 07:19:31.598: [  OCRMSG][3936]prom_rpc: possible OCR retry scenario
2012-12-11 07:19:31.598: [  OCRSRV][3936]proas_forward_request: PROM_TIME_OUT or Master Fail
2012-12-11 07:19:31.645: [  OCRMSG][2880]prom_send: Failed to send [12]
2012-12-11 07:19:31.645: [  OCRMSG][2880]GIPC error [12] msg [gipcretConnectionLost]
2012-12-11 07:19:31.645: [  OCRMSG][2880]prom_rpc: CLSC send failure..ret code 203
2012-12-11 07:19:31.645: [  OCRMSG][2880]prom_rpc: possible OCR retry scenario
2012-12-11 07:19:31.645: [  OCRSRV][2880]proas_forward_request: PROM_TIME_OUT or Master Fail
2012-12-11 07:19:31.661: [  OCRMSG][4328]prom_send: Failed to send [12]
2012-12-11 07:19:31.661: [  OCRMSG][4328]GIPC error [12] msg [gipcretConnectionLost]
2012-12-11 07:19:31.661: [  OCRMSG][4328]prom_rpc: CLSC send failure..ret code 203
2012-12-11 07:19:31.661: [  OCRMSG][4328]prom_rpc: possible OCR retry scenario
2012-12-11 07:19:31.661: [  OCRSRV][4328]proas_forward_request: PROM_TIME_OUT or Master Fail
3#
发表于 2012-12-14 13:56:22
共享存储在一分钟内断开3次又恢复连接后,过了几秒crs就开始报这个错,直到重启。
心跳网络现在正常的,没能重现。
附上当时的cssd日志,能否有所解释
  1. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmDeadProc: proc 0000000007A90140
  2. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmFenceClient: fencing client (0000000007B1A510), member 1 in group CLSN.ONSPROC.MASTER, no share, death fence 1, SAGE fence 0
  3. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmUnreferenceMember: global grock CLSN.ONSPROC.MASTER member 1 refcount is 1
  4. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmFenceProcessDeath: client (0000000007B1A510) pid 4616 undead
  5. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmQueueFenceForCheck: (0000000007988C30) Death check for object type 3, pid 4616
  6. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmFenceClient: fencing client (0000000007B19F70), member 1 in group CLSN.ONSNETPROC.MASTER, no share, death fence 1, SAGE fence 0
  7. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmUnreferenceMember: global grock CLSN.ONSNETPROC.MASTER member 1 refcount is 1
  8. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmFenceProcessDeath: client (0000000007B19F70) pid 4616 undead
  9. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmQueueFenceForCheck: (0000000007DA56F0) Death check for object type 3, pid 4616
  10. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmFenceClient: fencing client (0000000007B72720), member 1 in group CLSN.AQPROC.orcl.MASTER, no share, death fence 1, SAGE fence 0
  11. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmUnreferenceMember: global grock CLSN.AQPROC.orcl.MASTER member 1 refcount is 1
  12. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmFenceProcessDeath: client (0000000007B72720) pid 4616 undead
  13. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmQueueFenceForCheck: (0000000007DA5330) Death check for object type 3, pid 4616
  14. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmFenceClient: fencing client (0000000007B72960), member 1 in group CLSN.RLB.orcl.MASTER, no share, death fence 1, SAGE fence 0
  15. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmUnreferenceMember: global grock CLSN.RLB.orcl.MASTER member 1 refcount is 1
  16. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmFenceProcessDeath: client (0000000007B72960) pid 4616 undead
  17. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmQueueFenceForCheck: (0000000007DA5930) Death check for object type 3, pid 4616
  18. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmDiscEndpcl: gipcDestroy 0000000000002E65
  19. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmDiscEndpcl: gipcDestroy 00000000000030C6
  20. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmDiscEndpcl: gipcDestroy 0000000004D8ADEB
  21. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmDiscEndpcl: gipcDestroy 0000000004D8AEB4
  22. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmDestroyProc: cleaning up proc(0000000007A90140) con(0000000100002B80) skgpid  ospid 4616 with 0 clients, refcount 0
  23. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmDiscEndpcl: gipcDestroy 0000000000002B80
  24. 2012-12-11 07:16:24.570: [    CSSD][4700]clssgmFenceCompletion: (0000000007988C30) process death fence completed for process 4616, object type 3
  25. 2012-12-11 07:16:24.570: [    CSSD][4700]clssgmTermMember: Terminating member 1 (0000000007B6FFC0) in grock CLSN.ONSPROC.MASTER
  26. 2012-12-11 07:16:24.570: [    CSSD][4700]clssgmUnreferenceMember: global grock CLSN.ONSPROC.MASTER member 1 refcount is 0
  27. 2012-12-11 07:16:24.570: [    CSSD][4700]clssgmAllocateRPCIndex: allocated rpc 274 (0000000005C52330)
  28. 2012-12-11 07:16:24.570: [    CSSD][4700]clssgmRPC: rpc 0000000005C52330 (RPC#274) tag(112002a) sent to node 3
  29. 2012-12-11 07:16:24.570: [    CSSD][4696]clssgmTestSetLastGrockUpdate: grock(CLSN.ONSPROC.MASTER), updateseq(294) msgseq(295), lastupdt<0000000007D2B010>, ignoreseq(0)
  30. 2012-12-11 07:16:24.570: [    CSSD][4696]clssgmRemoveMember: grock CLSN.ONSPROC.MASTER, member number 1 (0000000007B6FFC0) node number 1 state 0x0 grock type 2
  31. 2012-12-11 07:16:24.570: [    CSSD][4696]clssgmRPCDone: rpc 0000000005C52330 (RPC#274) state 6, flags 0x100
  32. 2012-12-11 07:16:24.570: [    CSSD][4696]clssgmDelMemCmpl: rpc 0000000005C52330, ret 0, client 0000000000000000 member 0000000007B6FFC0
  33. 2012-12-11 07:16:24.570: [    CSSD][4696]clssgmFreeRPCIndex: freeing rpc 274
  34. 2012-12-11 07:16:24.570: [    CSSD][4696]clssgmHandleGrockRcfgUpdate: grock(CLSN.ONSPROC.MASTER), updateseq(295), status(0), sendresp(1)
  35. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmUnregisterShared: Same group share client 1 (0000000007D17A00), grp DBORCL, member 0
  36. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmTermShare: (0000000007D35550) global grock DBORCL member 0 type 1
  37. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmUnreferenceMember: global grock DBORCL member 0 refcount is 20
  38. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmDiscEndpcl: gipcDestroy 0000000004D8A824
  39. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmUnregisterShared: Same group share client 3 (0000000007CD4720), grp DG_LOCAL_FLASHAREA, member 0
  40. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmTermShare: (0000000007E85430) local grock DG_LOCAL_FLASHAREA member 0 type 1
  41. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmUnreferenceMember: local grock DG_LOCAL_FLASHAREA member 0 refcount is 10
  42. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmDiscEndpcl: gipcDestroy 0000000004D8A938
  43. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmUnregisterShared: Same group share client 2 (0000000007CD4600), grp DG_LOCAL_DATA01, member 0
  44. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmTermShare: (0000000007D35170) local grock DG_LOCAL_DATA01 member 0 type 1
  45. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmUnreferenceMember: local grock DG_LOCAL_DATA01 member 0 refcount is 17
  46. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmDiscEndpcl: gipcDestroy 0000000004D8A922
  47. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmDeadProc: proc 0000000007D276C0
  48. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmDestroyProc: cleaning up proc(0000000007D276C0) con(0000000004D8A7F5) skgpid 13328 ospid 6084-13328-129990631307634263 with 0 clients, refcount 0
  49. 2012-12-11 07:16:24.570: [    CSSD][1424]clssgmDiscEndpcl: gipcDestroy 0000000004D8A7F5
复制代码

回复 只看该作者 道具 举报

2#
发表于 2012-12-14 13:35:00
1. 这可能与网络有关  建议你检测节点间 心跳网络

包括是否有防火墙 MTU参数等

2. 什么场景下出现该问题?

回复 只看该作者 道具 举报

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

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-16 04:38 , Processed in 0.049124 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569