oracle database - Unified Audit policies didn't write to xml files - Stack Overflow

admin管理员组

文章数量:1123106

I'm running a 19c Oracle SE2 database under Win2019 Server with active audit policies. Database is running in mixed mode so I don't change it to only use unified audit.

SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Unified Auditing';

VALUE                                                           
----------------------------------------------------------------
FALSE

My parameters are these

show parameter audit;

NAME                         TYPE    VALUE              
---------------------------- ------- ------------------ 
audit_file_dest              string  E:\ORACLE\AUDITING 
audit_sys_operations         boolean TRUE               
audit_trail                  string  XML, EXTENDED      
unified_audit_sga_queue_size integer 1048576            
unified_audit_systemlog      boolean FALSE

Now I'm auditing all dml statements on schema called HK with self created policy I called "changes_on_hk". "HK" is my main application schema.

Policy is working fine because I had entries in unified_audit_trail before I switched auditing into xml files

select count(1) from unified_audit_trail where UNIFIED_AUDIT_POLICIES='CHANGES_ON_HK';

COUNT(1)
-----------
20978066   

After changing audit_trail to "XML, EXTENDED" I was in hope that the audit entries for my policy also be written into xml files. So I looked all my files, but the files only have sys audit stuff.

So unified auditing can only write into database?

本文标签： oracle databaseUnified Audit policies didn39t write to xml filesStack Overflow