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