#
# -----------------------------------------------------------------------------
# File:         clean_file.sh
# Desc:         Cleans various directories of files
#
#-------------------------------------------------------------------------------
#
#!/usr/bin/csh

#run the environment variable profile
#. $HOME/.bash_profile
#PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin
#cd $PATH
RUNDATE=`date "+%d%m%y at %H:%M:%S"`
LOGFILE=/home/oracle/dbtest
echo  $ORACLE_HOME


#--------Clean up audits----------
find $ORACLE_HOME/rdbms/audit -name "ora_*.aud" -mtime +365 -exec echo Removing File: \\c \; -exec ls -l {} \; -exec rm -f {} \;

#-----Trim the listener logs to have 365 days log history-----------.
cd $ORACLE_HOME/network/log
export THE_DATE=$(date +"%m_%d_%Y")
mv listener.log listener$THE_DATE.log
touch $ORACLE_HOME/network/log/listener.log
chmod 644 $ORACLE_HOME/network/log/listener.log
find $ORACLE_HOME/network/log/listener* -mtime +365 -exec rm {} \;

#-------Trim the alert log to have 365days log history-------------.
LDATE=`date '+%Y-%m-%d-%H:%M'`
#cd $ORACLE_HOME/admin/SID/bdump
find /opt/oracle/product/10.2.0/admin -name "alert_*" | xargs mv 
touch alert_$ORACLE_SID.log
chmod 0640 alert_$ORACLE_SID.log
find /opt/oracle/product/10.2.0/admin -name "alert_*" -mtime +365 -exec echo Removing File: \\c \; -exec ls -l {} \; -exec rm -f {} \;


#-----------------------Clean trc and dump file in udump,cdump & bdump----------------

df -h >$LOGFILE/before_purged_size.log
find /opt/oracle/product/10.2.0/admin -name \*.trc -mtime +365 -exec echo Removing File: \\c \; -exec ls -l {} \; -exec rm -f {} \; 

du -h > $LOGFILE/after_purged_size.log
cat $LOGFILE/after_purged_size.log $LOGFILE/before_purged_size.log >> $LOGFILE/mail.log
mail -s "Status of $ORACLE_SID Old trace file successfully purging on $RUNDATE " abc@xyz.com < $LOGFILE/mail.log
exit;