Oracle database Unified Audit Trail was introduced in Oracle 12cR1 , as a mechanism to unify different oracle database audits (based on different features) under one view. As you may know “mixed mode” auditing is enabled by default starting with 12cR1 release. One of the limitations when switching from “standard auditing” to “unified auditing” in both Oracle 12cR1 and 12cR2 is you can’t push audits to syslog anymore. This has changed in Oracle 18c, you can push audits to SYSLOG in Unix/Linux OS and to windows event log.
A new init parameter has been introduced “unified_audit_systemlog”
In window OS I have set the parameter as TRUE as shown below:
For simulation through RMAN I have executed command to take controlfile backup then check the windows event log:
Another new feature in 18c , is the ability to export and import unified audit trail !
Command to export:
expdp system/XXXXXXXX full=y directory=DUMP_DIR logfile=exp_unified18c_log.log dumpfile=exp_unified18c.dmp INCLUDE=AUDIT_TRAILS
3 thoughts on “Unified Auditing in Oracle 18c”
very interesting, thanks !
interesting improvement in Oracle 18c
Interesting enhancements in 18c !!