u01 File System Become Full Because of cvucheckreport and Bug fixed with Patch | Ahmet Melih Başbuğ Personal Blog Page!
In machines which installed Oracle Database 12c Single Instance and Oracle Database 12c RAC systems, The file -/u01/app/grid/crsdata/@global/cvu/baseline/cvures- could fill operating system's disk storage after a time. These are error logs that you should look after them first. In u01 file, you should make some free space that you can do it with manuel deleting files or apply PATCH. With Patches, you can solve this problems.
Location:
==========
/u01/app/grid/crsdata/@global/cvu/baseline/cvures
File Example:
=============
cvucheckreport_12354231231.xm cvucheckreport_12354316712.xml .... etc
Used Space
==========
[root@testnode cvures]# du -h
34G
Look at the example over the top. You see there is 34G using in u01 file system. First you should look include of these log files to search errors or warnings. After days, this file become full because of xml files. To purge disk, you can delete files that make free spaces. you can delete cvucheckreport.*.xml and cvucheckreport.*.txt files manually. If you want you can take them backup with ZIP command and after backup to zip, you can delete them. It will not affect to grid system. You can do this when your database is online. One example of deleting these files manuelly;
find . -name 'cvucheckreport*.xml' -mtime +300 -exec rm {} \;
find . -name 'cvucheckreport*.txt' -mtime +300 -exec rm {} \;
You can put this command to crontab and system delete automaticly. Oracle engineers said there will be not affect if you delete them manually. Oracle engineers prepared some patch for that problem. After, they produced PSU patched. First With Bug 18143707, txt files could be limited.Then with Bug 19703199, they worked for xml files of cvucheckreports. After some time they fix Bug 20177779. Look at the below, 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 nod
Çözüm
Bug 18143707 is fixed in 12.1.0.2
Bug 19703199 is fixed in 12.1.0.2.4 PSU
Bug 20177779 is fixed in 12.1.0.2.5 PSU
The workaround is to remove these reports manually. 12.1.0.2.GIPSU05
Error handled and fixed with 20177779. Read and install one of these patches to save your u01 file system from unneccessary xml and txt files. Thanks for read. Good bye. Feel free to write your comments
