Trace File Generated By Dbms_audit_mgmt.Clean_audit_trail (Doc ID 1094772.1)

Last updated on OCTOBER 13, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

With Oracle RDBMS 11.1.0.7.0, when using DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL, a trace file in user_dump_dest is created.

This issue can be reproduced at will with the following steps from sqlplus:

connect /as sysdba

Begin
SYS.DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP(audit_trail_type =>
SYS.DBMS_AUDIT_MGMT.AUDIT_TRAIL_OS,
             last_archive_time =>
TO_TIMESTAMP('13-APR-1014:10:10.0','DD-MON-RRHH24:MI:SS.FF'),RAC_INSTANCE_NUMBER=>1);
end;
/

begin
SYS.DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(
audit_trail_type => SYS.DBMS_AUDIT_MGMT.AUDIT_TRAIL_OS,
use_last_arch_timestamp =>true);
end;
/


You will see a trace file appearing in directory user_dump_dest looking like this:


Trace file /u01/app/oracle/diag/rdbms/v1110/v1110/trace/v1110_ora_28663.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning and Oracle Label Security options
ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1
System name: Linux
Node name: nlsupport03.nl.oracle.com
Release: 2.6.18-194.0.0.0.3.el5
Version: #1 SMP Mon Mar 29 18:14:09 EDT 2010
Machine: x86_64
Instance name: v1110
Redo thread mounted by this instance: 1
Oracle process number: 23
Unix process pid: 28663, image: oracle@nlsupport03.nl.oracle.com (TNS V1-V3)


*** 2010-06-15 14:48:04.753
*** SESSION ID:(93.3920) 2010-06-15 14:48:04.753
*** CLIENT ID:() 2010-06-15 14:48:04.753
*** SERVICE NAME:(SYS$USERS) 2010-06-15 14:48:04.753
*** MODULE NAME:(sqlplus@nlsupport03.nl.oracle.com (TNS V1-V3)) 2010-06-15 14:48:04.753
*** ACTION NAME:() 2010-06-15 14:48:04.753

kzam_osx_cleanup: Last Arch TS is 1271160610
Skipping file /u01/app/oracle/admin/v1110/adump/v1110_ora_11496_1.aud with TS 1273482077
Skipping file /u01/app/oracle/admin/v1110/adump/v1110_ora_11573_1.aud with TS 1273482101
Skipping file /u01/app/oracle/admin/v1110/adump/v1110_ora_11578_1.aud with TS 1273482104
<...>



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms