Oracle RAC １１２０４ CHM(cluster healthy ｍｏｎｉｔｏｒ） 文件无限膨胀．

ＣＨＭ　存储数据的文件，　已经没有节制的膨胀了．　

大ｂｕｇ　．　

解决方案：　

参考：　http://blog.itpub.net/28697282/viewspace-1579187/　

Affects:

Product (Component)	Oracle Server (PCW)
Range of versions believed to be affected	Versions BELOW 12.2
Versions confirmed as being affected	11.2.0.4
Platforms affected	Generic (all / most platforms affected)

Fixed:

The fix for 20186278 is first included in

12.2 (Future Release)

Description

BDB retension time suddenly change to 1094795585 or some other huge value.
This may cause crfclust.bdb file to grow in size, as crflogd tries to keep 
data for longer retention. 

Rediscovery Notes  

When hitting this problem, crflogd.log may show the retention size being 
suddenly updated to a large size. 
 
 ------------------------------------------------------------------
 2014-02-03 15:36:29.799: [ CRFLOGD][2363541248]updateDBRetention: new retention is 1094795585 seconds and 4702111234474983745 bytes
 ------------------------------------------------------------------
 
Current retention value may be checked with following command. 
If the retention value (unit: seconds) shows a large value like 
1094795585, you are likely to have hit this problem.
 
 $ oclumon manage -get repsize
 CHM Repository Size = 1094795585

Workaround  

Modify BDBSIZE parameter in config file crf.ora to 
adequately lower value. To do so, follow these steps:
 
1. Issue "$GI_HOME/bin/crsctl stop res ora.crf -init " on all the nodes of cluster.
2. Locate the config file $GRID_HOME/crf/admin/crf.ora
3. Manually edit the crf.ora file on every node of the cluster and
   change BDBSIZE tag entry and remove the value (set it to blank) or 
   set it to a desired value, eg. 61511. Do not delete the BDBSIZE tag itself.
4. Restart ora.crf daemon on every node.

解决方法

        该bug在12.2版本修复，变通的解决方法
        1.  在集群中的所有节点执行 “GI_HOME/bin/crsctl stop res ora.crf -init "  
        2.  跳转到 $GRID_HOME/crs/admin/crf.ora所在目录下
        3.  在集群中的所有节点手工编辑crf.ora文件，修改BDBSIZE所在行，移除其所设定的值（设置它为空）
            或者 将它的值设定为期望值，例如61511。不要删除BDBSIZE。
        4. 在集群中的每个节点重启ora.crf.

＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃３３
两个节点都执行．　

crsctl stat res ora.crf -init -t
crsctl stop res ora.crf -init
cd /data/grid/11gr2/crf/db/rac-product1
rm -f *.bdb
crsctl start res ora.crf -init

＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃

关于ｏｒａｃｌｅ　ＣＨＭ　（　ＣＬＵＳＴＥＲ　　ＨＥＡＬＴＨＹ　ＭＯＮＩＴＯＲ　）　参考：　

请参考Oracle官方文档：
  http://docs.oracle.com/cd/E11882_01/rac.112/e16794/troubleshoot.htm#CWADD92242
  Oracle? Clusterware Administration and Deployment Guide
  11g Release 2 (11.2)
  Part Number E16794-17

  或者 My Oracle Support文档：
  Cluster Health Monitor (CHM) FAQ (Doc ID 1328466.1)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/133735/viewspace-2139836/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/133735/viewspace-2139836/