How to monitor physical standby database
SQL> select * from v$dataguard_stats;
NAME VALUE UNIT TIME_COMPUTED
-------------------------------- ------------------------------ ------------------------------ ------------------------------
apply finish time +00 00:00:00.5 day(2) to second(1) interval 09-JUN-2009 13:37:22
apply lag +00 00:00:50 day(2) to second(0) interval 09-JUN-2009 13:37:22
estimated startup time 15 second 09-JUN-2009 13:37:22
standby has been open N 09-JUN-2009 13:37:22
transport lag +00 00:00:07 day(2) to second(0) interval 09-JUN-2009 13:37:22
$cat check_log_apply.sh
export ORACLE_SID=pfds1
echo $ORACLE_SID
/u01/sq/ora_1/oracle/db/10.2.0/bin/sqlplus -s "/ as sysdba" @/u01/sq/ora_1/oracle/db/10.2.0/scripts/check_log_apply.sql
$cat check_log_apply.sql
set head off
set feed off
spool /u12/log_apply_$ORACLE_SID.log
select substr(VALUE,5,2) from v$dataguard_stats where NAME='apply lag';
exit
spool off
#!/bin/ksh
###############################################################################
# Author: Saminathan Seerangan
###############################################################################
FIELD1=`cat /u12/log_apply_pfds1.log`
echo $FIELD1
if test $FIELD1 -ge 10
then
mailx -s "Log apply delay for PFDS " my_phone_number@vtext.com fi
2 Comments:
Infatuation casinos? experimentation this late-model [url=http://www.realcazinoz.com]casino[/url] advisor and provisions online casino games like slots, blackjack, roulette, baccarat and more at www.realcazinoz.com .
you can also go through testifier to our redesigned [url=http://freecasinogames2010.webs.com]casino[/url] orientate at http://freecasinogames2010.webs.com and immature remand earthly means !
another unsurpassed [url=http://www.ttittancasino.com]casino spiele[/url] conspire is www.ttittancasino.com , in task of of german gamblers, case in manumitted online casino bonus.
Very nice post. I just stumbled upon your weblog
and wished to say that I've really enjoyed surfing around your blog posts. In any case I'll be subscribing to your feed
and I hope you write again soon!
Check out my homepage book of ra tricks forum ()
Post a Comment
<< Home