3 Replies Latest reply: Sep 4, 2013 9:35 AM by userTK421 RSS

    Goldengate High Availability

    SANCHITGUPTA

      Hi experts,

       

      Suggest me what approach should i follow for the given Scenario 

       

      we have unidirectional Goldengate setup on Server A and Server B,

       

      On Server A we have one Manager, One extract and one Pump

      On Server B we have One Manager, one replicate 

       

      Suppose Our Server A is get down/crash due to any reason or Manager/extract get down then how can we achieve Goldengate High Availability.

       

      Simply my question is also that,  extract should send all the data on Replicate Machine(Server B) without lag, so that no data lose.

       

       

      I am Using Goldengate 11.1.1.1.2 version and  cant use RAC..

        • 1. Re: Goldengate High Availability
          stevencallan

          Primary and secondary extract on the source, replicat on the target is the way to go. You don't want to go straight from source to target because that introduces network failure as a single point of failure for synchronization and availability.

           

          If the server on A goes down, you have other problems anyway, but GoldenGate will pick up from the last checkpoint and carry on. The HA part is that when A does go down, B is ready to go for a failover. You want to keep lag low/minimized so that what's on B is closely matched to what's on A.

          • 2. Re: Goldengate High Availability
            SANCHITGUPTA

            Stevencellan thanks for the reply

             

            Actually we don't want a lag because

            Suppose there is lag going on pump and mean while  database or server gets down or crash  then the lag data will not be  replicate on Server B.

            And when Server B is ready to go for a failover then that time server B is not sync properly.

            So i want every time both Servers should be Sync (no lag required)

             

            thanks and Regards

            Sanchit Gupta

            • 3. Re: Goldengate High Availability
              userTK421

              Sanchit,

               

              Are you running a Linux environment ?  Have you considered using Oracle Clusterware and the XAG bundled agents for GoldenGate.  I have recently setup exactly what you have.  A 2 node cluster where Node1 - Source, Node2 - Target.   Both databases using Oracle ASM that is included with Clusterware.  Also, $GG_HOME is on ACFS, which ensures trail files, prm files , etc. are available all the time to both servers. 

               

              Also, this is NOT RAC.  I have both databases configured for Single Instance failover.   So, if node1 goes down, Goldengate and the source database are sent over to nodeB.  You would have to create 2 GG_HOME, on their own ACFS file systems w/in the cluster..but that's not that big of a deal.   Please note I am running Oracle 11.2.0.3.6; and GG 11.2.1.0.9  . 

               

              check out  MOS note 1527310.1  - I followed this , and I have both Source and Target GG instances failing over to either node...and bringining the database with it.   Failover, including instance transfer is less than 2 minutes..

               

              Just another idea to maybe consider.