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/

#!/bin/bash


#ORACLE_HOME=/sw/app/oracle/product/19.0.0.0/db_3
#ORACLE_SID=CECOPRD1
#ORAENV_ASK=NO
#export ORACLE_HOME ORACLE_SID ORAENV_ASK
#. oraenv
#unset ORAENV_ASK


. /home/oracle/.CECOPRD.env

#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