*.aud file
647528Feb 19 2012 — edited Feb 19 2012Hi - 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.