Search This Blog

Total Pageviews

Monday, 22 April 2024

Oracle Purge xml files

Oracle xml file

 
 
# remove .xml files older than 1 month


54 08 * * * $HOME/bin/purge_adr.sh &> /dev/null


cat $HOME/bin/purge_adr.sh
#!/bin/bash

# purge XML files over 30 days old
export GRID_HOME=/u01/app/grid
export PATH=$GRID_HOME/bin:/bin:$PATH
SCRIPT_LOG=/home/grid/bin/purge_adr.log
SCRIPT_AGE=44640

date >> $SCRIPT_LOG

HOMES="diag/tnslsnr/irac01/listener_scan1
diag/tnslsnr/irac01/listener
diag/tnslsnr/irac01/mgmtlsnr
diag/tnslsnr/irac01/asmnet1lsnr_asm
diag/tnslsnr/irac01/listener_test"

for h in $HOMES
do
        adrci_home=$h
        echo $adrci_home
        echo 'purging from : '  $adrci_home >> $SCRIPT_LOG
        adrci exec="set homepath ${adrci_home}; purge -age ${SCRIPT_AGE}"  -type ALERT >> $SCRIPT_LOG
done


exit

Oracle DBA

anuj blog Archive