Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Housekeeping of GIMR/ASM instance sys-audit files

Peter_L_Nov 4 2019

Since RAC 12.1 there is an additionally GIMR (Grid Infrastruktur Managament Repository) installed.

This DB is designed to be self-managed without DBA attention.

But it seems that sys-auditfiles were not be purged in regular manner. Over two years the audit files occupies 6GB in the grid base (/u01/app/grid/admin/_mgmtdb/adump).

The only way to housekeeping that is to remove old audit files with "find /u01/app/grid/admin/_mgmtdb/adump -name "*.aud" -type f -mtime +20 -exec rm {} \;".

This method is valid for ASM audit files, too. See here: "Manage Audit File Directory Growth with cron (Doc ID 1298957.1)".

It would be nice and this is my idea that purging of sys-audit files of GIMR and ASM instances are performed automatically and without DBA/OS Admin intervention.

Comments
Post Details
Added on Nov 4 2019
2 comments
2,211 views