Skip to content

Unified Auditing

Cleanup Audit Trail – the Full Picture

Oracle Database 23ai introduces several enhancements to unified auditing, focused on flexibility, and effectiveness. Some of the new key features are: Desupport of Traditional Auditing: Traditional auditing is desupported in Oracle 23ai, which means all auditing must now be done using unified auditing. Unified auditing consolidates audit records into a single, secure trail and supports conditional policies for selective auditing.… 

From Oracle Standard Auditing to Oracle Unified Auditing

In this post, I will not show you all advantages related to Oracle Unified Auditing. For that, read the oracle documentation. You can also read the blogs written by my colleagues : Oracle 12c Unified Auditing Feature in a multitenant environment Oracle 12c – RMAN and Unified Auditing – Does it really work ? Purging Unified Audit Trail in 12cR2… 

Handling unified auditing spillover files on the standby-site

Switching to Oracle Unified Auditing may produce lots of data when e.g. auditing activities of the SYS-user. I.e. according the documentation you can do the following to audit similarly as in traditional auditing with audit_sys_operations=TRUE: SQL> CREATE AUDIT POLICY TOPLEVEL_ACTIONS ACTIONS ALL ONLY TOPLEVEL; SQL> AUDIT POLICY TOPLEVEL_ACTIONS BY SYS; REMARK1: You may check the Blog on traditional SYS-auditing here…