Shulou(Shulou.com)05/31 Report--

This article will explain in detail what to do about the high utilization of disk space caused by the huge space occupied by crfclust.bdb in the database. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Received the alarm log, indicating that the root (/) directory utilization of the database server was more than 85% and less than 95%, so I logged in to the database server to check the specific situation.

[root@jzfpysdb1] # df-h

Filesystem Size Used Avail Use% Mounted on

/ dev/sda3 158G 130G 21G 87% /

Tmpfs 63G 301m 63G 1% / dev/shm

/ dev/sda1 120m 33m 82m 29% / boot

As above, the root (/) directory utilization is 87%, and the directory files taking up space are tracked by du-sh *.

[root@jzfpysdb1 jzfpysdb1] # du-sh *

1.2m 05-JUN-2016-09:51:08.txt

1.2m 12-NOV-2016-00:37:23.txt

136k 12-NOV-2016-00:41:49.txt

4.0K 12-NOV-2016-00:43:07.txt

1.2m 12-NOV-2016-01:00:50.txt

1.3m 12-NOV-2016-08:07:49.txt

1.3m 12-NOV-2016-09:17:47.txt

868K 26-NOV-2015-21:56:26.txt

868K 26-NOV-2015-21:56:27.txt

1004K 26-NOV-2015-21:57:08.txt

1.2m 26-SEP-2016-15:26:08.txt

1.3G crfalert.bdb

91G crfclust.bdb

8.0K crfconn.bdb

1.4G crfcpu.bdb

1.3G crfhosts.bdb

1.7G crfloclts.bdb

1.3G crfts.bdb

12K _ _ db.001

392K _ _ db.002

2.6M _ _ db.003

2.1M _ _ db.004

904K _ _ db.005

12K _ _ db.006

520K jzfpysdb1.ldb

16M log.0000010978

14M log.0000010979

8.0K repdhosts.bdb

As tracked above, the size of the crfclust.bdb file is 91g, which is generated by the cluster service ora.crf. The solution process is as follows:

1. View the status of ora.crf service

[grid@jzfpysdb1] $crsctl stat res ora.crf-init-t

NAME TARGET STATE SERVER STATE_DETAILS

Cluster Resources

Ora.crf

1 ONLINE ONLINE jzfpysdb1

2. Stop the ora.crf service

[grid@jzfpysdb1 ~] $crsctl stop res ora.crf-init

CRS-2673: Attempting to stop 'ora.crf' on' jzfpysdb1'

CRS-2677: Stop of 'ora.crf' on' jzfpysdb1' succeeded

3. Clean up files of type .bad

[root@jzfpysdb1 jzfpysdb1] # rm. / * .bdb

Rm: remove regular file `. / crfalert.bdb'? Y

Rm: remove regular file `. / crfclust.bdb'? Y

Rm: remove regular file `. / crfconn.bdb'? Y

Rm: remove regular file `. / crfcpu.bdb'? Y

Rm: remove regular file `. / crfhosts.bdb'? Y

Rm: remove regular file `. / crfloclts.bdb'? Y

Rm: remove regular file `. / crfts.bdb'? Y

Rm: remove regular file `. / repdhosts.bdb'? Y

4. Determine whether the space has been released

[root@jzfpysdb1 jzfpysdb1] # df-h

Filesystem Size Used Avail Use% Mounted on

/ dev/sda3 158G 23G 128G 15% /

Tmpfs 63G 301m 63G 1% / dev/shm

/ dev/sda1 120m 33m 82m 29% / boot

[root@jzfpysdb1 jzfpysdb1] #

5. Start the ora.crf service and check its status

[grid@jzfpysdb1 ~] $crsctl start res ora.crf-init

CRS-2672: Attempting to start 'ora.crf' on' jzfpysdb1'

CRS-2676: Start of 'ora.crf' on' jzfpysdb1' succeeded

[grid@jzfpysdb1] $crsctl stat res ora.crf-init-t

NAME TARGET STATE SERVER STATE_DETAILS

Cluster Resources

Ora.crf

1 ONLINE ONLINE jzfpysdb1

[grid@jzfpysdb1 ~] $

This is the end of the article on "what to do with the high utilization of disk space caused by crfclust.bdb in the database". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.