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

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

0

积分

0

好友

6

主题
1#
发表于 2014-5-22 12:08:08 | 查看: 2992| 回复: 0
AIX6100-07-04-1216 + HACMP + ORACLE10.2.0.1 RAC

原来正常使用,这几天节点1正常,节点2 css 不能启动。


crsd.log 部分内容
2014-05-22 09:35:36.310: [ COMMCRS][317]clsc_connect: (11098bd70) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_rac2_crs))
2014-05-22 09:35:36.310: [ CSSCLNT][1]clsssInitNative: connect failed, rc 9
2014-05-22 09:35:36.311: [  CRSRTI][1]32CSS is not ready. Received status 3 from CSS. Waiting for good status ..
2014-05-22 09:35:37.644: [ COMMCRS][319]clsc_connect: (11098bd70) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_rac2_crs))
2014-05-22 09:35:37.644: [ CSSCLNT][1]clsssInitNative: connect failed, rc 9
2014-05-22 09:35:37.644: [  CRSRTI][1]32CSS is not ready. Received status 3 from CSS. Waiting for good status ..
2014-05-22 09:35:38.978: [ COMMCRS][321]clsc_connect: (11098bd70) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_rac2_crs))
2014-05-22 09:35:38.978: [ CSSCLNT][1]clsssInitNative: connect failed, rc 9
2014-05-22 09:35:38.978: [  CRSRTI][1]32CSS is not ready. Received status 3 from CSS. Waiting for good status ..


ocssd.log 部分内容
[CSSD]2014-05-22 09:35:37.329 [1] >TRACE:   clssnmInitNMInfo: misscount set to 600
[CSSD]2014-05-22 09:35:37.331 [1] >TRACE:   clssnmDiskStateChange: state from 1 to 2 disk (0//dev/rrac_vote)
[CSSD]2014-05-22 09:35:39.333 [1543] >TRACE:   clssnmDiskStateChange: state from 2 to 4 disk (0//dev/rrac_vote)
[CSSD]2014-05-22 09:35:39.336 [1543] >TRACE:   clssnmReadDskHeartbeat: node(1) is down. rcfg(4) wrtcnt(1459468) LATS(0) Disk lastSeqNo(1459468)
[CSSD]2014-05-22 09:35:39.433 [1] >TRACE:   clssnmFatalInit: fatal mode enabled
[CSSD]2014-05-22 09:35:39.439 [2057] >TRACE:   clssnmconnect: connecting to node 2, flags 0x0001, connector 1
[CSSD]2014-05-22 09:35:39.448 [2057] >TRACE:   clssnmconnect: connecting to node 1, flags 0x0001, connector 0
[CSSD]2014-05-22 09:35:39.502 [2314] >TRACE:   clssgmclientlsnr: listening on (ADDRESS=(PROTOCOL=ipc)(KEY=Oracle_CSS_LclLstnr_crs_2))
[CSSD]2014-05-22 09:35:39.502 [2314] >TRACE:   clssgmclientlsnr: listening on (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_rac2_crs))
[CSSD]2014-05-22 09:35:40.339 [1543] >TRACE:   clssnmReadDskHeartbeat: node(1) is down. rcfg(4) wrtcnt(1459469) LATS(1470324929) Disk lastSeqNo(1459469)
[CSSD]2014-05-22 09:35:41.349 [1543] >TRACE:   clssnmReadDskHeartbeat: node(1) is down. rcfg(4) wrtcnt(1459470) LATS(1470325939) Disk lastSeqNo(1459470)
[CSSD]2014-05-22 09:35:42.359 [1543] >TRACE:   clssnmReadDskHeartbeat: node(1) is down. rcfg(4) wrtcnt(1459471) LATS(1470326949) Disk lastSeqNo(1459471)

hacmp 正常启动。 datavg concurentvg 正常带起。
两个节点上lsvg datavg ; lsvg -l datavg 状态正常。
public ip 和 心跳地址 都能相互ping通。
public ip ping 网关地址也正常。

ocr disk \ voting disk 用的两个lv,状态在两个节点上都是open;

出问题的节点2上的完整日志打包在附件中。
怀疑是共享磁盘的问题,但是如何解决呢?

20140522log.rar

677.29 KB, 下载次数: 616

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

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

GMT+8, 2024-12-21 03:54 , Processed in 0.045740 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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