Sunday, 15 July 2012

oracle - Audit trail is not purged -



oracle - Audit trail is not purged -

i seek clean audit trail (my database version 11.2.0.3.0). run without errors, audit trail not purged.

here do:

1) cleanup inicialization

begin if not dbms_audit_mgmt.is_cleanup_initialized(dbms_audit_mgmt.audit_trail_aud_std) dbms_audit_mgmt.init_cleanup( audit_trail_type => dbms_audit_mgmt.audit_trail_aud_std, -- aud log default_cleanup_interval => 24 /* hours */); end if; end; /

2) setting timestamp

begin dbms_audit_mgmt.set_last_archive_timestamp( audit_trail_type => dbms_audit_mgmt.audit_trail_aud_std, last_archive_time => to_timestamp(sysdate - 400), rac_instance_number => null ); end; /

3) clean trail

begin dbms_audit_mgmt.clean_audit_trail( audit_trail_type => dbms_audit_mgmt.audit_trail_aud_std, use_last_arch_timestamp => true ); end; / commit;

and when compare min date of records in aud$ table should differ, value same before , after cleaning:

select min(ntimestamp#) aud$;

any ideas i'm doing wrong? pl/sql procedure completed after running dbms_audit_mgmt.clean_audit_trail, records not purged.

oracle plsql audit-trail

No comments:

Post a Comment