script to monitor FRA space usage
Script to monitor FRA space usage
Filename : /u01/app/oracle/scripts/monitor_recospace.sh
| ORAENV_ASK=NO ORACLE_SID=$ORACLE_SID export $ORACLE_SID . oraenvLOGPATH=/u01/app/oracle/scripts/output TODAY=`date +’%Y%m%d%H:%M:%S’` OUTPUT_FILE=$LOGPATH/output-${TODAY}.log $ORACLE_HOME/bin/sqlplus -s “/as sysdba” << EOF spool ${OUTPUT_FILE} col name for a30; SELECT NAME,((SPACE_LIMIT – SPACE_USED + SPACE_RECLAIMABLE) / 1024 / 1024 / 1024) AS SPACE_AVAILABLE_GB, ROUND((SPACE_USED – SPACE_RECLAIMABLE) / SPACE_LIMIT * 100, 1) AS PERCENT_FULL FROM V\$RECOVERY_FILE_DEST; spool off; exit; EOF cd $LOGPATH echo FRASPACE USAGE |mailx -s “FRA space usage for every 1 hour” -r “oracle_srvr@ajara.tech” -a $OUTPUT_FILE dba@ajara.tech |
Parameters to be passed:
One Parameter
database name .
For example ORAP
Called scripts/Calling scripts:
None
How to run the script?
$/u01/app/oracle/scripts/monitor_recospace.sh ORAP
Sample Output:
NAME SPACE_AVAILABLE_GB PERCENT_FULL
—————————— —————— ————
+RECO 759.62893 4.1
crontab entry
## Monitoring every one hour for RECO space
10 * * * * /u01/app/oracle/scripts/monitor_recospace.sh
See Also