Mani's Blog

March 15, 2011

>How to cleanup trace, trm and audit files periodically

Filed under: Oracle — mani @ 10:34 pm
Tags: , , ,

>## Audit Cleanup
00 00 * * * /usr/bin/find /local/opt/oracle/product/11.1.0/db_1/rdbms/audit -name ora_\*.aud -mtime +2 -exec rm {} > /dev/null \; 2>&1

### Purge old tracefiles after 14 days.
###
20 00 * * * /usr/bin/find /local/opt/oracle/diag/rdbms/xnodb02b/XNODB02B1/trace -name \*.trc -mtime +14 -exec rm {} \; > /dev/null 2>&1
20 00 * * * /usr/bin/find /local/opt/oracle/diag/rdbms/xnodb02b/XNODB02B1/trace -name \*.trm -mtime +14 -exec rm {} \; > /dev/null 2>&1

Advertisements

1 Comment »

  1. Nice! very helpful

    Comment by monab — June 30, 2011 @ 6:46 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: