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
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 -initFor 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 -initRelated: