>>Script Language and Platform: Oracle
A commonly occuring error is the archiver error that occurs due to the archive dump destination being full. Another error is inability to write info in an audit file, which causes the user session to terminate. All of these problems are common for a DBA. Hence, the only way out is to have a script in place that monitors these destinations for lack of space. This script effectively does this by removing all of these files that are 120 days old.
WARNING!! THIS SCRIPT SHOULD ONLY BE RUN AS AN ORACLE USER......

Author: BHABANI SHANKAR MAHARANA OCP DBA 9i,OCP DBA 10g

#*************************************************************************************************************

#orahousekeeping.ksh

#Script Name: orahousekeeping.ksh

#Author:Bhabani S Maharana

#Date: 23-May-2006

#Version:1.0

#Info:This script removes all the audit,trace and archive files of Oracle 

#that are more than 120 days old.

# The timespan of the files can be changed by altering the value 120 in the script 

#to suit specific needs.

#**************************************************************************************************************

clear

sleep 2

tput cup 19 30

echo "WARNING!....This script should only be run as a ORACLE USER or ROOT:\c"

tput cup 20 30

echo "Do you want to run the Script(y/n):\c"

read ans

if [ "$ans" = "y" ];then

sleep 2

tput cup 22 30

echo "REMOVING OLD FILE LIST'S AND SCRIPTS"

rm -f removeaudit.ksh

rm -f removetrace.ksh

rm -f removearchive.ksh

rm -f audit.lst

rm -f trace.lst

rm -f archive.lst

tput cup 24 30

echo "FINDING ALL THE TRACE FILES,AUDIT FILES and ARCHIVE FILES 120 DAYS OLD" 

sleep 2

tput cup 26 30

echo "PREPARING PRIMARY LIST's"

find /u01/app/oracle/admin -name \*.aud -mtime +120 >audit.lst 

find /u01/app/oracle/admin -name \*.trc -mtime +120 >trace.lst

find /genius/orarch01 -name \*.arc -mtime +120 >archive.lst

sleep 2

tput cup 28 30

echo "EDITING PRIMARY LIST's"

cat audit.lst|sed 's/^/rm -f /g'>removeaudit.ksh 

cat trace.lst|sed 's/^/rm -f /g'>removetrace.ksh

cat archive.lst|sed 's/^/rm -f /g'>removearchive.ksh

tput cup 30 30

echo "ORACLE HOUSEKEEPING SCRIPTS PREPARED....."

echo " OLD ORACLE FILES REMOVAL STARTED:\c"

ksh removearchive.ksh

ksh removeaudit.ksh

ksh removetrace.ksh

echo "FILES REMOVED:\c"

fi

Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All information on these pages is provided "as -is", without any warranty, whether express or implied, of its accuracy, completeness, or fitness for a particular purpose... Disclaimer Continued

Back to Database Journal Home