Oracle Dataguard Broker Agent.
Hi All
Just wanting some more information surrounding the Oracle Dataguard Broker Agent for Oracle RAC. I'm reading page 16/17/18 of the VCS agent for Oracle Dataguard Installation and configuration guide.
We've 2 SFRAC clusters comprising 2 servers each. On both, the database stays up all the time with dataguard replicating from one side to the other. But how do i setup dataguard agent broker to monitor replication between the two and how does it handle failover? If both databases are up all the time how does the dataguard agent decide which one is the active and which is the standby? I've put it in a global service group so assume its achieved via that?
At the moment I've got two parrellel service groups on each cluster - the first is a local service group which has the diskgroups, mounts and oracle database reources. The second has the Dataguard agent broker and is a parrellel global service group which is its parent.
Thanks
To properly setup the Data Guard Broker agent you will need to have the following configuration:
DGMGRL will need to be configured as the means to manage/configure DataGuard
A local parallel service group for the Storage and Oracle Resources The Oracle agent (Should you chose to use it) will also have to configured to use the following:
StartUpOpt = SRVCTLSTART
Additionally, CRS will need to be configured to start the Database in "Mount" mode.
The Network Listener will have to be managed by CRS
This will allow for the OraDG agent to properly promote and demote each instance from Primary to Physical Standby (and vice versa).
The service group for the Oracle DataGuard Agent will have to be Global/Parallel and have an online-local-soft dependency on the Oracle Service group. Make sure that the SG name and resource name are identical across sites.
https://sort.symantec.com/agents/detail/2373
Take a look at OraDG guide for more details.
Hope this helps,
Joe D