Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Monitoring failover - Data Guard Broker

486215Jun 15 2009 — edited Jun 19 2009

Hi,

I work on a Oracle 10.2.0.4 database on Solaris 10. It is a 2 node RAC database with a physical standby configured.

I want to monitor (send a mail) to myself when failover occurs (which will be triggered by data guard broker ) , I think so I can monitor the failover using alert log (which normally does log the command when we initiate a failover) but I am not sure whether data guard broker also does the same( writes appropriate commands when a failover is triggered)

Is there any other way we can come to know when a failover occurs (we can query database_role from v$dataguard status) but I am looking for some trigger that will be fired instantaneously when a failover is initiated ?

Also is it possible to monitor the observer, whether it is up or not ?

This post has been answered by Uwehesse-Oracle on Jun 15 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 17 2009

Added on Jun 15 2009

#general-database-discussions

3 comments

331 views