### 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
### Monitoring script for data guard
#0 * * * * /home/oracle/runcheck.sh 2>&1
No comments:
Post a Comment