Friday, May 27, 2011

Purging files older than 5 days using mtime in linux

oracle@servername:dbname> cat /fisc/oracle/purge/purgescript_1.ksh
#!/bin/ksh
echo 'SIZE BEFORE dbname TRACE PURGE' > /fisc/oracle/purge/purgetrace_1.log

ls -l /fisc/dba/traces/dbname_ap01_11336.trm >> /fisc/oracle/purge/purgetrace_1.log

df -h /fisc/dba/traces >> /fisc/oracle/purge/purgetrace_1.log

echo 'NUMBER OF FILES BEFORE dbname TRACE PURGE' >> /fisc/oracle/purge/purgetrace_1.log
ls -1R /fisc/dba/traces | wc -l >> /fisc/oracle/purge/purgetrace_1.log


export ORACLE_HOME=/ercprtp1/oracle/product/11.2.0.2
export ORACLE_SID=dbname
echo $ORACLE_HOME
echo $ORACLE_SID


cat /dev/null > /fisc/dba/traces/dbname_ap01_11336.trm

find /fisc/dba/traces/*.trm -mtime +5 -exec rm {} \;

find /fisc/dba/traces/*.trc -mtime +5 -exec rm {} \;

echo 'SIZE AFTER dbname TRACE PURGE' >> /fisc/oracle/purge/purgetrace_1.log

ls -l /fisc/dba/traces/dbname_ap01_11336.trm >> /fisc/oracle/purge/purgetrace_1.log

df -h /fisc/dba/traces >> /fisc/oracle/purge/purgetrace_1.log


echo 'NUMBER OF FILES AFTER dbname TRACE PURGE' >> /fisc/oracle/purge/purgetrace_1.log
ls -1R /fisc/dba/traces | wc -l >> /fisc/oracle/purge/purgetrace_1.log

cat /fisc/oracle/purge/purgetrace_1.log | mailx -s "dbname Trace Purge Job output" Mail-dl@fmr.com
#cat /fisc/oracle/purge/purgetrace_1.log | mailx -s "dbname Trace Purge Job output" corpid@fmr.com


*****************

chmod 777 purgescript_1.ksh

to run the .ksh

ksh -x purgescript_1.ksh



Scheduled Crontab:
00 22 * * * /fisc/oracle/purge/purgescript_1.ksh > /fisc/oracle/logs/Cron/purgescript_1.log 2>&1

******************

No comments: