Oracle adrci: differenze tra le versioni
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 |
|||
| ⚫ | |||
#ORACLE_HOME=/sw/app/oracle/product/19.0.0.0/db_3 |
|||
#ORACLE_SID |
#export ORACLE_SID ORAENV_ASK |
||
| ⚫ | |||
| ⚫ | |||
unset ORAENV_ASK |
|||
| ⚫ | |||
#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