integrated replication monitoring with sql query
Hello Experts,
we are using golden gate Integrated replication on our three node RAC (source & target). we are configured golden gate high availability.
now we need to monitor golden gate process with sql query.
when extract is stopped,abended
when pump stopped, abended
when replicat is stopped, abened
when manager process is stopped or abended
lag is more than 30 min
then reason why i am asking, golden gate will run from one node always. when node is down, golden gate resources are failover to another node and running fine.
when failed node back online, my cron job on the node complain that golden gate is down, but that is not the case.