#!/bin/bash
# set the environment for oracle database
export ORACLE_SID=$1
export ORACLE_HOME=/u01/app/oracle/product/1900/db_1
export PATH=$PATH:$ORACLE_HOME/bin
# Connect to the Oracle database
FLASH_RECOVERY_SIZE=$(sqlplus -s / as sysdba <<EOF
set pagesize 0
set linesize 1000
col "FLASH_RECOVERY_SIZE(MB)" format 9999999999
SELECT
    NAME,
    TO_CHAR(SPACE_LIMIT, '999,999,999,999') AS SPACE_LIMIT,
    TO_CHAR(SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE, '999,999,999,999')
       AS SPACE_AVAILABLE,
    ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100)
       AS PERCENT_FULL
    FROM V\$RECOVERY_FILE_DEST;

EOF
)

# Check the flash recovery area usage
USAGE=$(echo $FLASH_RECOVERY_SIZE | awk '{print $4}')

# Output a message based on the usage
if [ $USAGE -lt 70 ]; then
  echo "Flash recovery area usage is at $USAGE%. Space is still available."
elif [ $USAGE -lt 80 ]; then
  echo "Flash recovery area usage is at $USAGE%. Space is getting low."
elif [ $USAGE -lt 90 ]; then
  echo "Flash recovery area usage is at $USAGE%. Space is running low."
else
  echo "Flash recovery area usage is at $USAGE%. Space is critical."
fi