This discussion is archived
1 Reply Latest reply: May 23, 2013 10:49 PM by shiyer RSS

Has Anyone configured Oracle GoldenGate for HA w/Oracle Clusterware ?

userTK421 Newbie
Currently Being Moderated
Hello,

I am looking for some perspective of real world cases with respects to configuring Oracle GoldenGate 11.2 for HA with Oracle Clusterware 11.2.0.3.

I have seen essentially two methods for this configuration:

<OL><LI>Using the Bundled Agents (XAG) with Clusterware 11.2.0.3 , specifically the agent for GoldenGate</LI>

<LI>Using crsctl to add the GoldenGate instance process(s) as standard application cluster resources , configured with application action script(s).</LI></OL>

I have reviewed both options covered in these documents and either seem like they'd work fine.

Option 1 covered in this doc which came out in Sept 2012:
+[http://www.oracle.com/technetwork/products/clusterware/overview/ogg-xag-bp-1915977.pdf]+

Option 2 covered in this doc which was released in March 2013:
+[http://www.oracle.com/technetwork/products/clusterware/overview/ogg-xag-bp-1915977.pdf]+

Its curious to see that Option 2, which does not use the agents is the more recent doc.

Also, as some background information, I have a 2 node Grid Infrastructure cluster on OEL 6.3. On this 2 node cluster, I am running an single instance Oracle database configured for HA as an application cluster resource; similar to the configuration defined in this doc:
+[http://www.oracle.com/technetwork/products/clusterware/overview/si-db-failover-11g-134623.pdf]+

My plan is to implement GoldenGate Integrated capture on the same cluster..either on the same node as the database, or on the 2nd node as a Downstream Integrated Capture instance.

I can see some benefits of both options, and was curious to know if anyone has this type of configuration running in an active dev/test/prod environment.
If so, was there a decision point that made one option better than the other ?

Edited by: userTK421 on May 19, 2013 9:22 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points