Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

*.aud file

647528Feb 19 2012 — edited Feb 19 2012
Hi - I have not enabled the audit trail on the database(11.2.0.1.0) still I see audit files generated in adump. is there any procedure to clean up the *.aud automatically with out scheduling the cron job as oracle. I was able to find procedure to clean up audit tables in database but not able to find one for adump *.aud files
I have to retain the *.aud files for 365 days and delete it after. I can write a script but looking for a way that oracle can do it by itself.

Ouput

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter audit

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /u01/app/oracle/admin/prod/adu
mp
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string DB
SQL> exit




-r----- 1 oracle oinstall 810 Feb 19 15:55 prod_ora_22170_e.aud
-rw-r----- 1 oracle oinstall 811 Feb 19 15:55 prod_ora_22161_15.aud
-rw-r----- 1 oracle oinstall 816 Feb 19 15:55 prod_ora_22150_10.aud
-rw-r----- 1 oracle oinstall 820 Feb 19 15:55 prod_ora_20341_16.aud
-rw-r----- 1 oracle oinstall 756 Feb 19 16:02 prod_ora_25025_d.aud

Thanks in advance.
This post has been answered by mseberg on Feb 19 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2012
Added on Feb 19 2012
4 comments
25,051 views