cvucheckreport_*.xml 文件占用空间大

问题:
一套oracle 12.1.0.2 RAC生产数据库自创建时间以来，cvucheckreport_1127201922436.xml 文件不断累积却不删除，达到12GB。

原因:

‘ora.cvu’ 每6小时检查集群健康然后存储这些xml格式的健康报告到 $GI_HOME/cvu/baseline or $ORACLE_BASE/crsdata/@global/cvu/baseline 目录下。但是可能会由于遇到 bug 导致这些文件不自动删除，因此占用越来越大的空间。

解决方法:
1.按照下面的补丁要求打上补丁，或者打上最新的GI补丁。
Bug 18143707 is fixed in 12.1.0.2

Bug 19703199 is fixed in 12.1.0.2.4 GI PSU

Bug 20177779 is fixed in 12.1.0.2.5 GI PSU

Bug 22594310 is fixed in 12.1.0.2.161018 GI PSU

2.手工删除xml文件或定时任务自动删除XML文件。
cd $ORACLE_BASE/crsdata/@global/cvu/baseline/cvures
find ./ -name "cvucheckreport*.xml" -mtime +8 |xargs rm -f

参考文档:
reports from ora.cvu resource using excessive disk space (Doc ID 1964482.1) To BottomTo Bottom

In this Document
Symptoms
Cause
Solution
References

Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms

Cluster resource ‘ora.cvu’ invokes clusterware health check every 6 hours and stores these reports under ‘$G{I}_{H}OME/cvu/baselin{e}^{\prime }o{r}^{\prime }$ORACLE_BASE/crsdata/@global/cvu/baseline’, the reports take large amount of space as it’s not being purged, i.e.

$ ls -l

-rw-r–r-- 1 grid oinstall 38282928 Oct 31 15:24 cvucheckreport_10312014151648.xml
-rw-r–r-- 1 grid oinstall 38282929 Oct 31 21:24 cvucheckreport_10312014211643.xml
-rw-r–r-- 1 grid oinstall 38303700 Oct 31 09:28 cvucheckreport_1031201491715.xml

…

Cause

The issue has been addressed by the following fix:

Unpublished Bug 18143707 CVU NEED TO DO CVU BASELINE REPORT CLEAN TO AVOID DISK FULL will limit .txt files to 5

Unpublished Bug 19703199 CVU NEED TO DO CVU BASELINE REPORT CLEAN TO AVOID DISK FULL will limit .xml files to 5

Unpublished Bug 20177779 BIGBH U01 SPACE CONSUMPTION BY CVUCHECKREPORT.XML will purge the files on remote nodes

BUG 22594310 - CVU HEALTH CHECK REPORTS NOT PURGED

Solution

Bug 18143707 is fixed in 12.1.0.2

Bug 19703199 is fixed in 12.1.0.2.4 GI PSU

Bug 20177779 is fixed in 12.1.0.2.5 GI PSU

Bug 22594310 is fixed in 12.1.0.2.161018 GI PSU

The workaround is to remove these reports manually.