Database Administration (MOSC)

MOSC Banner

DBMS_AUDIT_MGMT setup does not purge the aud$ table

edited May 14, 2018 11:43AM in Database Administration (MOSC) 5 commentsAnswered

Good afternoon,

I am having an issue where an audit purge job is currently running each hour however does not seem to be working for audit records that are prior to the last archive timestamp.  I've searched around and found issues with different DBID's causing problems however the DBID of the audit records match the DBID of the instance.

My version is Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production running AIX6

I have added the config as shown below.

SELECT PARAMETER_NAME, PARAMETER_VALUE, AUDIT_TRAIL FROM DBA_AUDIT_MGMT_CONFIG_PARAMS WHERE PARAMETER_NAME LIKE '%INTERVAL%';PARAMETER_NAME                                                                  --------------------------------------------------------------------------------PARAMETER_VALUE                                                                 --------------------------------------------------------------------------------AUDIT_TRAIL                 ----------------------------DEFAULT CLEAN UP INTERVAL                                                       240                                                                             STANDARD AUDIT TRAIL                                                                                        DEFAULT CLEAN UP INTERVAL                                                       240                                                                             FGA AUDIT TRAIL                                                                                             DEFAULT CLEAN UP INTERVAL                                                       240                                                                             OS AUDIT TRAIL                                                                                              DEFAULT CLEAN UP INTERVAL                                                       240                                                                             XML AUDIT TRAIL                                                                                             4 rows selected.SELECT * FROM dba_audit_mgmt_last_arch_ts;AUDIT_TRAIL          RAC_INSTANCE LAST_ARCHIVE_TS                   -------------------- ------------ ----------------------------------STANDARD AUDIT TRAIL            0 10/05/2018 00:00:00.000000 +00:00 FGA AUDIT TRAIL                 0 10/05/2018 00:00:00.000000 +00:00 OS AUDIT TRAIL                  1 10/05/2018 00:00:00.000000 +01:00 XML AUDIT TRAIL                 1 10/05/2018 00:00:00.000000 +01:00 4 rows selected.select min(ntimestamp#) from sys.aud$MIN(NTIMESTAMP#)                                  --------------------------------------------------09/05/2018 14:01:32.130633                        1 row selected.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center