Oracle adrci: differenze tra le versioni

Da Emigar.
Jump to navigation Jump to search
Nessun oggetto della modifica
Nessun oggetto della modifica
Riga 4: Riga 4:


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

<pre>
<pre>
#!/bin/bash
#!/bin/bash


ORACLE_SID=ORCL

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


. /home/oracle/.CECOPRD.env


#ADR_BASE=/oradiag/rdbmsdiag
#ADR_BASE=/oradiag/rdbmsdiag

Versione delle 09:45, 1 giu 2026

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