flash_recovery_area

bd 0

Monitorar flash_recovery_area em ambiente ASM

Na crontab coloque dessa forma: #flash_recovery_area 0,5,10,15,20,25,30,35,40,45,50,55 * * * * /u01/sisbd/flash_recovery_area/flash_SID.sh 1>/u01/sisbd/flash_recovery_area/flash_SID.sh.sucesso 2>/u01/sisbd/flash_recovery_area/flash_SID.sh.erro cat  /u01/sisbd/flash_recovery_area/flash_SID.sh cd /u01/sisbd/flash_recovery_area ./flash_asm.sh <ORACLE_SID> ./flash_asm.sh petronav cat flash_asm.sh #/bin/bash servidor=`hostname -s` . /home/oracle/.bash_profile cd /u01/sisbd/flash_recovery_area export ORAENV_ASK=’NO’ export ORACLE_SID=$1 . oraenv sqlplus -s /nolog <<FIM connect / as sysdba spool flash_$1.flag set pause off...