Oracle Flash Recovery Area (FASH_RECOVERY, FLASH_RECOVERY_AREA) Lookup files in flash recovery
SQL> SELECT * FROM V$RECOVERY_FILE_DEST;
NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
---------- ------------ --------- ----------------- ----------------
u01/app/oracle 2147483648 1545718272 0 100
SQL>
SQL> SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 43.57 0 96
BACKUPPIECE 28.41 0 4
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
flash recovery area check #!/bin/sh
export LD_LIBRARY_PATH=/usr/local/nagios/instantclient
var=$(/usr/local/nagios/instantclient/sqlplus -s nagios/<pass>@//<ip>/EBPROD <<EOF | awk '{print $1}'
set echo off termout off feedback off pages 0 newpage 1 head off
select ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 0) AS PERCENT_FULL FROM V\$RECOVERY_FILE_DEST;
exit sql.sqlcode;
EOF)
echo Percent Full: %$var
if [ $var -lt 90 ] ; then
echo "200 OK";
exit 0;
else
echo "CRITICAL";
exit 1;
fi
|