Thursday, July 11, 2019

How to set up alert for lag and redo apply ?


### Monitoring script for database/service/listener
20 * * * * /dbfs/FS1/dba/scripts/rac-status/rac-mon.sh > /tmp/rac-mon 2>&1
#0 * * * * /home/oracle/runcheck.sh 2>&1


[oracle@test.com ~]$ cat /home/oracle/runcheck.sh
#!/bin/bash -x

export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1
export PATH=$PATH:$ORACLE_HOME/bin

dgmgrl sys/abcd1234@orcll_prod "show database orcl" |grep -i apply >> checkresults


mailx -s 'log sync status' abhutta@test.com < /home/oracle/checkresults

Add entry as below in crontab:
### Monitoring script for data guard
#0 * * * * /home/oracle/runcheck.sh 2>&1



No comments:

Post a Comment