Oracle adrci

http://gmuoracledba.blogspot.nl/2010/10/purging-trace-and-dump-files-with-11g.html

https://nigelnoble.wordpress.com/2015/01/08/log-file-sync-and-the-mttr-advisor/

script

#!/bin/bash

ORACLE_SID=ORCL
ORAENV_ASK=NO
#export ORACLE_SID ORAENV_ASK
. oraenv
unset ORAENV_ASK

#ADR_BASE=/oradiag/rdbmsdiag
#export ADR_BASE

# 21 giorni (504 ore 30240 minuti)

for ADR_BASE in /oradiag/rdbmsdiag /oradiag/griddiag
do
echo ADR_BASE=$ADR_BASE
export ADR_BASE=$ADR_BASE
sleep 2

adrci exec='show homes' | grep -v 'ADR Homes:' | while read H
do
 adrci exec="set home $H
set control \(SHORTP_POLICY=504\)
set control \(LONGP_POLICY=504\)
show control
purge -age 30240
"
done
done

Versione semplice

adrci exec='show home' | grep -v 'ADR' | while read ADRHOME
do
  echo ${ADRHOME}
  adrci exec='set homepath '${ADRHOME}' ; purge -age 14400'
done