MANAGING UNIFIED_AUDIT_TRAIL

Archiving the Unified and Traditional Database Audit Trails

You should periodically archive and then purge the audit trail to prevent it from growing too large.

Archiving and purging both frees audit trail space and facilitates the purging of the database audit trail.

You can create an archive of the unified and traditional database audit trail by using Oracle Audit Vault and Database Firewall. You install Oracle Audit Vault and Database Firewall separately from Oracle Database.

After you complete the archive, you can purge the database audit trail contents.

• To archive the unified, traditional standard, and traditional fine-grained audit records, copy the relevant records to a normal database table.

  For example:

  INSERT INTO table SELECT ... FROM UNIFIED_AUDIT_TRAIL ...;
  INSERT INTO table SELECT ... FROM SYS.AUD$ ...;
  INSERT INTO table SELECT ... FROM SYS.FGA_LOG$ ...;