Huge CRF File Size Oracle RAC Environment

Environment

• Oracle Linux (6.x or 7.x)
• Oracle 11g (RAC or STANDALONE)

 

Symptoms

• Oracle GRID_HOME size is huge
• $GRID_HOME/crf/ folder size is huge

For each node:

[oracle@rachost1 ~]$ ls -lah $GRID_HOME/crf/db/rachost1
toplam 105G
drwxr-x--- 2 root oinstall 4,0K Tem 18 21:55 .
drwxr-x--- 3 root oinstall 4,0K Şub 14  2016 ..
-rw-r--r-- 1 root root     2,2M Tem  4  2018 04-JUL-2018-15:04:11.txt
-rw-r--r-- 1 root root     1,4M Tem  4  2018 04-JUL-2018-15:05:43.txt
-rw-r--r-- 1 root root     2,2M Tem  4  2018 04-JUL-2018-16:04:54.txt
-rw-r--r-- 1 root root     1,3M Tem  4  2018 04-JUL-2018-16:06:44.txt
-rw-r--r-- 1 root root     789K May 11  2017 11-MAY-2017-07:54:00.txt
-rw-r--r-- 1 root root     1,2M May 11  2017 11-MAY-2017-07:56:22.txt
-rw-r--r-- 1 root root     1,2M Şub 14  2016 14-FEB-2016-01:29:07.txt
-rw-r--r-- 1 root root     2,1M Şub 14  2016 14-FEB-2016-06:03:07.txt
-rw-r--r-- 1 root root     1,6M Şub 14  2016 14-FEB-2016-06:06:05.txt
-rw-r--r-- 1 root root     119K May 15  2017 15-MAY-2017-12:05:45.txt
-rw-r--r-- 1 root root     1,5M May 21  2018 21-MAY-2018-09:04:54.txt
-rw-r----- 1 root root     1,8G Tem 18 21:56 crfalert.bdb
-rw-r----- 1 root root      96G Tem 18 21:55 crfclust.bdb
-rw-r----- 1 root root     8,0K Tem  4  2018 crfconn.bdb
-rw-r----- 1 root root     1,8G Tem 18 21:56 crfcpu.bdb
-rw-r----- 1 root root     1,8G Tem 18 21:56 crfhosts.bdb
-rw-r----- 1 root root     2,2G Tem 18 21:55 crfloclts.bdb
-rw-r----- 1 root root     1,5G Tem 18 21:55 crfts.bdb
-rw-r----- 1 root root      24K Tem 17 06:43 __db.001
-rw-r----- 1 root root     392K Tem 18 21:56 __db.002
-rw-r----- 1 root root     2,6M Tem 18 21:56 __db.003
-rw-r----- 1 root root     2,1M Tem 18 21:56 __db.004
-rw-r----- 1 root root     1,2M Tem 18 21:56 __db.005
-rw-r----- 1 root root      56K Tem 18 21:56 __db.006
-rw-r----- 1 root root      16M Tem 18 21:55 log.0000043030
-rw-r----- 1 root root      16M Tem 18 21:56 log.0000043031
-rw-r--r-- 1 root root     115M Tem 17 06:43 rachost1.ldb
-rw-r----- 1 root root     8,0K Tem 18 21:55 repdhosts.bdb

 

 

Diagnose

For each node stop crf service:

 

>crsctl stop res ora.crf -init

 

For each node edit crf.ora file

 

> vi $GRID_HOME/crf/admin/crf.ora

#old value. unit: seconds

BDBSIZE=1094795585

#new value: approx 1 year
BDBSIZE=31536000 

For each node: Delete *.bdb files:

> cd $GRID_HOME/crf/db/
> rm -rf *.bdb

For each node start crf again

>crsctl start res ora.crf -init

 

Related:

Bug 20186278 - crfclust.bdb Becomes Huge Size Due to Sudden Retention Change (Doc ID 20186278.8)