Wednesday, October 31, 2007

shell script to clean the oracle dump directories

find . -name \*.log -mtime +1 -exec ls {} \;
find . -name \*.log -mtime +1 -exec rm {} \;

#!/usr/bin/ksh
#

PATH=${PATH}:/usr/local/bin

# Check Syntax
if [ $# -ne 2 ]
then
echo "Syntax Error: clean_dumps.sh ."
exit 1
else
DAYS=$2
fi

. /var/opt/oracle/test10g.env

# Redirect output to log
exec 1>${ORACLE_DBA}/${ORACLE_SID}_clean_dumps.`date +%w` 2>&1

echo "Start: `date`"

find ${ORACLE_DBA}/${ORACLE_SID}/udump -name "*.trc" -mtime +${DAYS} -exec ls -l {} \;
find ${ORACLE_DBA}/${ORACLE_SID}/udump -name "*.trc" -mtime +${DAYS} -exec rm -f {} \;

find ${ORACLE_DBA}/${ORACLE_SID}/bdump -name "*.trc" -mtime +${DAYS} -exec ls -l {} \;
find ${ORACLE_DBA}/${ORACLE_SID}/bdump -name "*.trc" -mtime +${DAYS} -exec rm -f {} \;

find ${ORACLE_DBA}/${ORACLE_SID}/cdump -name "core_*" -mtime +${DAYS} -exec ls -l {} \;
find ${ORACLE_DBA}/${ORACLE_SID}/cdump -name "core_*" -mtime +${DAYS} -exec rm -f -r {} \;


echo "\nEnd: `date`"

No comments: