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

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

26

积分

0

好友

1

主题
1#
发表于 2012-3-26 16:11:14 | 查看: 6454| 回复: 4
  1. dc-rac2:oracle$ crsctl query css votedisk
  2. 0.     0    RAC
  3. 1.     0    /dev/rdsk/c5t60060E8005BEA5000000BEA500000027d0s6
  4. 2.     0    /dev/rdsk/c5t60060E8005BEA5000000BEA500000028d0s6
  5. 3.     0    /dev/rdsk/c5t60060E8005BEA5000000BEA500000029d0s6

  6. located 4 votedisk(s).
  7. dc-rac2:oracle$
复制代码

  1. 2012-03-26 15:14:58.515
  2. [cssd(8798)]CRS-1605:CSSD voting file is online: /dev/rdsk/c5t60060E8005BEA5000000BEA500000028d0s6. Details in /oracle/product/10g/crs/log/dc-rac2/cssd/ocssd.log.
  3. 2012-03-26 15:14:58.515
  4. [cssd(8798)]CRS-1605:CSSD voting file is online: /dev/rdsk/c5t60060E8005BEA5000000BEA500000027d0s6. Details in /oracle/product/10g/crs/log/dc-rac2/cssd/ocssd.log.
  5. 2012-03-26 15:14:58.535
  6. [cssd(8798)]CRS-1605:CSSD voting file is online: /dev/rdsk/c5t60060E8005BEA5000000BEA500000029d0s6. Details in /oracle/product/10g/crs/log/dc-rac2/cssd/ocssd.log.
复制代码

  1. dc-rac2:oracle$ crsctl check crs
  2. CSS appears healthy
  3. CRS appears healthy
  4. EVM appears healthy
  5. dc-rac2:oracle$
复制代码

  1. dc-rac2:oracle$ ocrcheck        
  2. Status of Oracle Cluster Registry is as follows :
  3.          Version                  :          2
  4.          Total space (kbytes)     :    1048764
  5.          Used space (kbytes)      :       3844
  6.          Available space (kbytes) :    1044920
  7.          ID                       : 1649452169
  8.          Device/File Name         : /dev/rdsk/c5t60060E8005BEA5000000BEA500000025d0s6
  9.                                     Device/File integrity check succeeded
  10.          Device/File Name         : /dev/rdsk/c5t60060E8005BEA5000000BEA500000026d0s6
  11.                                     Device/File integrity check succeeded

  12.          Cluster registry integrity check succeeded

  13. dc-rac2:oracle$
复制代码



告警日志中一直出现
  1. dc-rac2:oracle$ tail -f /oracle/product/10g/crs/log/dc-rac2/alertdc-rac2.log
  2. 2012-03-26 16:09:49.224
  3. [cssd(1547)]CRS-1604:CSSD voting file is offline: RAC. Details in /oracle/product/10g/crs/log/dc-rac2/cssd/ocssd.log.
  4. 2012-03-26 16:09:58.234
  5. [cssd(1547)]CRS-1604:CSSD voting file is offline: RAC. Details in /oracle/product/10g/crs/log/dc-rac2/cssd/ocssd.log.
  6. 2012-03-26 16:10:07.237
  7. [cssd(1547)]CRS-1604:CSSD voting file is offline: RAC. Details in /oracle/product/10g/crs/log/dc-rac2/cssd/ocssd.log.
  8. 2012-03-26 16:10:16.247
  9. [cssd(1547)]CRS-1604:CSSD voting file is offline: RAC. Details in /oracle/product/10g/crs/log/dc-rac2/cssd/ocssd.log.
  10. 2012-03-26 16:10:25.250
  11. [cssd(1547)]CRS-1604:CSSD voting file is offline: RAC. Details in /oracle/product/10g/crs/log/dc-rac2/cssd/ocssd.log.
复制代码



检查起来似乎都很正常,如何解决这个问题?求助。
5#
发表于 2012-3-26 16:52:50
感谢 上海-自由职业 的帮助
问题原因已找到


dc-rac2:oracle$ crsctl query css votedisk
0.     0    RAC
1.     0    /dev/rdsk/c5t60060E8005BEA5000000BEA500000027d0s6
2.     0    /dev/rdsk/c5t60060E8005BEA5000000BEA500000028d0s6
3.     0    /dev/rdsk/c5t60060E8005BEA5000000BEA500000029d0s6

located 4 votedisk(s).
dc-rac2:oracle$

中的 0.     0    RAC 似乎是个无效的。
删除即可

回复 只看该作者 道具 举报

4#
发表于 2012-3-26 16:49:25
OS LOG 上传下

回复 只看该作者 道具 举报

3#
发表于 2012-3-26 16:20:12
/oracle/product/10g/crs/log/dc-rac2/cssd/ocssd.log

session.zip

101.19 KB, 下载次数: 1001

回复 只看该作者 道具 举报

2#
发表于 2012-3-26 16:13:19
/oracle/product/10g/crs/log/dc-rac2/cssd/ocssd.log文件,传个上来。

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-11-15 12:46 , Processed in 0.054829 second(s), 25 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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