Forum Stats

  • 3,824,937 Users
  • 2,260,441 Discussions
  • 7,896,354 Comments

Discussions

Housekeeping of GIMR/ASM instance sys-audit files

Peter_L_
Peter_L_ Member Posts: 135 Bronze Badge
edited Nov 4, 2019 8:59AM in Database Ideas - Ideas

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.

Peter_L_3363720Sven_SSven W.Joerg.SobottkaSureshMuddaveerappaFranckPberx
8 votes

Active · Last Updated

Comments