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

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

0

积分

0

好友

4

主题
1#
发表于 2013-7-16 20:49:28 | 查看: 4743| 回复: 5
本帖最后由 javahp 于 2013-7-16 20:49 编辑


环境:[root@node11 bin]#  ./crsctl query crs softwareversion
CRS software version on node [node11] is [10.2.0.4.0]
现象: crs在实node22上启动正常,但是在node11上启动报错,具体入下:
请大神们帮忙看下,谢谢!!

[    CSSD]2013-07-16 20:36:44.892 >USER:    Copyright 2013, Oracle version 10.2.0.4.0
[    CSSD]2013-07-16 20:36:44.892 >USER:    CSS daemon log for node node11, number 1, in cluster crs
[  clsdmt]Listening to (ADDRESS=(PROTOCOL=ipc)(KEY=node11DBG_CSSD))
[    CSSD]2013-07-16 20:36:44.901 [1286952256] >TRACE:   clssscmain: local-only set to false
[    CSSD]2013-07-16 20:36:44.908 [1286952256] >TRACE:   clssnmReadNodeInfo: added node 1 (node11) to cluster
[    CSSD]2013-07-16 20:36:44.913 [1286952256] >TRACE:   clssnmReadNodeInfo: added node 2 (node22) to cluster
[    CSSD]2013-07-16 20:36:44.925 [1117329728] >TRACE:   clssnm_skgxninit: Compatible vendor clusterware not in use
[    CSSD]2013-07-16 20:36:44.925 [1117329728] >TRACE:   clssnm_skgxnmon: skgxn init failed
[    CSSD]2013-07-16 20:36:44.927 [1286952256] >TRACE:   clssnmNMInitialize: misscount set to (60)
[    CSSD]2013-07-16 20:36:44.928 [1286952256] >TRACE:   clssnmNMInitialize: Network heartbeat thresholds are: impending reconfig 30000 ms, reconfig start (misscount) 60000 ms
[    CSSD]2013-07-16 20:36:44.931 [1286952256] >TRACE:   clssnmDiskStateChange: state from 1 to 2 disk (0//ocr_voting/voting1)
[    CSSD]2013-07-16 20:36:44.931 [1117329728] >TRACE:   clssnmvDPT: spawned for disk 0 (/ocr_voting/voting1)
[    CSSD]2013-07-16 20:36:44.933 [1286952256] >TRACE:   clssnmDiskStateChange: state from 1 to 2 disk (1//ocr_voting_standby/voting2)
[    CSSD]2013-07-16 20:36:44.941 [1127819584] >TRACE:   clssnmvDPT: spawned for disk 1 (/ocr_voting_standby/voting2)
[    CSSD]2013-07-16 20:36:44.943 [1286952256] >TRACE:   clssnmDiskStateChange: state from 1 to 2 disk (2//ocr_voting_standby/voting3)
[    CSSD]2013-07-16 20:36:44.952 [1138309440] >TRACE:   clssnmvDPT: spawned for disk 2 (/ocr_voting_standby/voting3)
[    CSSD]2013-07-16 20:36:46.944 [1117329728] >TRACE:   clssnmDiskStateChange: state from 2 to 4 disk (0//ocr_voting/voting1)
[    CSSD]2013-07-16 20:36:46.952 [1148799296] >TRACE:   clssnmvKillBlockThread: spawned for disk 0 (/ocr_voting/voting1) initial sleep interval (1000)ms
[    CSSD]2013-07-16 20:36:46.953 [1117329728] >TRACE:   clssnmReadDskHeartbeat: node(2) is down. rcfg(14) wrtcnt(13347) LATS(4981054) Disk lastSeqNo(13347)
[    CSSD]2013-07-16 20:36:46.971 [1127819584] >TRACE:   clssnmDiskStateChange: state from 2 to 4 disk (1//ocr_voting_standby/voting2)
[    CSSD]2013-07-16 20:36:46.979 [1159289152] >TRACE:   clssnmvKillBlockThread: spawned for disk 1 (/ocr_voting_standby/voting2) initial sleep interval (1000)ms
[    CSSD]2013-07-16 20:36:46.980 [1127819584] >TRACE:   clssnmReadDskHeartbeat: node(2) is down. rcfg(14) wrtcnt(13347) LATS(4981084) Disk lastSeqNo(13347)
[    CSSD]2013-07-16 20:36:46.996 [1138309440] >TRACE:   clssnmDiskStateChange: state from 2 to 4 disk (2//ocr_voting_standby/voting3)
[    CSSD]2013-07-16 20:36:47.005 [1169779008] >TRACE:   clssnmvKillBlockThread: spawned for disk 2 (/ocr_voting_standby/voting3) initial sleep interval (1000)ms
[    CSSD]2013-07-16 20:36:47.005 [1138309440] >TRACE:   clssnmReadDskHeartbeat: node(2) is down. rcfg(14) wrtcnt(13347) LATS(4981104) Disk lastSeqNo(13347)
[    CSSD]
[    CSSD]
    .
    .
    .
    .
[    CSSD]
[    CSSD]
[    CSSD]
[    CSSD]

[    CSSD]2013-07-16 20:36:44.901 [1286952256] >TRACE:   clssscmain: local-only set to false
[    CSSD]2013-07-16 20:36:44.908 [1286952256] >TRACE:   clssnmReadNodeInfo: added node 1 (node11) to cluster
[    CSSD]2013-07-16 20:36:44.913 [1286952256] >TRACE:   clssnmReadNodeInfo: added node 2 (node22) to cluster
[    CSSD]2013-07-16 20:36:44.913 [1286952256] >TRACE:   clssnmInitNMInfo: Initialized with unique 1373978204
[    CSSD]2013-07-16 20:36:44.916 [1286952256] >TRACE:   clssNMInitialize: Initializing with OCR id (2059393587)
[    CSSD]2013-07-16 20:36:44.925 [1117329728] >TRACE:   clssnm_skgxninit: Compatible vendor clusterware not in use
[    CSSD]2013-07-16 20:36:44.925 [1117329728] >TRACE:   clssnm_skgxnmon: skgxn init failed
[    CSSD]2013-07-16 20:36:44.927 [1286952256] >TRACE:   clssnmNMInitialize: misscount set to (60)
[    CSSD]2013-07-16 20:36:44.928 [1286952256] >TRACE:   clssnmNMInitialize: Network heartbeat thresholds are: impending reconfig 30000 ms, reconfig start (misscount) 60000 ms
[    CSSD]2013-07-16 20:36:44.931 [1286952256] >TRACE:   clssnmDiskStateChange: state from 1 to 2 disk (0//ocr_voting/voting1)
[    CSSD]2013-07-16 20:36:44.931 [1117329728] >TRACE:   clssnmvDPT: spawned for disk 0 (/ocr_voting/voting1)
[    CSSD]2013-07-16 20:36:44.933 [1286952256] >TRACE:   clssnmDiskStateChange: state from 1 to 2 disk (1//ocr_voting_standby/voting2)
[    CSSD]2013-07-16 20:36:44.941 [1127819584] >TRACE:   clssnmvDPT: spawned for disk 1 (/ocr_voting_standby/voting2)
[    CSSD]2013-07-16 20:36:44.943 [1286952256] >TRACE:   clssnmDiskStateChange: state from 1 to 2 disk (2//ocr_voting_standby/voting3)
[    CSSD]2013-07-16 20:36:44.952 [1138309440] >TRACE:   clssnmvDPT: spawned for disk 2 (/ocr_voting_standby/voting3)
[    CSSD]2013-07-16 20:36:46.944 [1117329728] >TRACE:   clssnmDiskStateChange: state from 2 to 4 disk (0//ocr_voting/voting1)
[    CSSD]2013-07-16 20:36:46.952 [1148799296] >TRACE:   clssnmvKillBlockThread: spawned for disk 0 (/ocr_voting/voting1) initial sleep interval (1000)ms
[    CSSD]2013-07-16 20:36:46.953 [1117329728] >TRACE:   clssnmvReadDskHeartBeat: read ALL for Joining
[    CSSD]2013-07-16 20:36:46.953 [1117329728] >TRACE:   clssnmReadDskHeartbeat: node(2) is down. rcfg(14) wrtcnt(13347) LATS(4981054) Disk lastSeqNo(13347)
[    CSSD]2013-07-16 20:36:46.971 [1127819584] >TRACE:   clssnmDiskStateChange: state from 2 to 4 disk (1//ocr_voting_standby/voting2)
[    CSSD]2013-07-16 20:36:46.979 [1159289152] >TRACE:   clssnmvKillBlockThread: spawned for disk 1 (/ocr_voting_standby/voting2) initial sleep interval (1000)ms
[    CSSD]2013-07-16 20:36:46.980 [1127819584] >TRACE:   clssnmvReadDskHeartBeat: read ALL for Joining
[    CSSD]2013-07-16 20:36:46.980 [1127819584] >TRACE:   clssnmReadDskHeartbeat: node(2) is down. rcfg(14) wrtcnt(13347) LATS(4981084) Disk lastSeqNo(13347)
[    CSSD]2013-07-16 20:36:46.996 [1138309440] >TRACE:   clssnmDiskStateChange: state from 2 to 4 disk (2//ocr_voting_standby/voting3)
[    CSSD]2013-07-16 20:36:47.005 [1169779008] >TRACE:   clssnmvKillBlockThread: spawned for disk 2 (/ocr_voting_standby/voting3) initial sleep interval (1000)ms
[    CSSD]2013-07-16 20:36:47.005 [1138309440] >TRACE:   clssnmvReadDskHeartBeat: read ALL for Joining
[    CSSD]2013-07-16 20:36:47.005 [1138309440] >TRACE:   clssnmReadDskHeartbeat: node(2) is down. rcfg(14) wrtcnt(13347) LATS(4981104) Disk lastSeqNo(13347)
[    CSSD]2013-07-16 20:36:47.013 [1286952256] >ERROR:   Internal Error Information:
  Category: 1234
  Operation: scls_scr_setval
  Location: open
  Other: cant open file
  Dep: 2

[    CSSD]2013-07-16 20:36:47.013 [1286952256] >ERROR:   clssscSclsFatal: failure 8 reading fatal mode
[    CSSD]2013-07-16 20:36:47.013 [1286952256] >ERROR:   ###################################
[    CSSD]2013-07-16 20:36:47.013 [1286952256] >ERROR:   clssscExit: CSSD aborting
[    CSSD]2013-07-16 20:36:47.013 [1286952256] >ERROR:   ###################################
[    CSSD]--- DUMP GROCK STATE DB ---
[    CSSD]--- END OF GROCK STATE DUMP ---
[    CSSD]------- End Dump -------

[    CSSD]2013-07-16 20:36:47.013 [1286952256] >ERROR:   Internal Error Information:
  Category: 1234
  Operation: scls_scr_setval
  Location: open
  Other: cant open file
  Dep: 2

[    CSSD]2013-07-16 20:36:47.013 [1286952256] >ERROR:   clssscSclsFatal: failure 8 reading fatal mode
[    CSSD]2013-07-16 20:36:47.013 [1286952256] >ERROR:   ###################################
[    CSSD]2013-07-16 20:36:47.013 [1286952256] >ERROR:   clssscExit: CSSD aborting
[    CSSD]2013-07-16 20:36:47.013 [1286952256] >ERROR:   ###################################
[    CSSD]--- DUMP GROCK STATE DB ---
[    CSSD]--- END OF GROCK STATE DUMP ---

2#
发表于 2013-7-17 12:24:04
感觉是 voting 盘有问题, 节点一一直在尝试 发 clssnmvKillBlockThread KILL BLOCK

回复 只看该作者 道具 举报

3#
发表于 2013-7-17 16:14:08
谢谢刘大,问题解决了,估计是集成商安装的时候有问题,缺少目录:
/etc/oracle/scls_scr/$host/
吧目录手工建上,然后拷贝好cssfatal文件就ok了。

回复 只看该作者 道具 举报

4#
发表于 2013-7-31 09:57:01
javahp 发表于 2013-7-17 16:14
谢谢刘大,问题解决了,估计是集成商安装的时候有问题,缺少目录:
/etc/oracle/scls_scr/$host/
吧目录手 ...

您好啊, 当时是从另外一个节点把cssfatal复制过来就正常开启了的么?

回复 只看该作者 道具 举报

5#
发表于 2013-8-1 09:23:59
Hank-D 发表于 2013-7-31 09:57
您好啊, 当时是从另外一个节点把cssfatal复制过来就正常开启了的么?

其实你去看一下/etc/oracle/scls_scr/$HOST里面几个文件的内容,就不会有这样的疑问了。

回复 只看该作者 道具 举报

6#
发表于 2013-8-1 14:37:56
clevernby 发表于 2013-8-1 09:23
其实你去看一下/etc/oracle/scls_scr/$HOST里面几个文件的内容,就不会有这样的疑问了。 ...

谢谢!上次看的时候没有太仔细

回复 只看该作者 道具 举报

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

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

GMT+8, 2025-1-1 10:15 , Processed in 0.075284 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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