Oracle adrci - Cronologia

WikiSysop il 09:47, 10 giu 2026

2026-06-10T09:47:47Z

← Versione meno recente		Versione delle 09:47, 10 giu 2026
Riga 37:		Riga 37:
	</pre>		</pre>

			Versione semplice
			<pre>
			adrci exec='show home' \| grep -v 'ADR' \| while read ADRHOME
			do
			echo ${ADRHOME}
			adrci exec='set homepath '${ADRHOME}' ; purge -age 14400'
			done
			</pre>

	[[Categoria:Database]]		[[Categoria:Database]]

2026-06-01T09:45:11Z

← Versione meno recente		Versione delle 09:45, 1 giu 2026
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

2026-06-01T09:43:48Z

← Versione meno recente		Versione delle 09:43, 1 giu 2026
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/

			<pre>
			#!/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
			</pre>


			[[Categoria:Database]]
			[[Categoria:Oracle]]

2015-12-02T22:08:22Z

← Versione meno recente		Versione delle 22:08, 2 dic 2015
Riga 1:		Riga 1:
	http://gmuoracledba.blogspot.nl/2010/10/purging-trace-and-dump-files-with-11g.html		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/

2015-12-02T21:45:33Z

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

Nuova pagina

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