重庆思庄Oracle、Redhat认证学习论坛

标题: oracle 11g RAC crfclust.bdb过大的处理办法 [打印本页]

作者: jiawang 时间: 2020-9-18 11:20
标题: oracle 11g RAC crfclust.bdb过大的处理办法
本帖最后由 jiawang 于 2020-9-18 11:21 编辑

ora.crf资源主要是用来收集信息的,而且在11.2.0.2之后才有,
由于 ora.crf服务生成的文件crf*.bdb,$HOSTNAME.ldb会很大，这样就对$GRID_HOME的使用率造成了压力。

解决方法

查看ora.crf服务——>停止ora.crf服务—-> 删除crfclust.bdb —->启动ora.crf —->再次检查crf.ora是否正常

[root@rac01 rac01]# ll
total 32627372
-rw-r----- 1 root root 616648704 Sep 18 08:34 crfalert.bdb
-rw-r----- 1 root root 30426595328 Sep 18 08:34 crfclust.bdb
-rw-r----- 1 root root       8192 May 11 15:41 crfconn.bdb
-rw-r----- 1 root root 596418560 Sep 18 08:34 crfcpu.bdb
-rw-r----- 1 root root 552554496 Sep 18 08:34 crfhosts.bdb
-rw-r----- 1 root root 717410304 Sep 18 08:34 crfloclts.bdb
-rw-r----- 1 root root 466325504 Sep 18 08:34 crfts.bdb
-rw-r----- 1 root root    24576 May 11 15:39 __db.001
-rw-r----- 1 root root    401408 Sep 18 08:34 __db.002
-rw-r----- 1 root root    2629632 Sep 18 08:34 __db.003
-rw-r----- 1 root root    2162688 Sep 18 08:34 __db.004
-rw-r----- 1 root root    1187840 Sep 18 08:34 __db.005
-rw-r----- 1 root root    57344 Sep 18 08:34 __db.006
-rw-r--r-- 1 root root 120000000 May 11 15:40 rac01.ldb
-rw-r----- 1 root root 16777216 Sep 18 07:58 log.0000009450
-rw-r----- 1 root root 16777216 Sep 18 08:34 log.0000009451
-rw-r----- 1 root root       8192 May 11 15:39 repdhosts.bdb
[root@rac01 rac01]# pwd
/u01/11.2.0.3/grid/crf/db/rac01
[root@dmsrac03 dmsrac03]# df -h
Filesystem    Size  Used Avail Use% Mounted on
/dev/vda3       82G 54G 24G  70% /
tmpfs          40G  308M 40G 1% /dev/shm
/dev/vda1    190M 33M  147M  19% /boot
/dev/vdb1    493G 87M  467G 1% /oracledata

查看ora.crf服务
grid@rac01 bin]$ ./crsctl stat res ora.crf -init -t
--------------------------------------------------------------------------------
NAME          TARGET  STATE       SERVER                STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.crf
   1       ONLINE  ONLINE    rac01
[grid@dmsrac03 bin]$ pwd
/u01/11.2.0.3/grid/bin

停止ora.crf服务
[root@rac01 rac01]# /u01/11.2.0.3/grid/bin/crsctl stop res ora.crf -init
CRS-2673: Attempting to stop 'ora.crf' on 'rac01'
CRS-2677: Stop of 'ora.crf' on 'rac01' succeeded

删除crf*.bdb文件
[root@rac01 ]# cd /u01/11.2.0.3/grid/crf/db/rac01
[root@rac01 ]# ll
total 32647672
-rw-r----- 1 root root 617050112 Sep 18 10:16 crfalert.bdb
-rw-r----- 1 root root 30443110400 Sep 18 10:16 crfclust.bdb
-rw-r----- 1 root root       8192 May 11 15:41 crfconn.bdb
-rw-r----- 1 root root 596684800 Sep 18 10:16 crfcpu.bdb
-rw-r----- 1 root root 552730624 Sep 18 10:16 crfhosts.bdb
-rw-r----- 1 root root 717807616 Sep 18 10:16 crfloclts.bdb
-rw-r----- 1 root root 466587648 Sep 18 10:16 crfts.bdb
-rw-r----- 1 root root    24576 May 11 15:39 __db.001
-rw-r----- 1 root root    401408 Sep 18 10:16 __db.002
-rw-r----- 1 root root    2629632 Sep 18 10:16 __db.003
-rw-r----- 1 root root    2162688 Sep 18 10:16 __db.004
-rw-r----- 1 root root    1187840 Sep 18 10:16 __db.005
-rw-r----- 1 root root    57344 Sep 18 10:16 __db.006
-rw-r--r-- 1 root root 120000000 May 11 15:40 rac01.ldb
-rw-r----- 1 root root 16777216 Sep 18 09:32 log.0000009452
-rw-r----- 1 root root 16777216 Sep 18 10:16 log.0000009453
-rw-r----- 1 root root       8192 May 11 15:39 repdhosts.bdb

[root@dmsrac03 dmsrac03]# rm *.bdb
rm: remove regular file `crfalert.bdb'? yes
rm: remove regular file `crfclust.bdb'? yes
rm: remove regular file `crfconn.bdb'? yes
rm: remove regular file `crfcpu.bdb'? yes
rm: remove regular file `crfhosts.bdb'? yes
rm: remove regular file `crfloclts.bdb'? yes
rm: remove regular file `crfts.bdb'? yes
rm: remove regular file `repdhosts.bdb'? yes

启动ora.crf服务
[root@rac01 rac01]# /u01/11.2.0.3/grid/bin/crsctl start res ora.crf -init
CRS-2672: Attempting to start 'ora.crf' on 'dmsrac03'
CRS-2676: Start of 'ora.crf' on 'dmsrac03' succeeded

验证crf.ora服务
[grid@rac01 bin]$ ./crsctl stat res ora.crf -init -t
--------------------------------------------------------------------------------
NAME          TARGET  STATE       SERVER                STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.crf
   1       ONLINE  ONLINE    dmsrac03

[root@rac01 ]# df -h
Filesystem    Size  Used Avail Use% Mounted on
/dev/vda3       82G 24G 55G  30% /
tmpfs          40G  308M 40G 1% /dev/shm
/dev/vda1    190M 33M  147M  19% /boot
/dev/vdb1    493G 87M  467G 1% /oracledata

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)