Tuesday, May 31, 2011

Purging files using adric utility

#!/bin/ksh
echo 'SIZE BEFORE DBNAME TRACE PURGE' > /fisc/oracle/purge/purgetrace.log
ls -l /vah/oracle/admin/DBNAME/udump/DBNAME_ora_29248.trm >> /fisc/oracle/purge/purgetrace.log
ls -l /vah/oracle/admin/DBNAME/udump/DBNAME_ora_29248.trc >> /fisc/oracle/purge/purgetrace.log
ls -l /vah/oracle/admin/DBNAME/udump/DBNAME_ora_17709.trm >> /fisc/oracle/purge/purgetrace.log
ls -l /vah/oracle/admin/DBNAME/udump/DBNAME_ora_17709.trc >> /fisc/oracle/purge/purgetrace.log

df -h /vah/oracle >> /fisc/oracle/purge/purgetrace.log

echo 'NUMBER OF FILES BEFORE DBNAME TRACE PURGE' >> /fisc/oracle/purge/purgetrace.log
ls -1R /vah/oracle/admin/DBNAME/udump | wc -l >> /fisc/oracle/purge/purgetrace.log


export ORACLE_HOME=/vah/oracle/product/11.2.0.2
export ORACLE_SID=DBNAME
echo $ORACLE_HOME
echo $ORACLE_SID

cat /dev/null > /vah/oracle/admin/DBNAME/udump/DBNAME_ora_29248.trm
cat /dev/null > /vah/oracle/admin/DBNAME/udump/DBNAME_ora_29248.trc
cat /dev/null > /vah/oracle/admin/DBNAME/udump/DBNAME_ora_17709.trm
cat /dev/null > /vah/oracle/admin/DBNAME/udump/DBNAME_ora_17709.trc


/vah/oracle/product/11.2.0.2/bin/adrci >> /fisc/oracle/purge/purgetrace.log << EOF set homepath diag/rdbms/DBNAME/DBNAME purge -age 1440 -type TRACE exit EOF echo 'SIZE AFTER DBNAME TRACE PURGE' >> /fisc/oracle/purge/purgetrace.log
ls -l /vah/oracle/admin/DBNAME/udump/DBNAME_ora_29248.trm >> /fisc/oracle/purge/purgetrace.log
ls -l /vah/oracle/admin/DBNAME/udump/DBNAME_ora_29248.trc >> /fisc/oracle/purge/purgetrace.log
ls -l /vah/oracle/admin/DBNAME/udump/DBNAME_ora_17709.trm >> /fisc/oracle/purge/purgetrace.log
ls -l /vah/oracle/admin/DBNAME/udump/DBNAME_ora_17709.trc >> /fisc/oracle/purge/purgetrace.log

df -h /vah/oracle >> /fisc/oracle/purge/purgetrace.log


echo 'NUMBER OF FILES AFTER DBNAME TRACE PURGE' >> /fisc/oracle/purge/purgetrace.log
ls -1R /vah/oracle/admin/DBNAME/udump | wc -l >> /fisc/oracle/purge/purgetrace.log

cat /fisc/oracle/purge/purgetrace.log | mailx -s "DBNAME Trace Purge Job output" Harsha@email.com

No comments: