Purge des traces

A planifier en CRONTAB

#!/bin/sh

export ORACLE_HOME=/oracle/ora11g/dbhome

/oracle/ora11g/dbhome/bin/adrci exec = "show home"|awk '{if (NR >= 2) print $1}'|while read rep_diag

do

echo "purge de $rep_diag";date

/oracle/ora11g/dbhome/bin/adrci exec = "set home $rep_diag;purge -age 10080"

done

find /oracle/ora11g/dbhome/rdbms/audit -mtime +90 -exec rm -f {} \;

exit 0