SCRIPT PREPARATION: PRIMARY DB UNIQUE_NAME –  PRIM STANDBY DB UNIQUE_NAME – STANDBY export ORACLE_SID=PRIM export PATH=$ORACLE_HOME/bin:$PATH

echo -e “show database STANDBY”|${ORACLE_HOME}/bin/dgmgrl sys/orcl1234 > DB_DG_DATABASE.log cat /home/oracle/DB_DG_DATABASE.log | grep “Apply Lag” > FILTERED_DB_DG_DATABASE.log time_value=`cut -d ” ” -f 14 FILTERED_DB_DG_DATABASE.log` time_param=`cut -d ” ” -f 15 FILTERED_DB_DG_DATABASE.log` if [[ “$time_param” == “minutes” && “$time_value” -ge 1 ]] then mailx -s “DREAIDB LAG is in minutes ” [email protected] <DB_DG_DATABASE.log else if [[ “$time_param” == “seconds” && “$time_value” -ge 30 ]] then mailx -s “DREAIDB LAG is in seconds ” [email protected] <DB_DG_DATABASE.log else if [[ “$time_param” == “hour(s)” && “$time_value” -ge 1 ]] then mailx -s “DREAIDB LAG is in hours ” [email protected] <DB_DG_DATABASE.log fi fi fi