2 Replies Latest reply: Nov 15, 2012 7:12 PM by mseberg RSS

    Options for Oracle GoldenGate and Oracle Data Guard

    967664
      Hi,

      Please give me suggestions on Oracle GoldenGate vs Oracle DataGuard ? Based on options, i have to choose for implementation

      Thanks in advance

      Thanks
      Venkat
        • 1. Re: Options for Oracle GoldenGate and Oracle Data Guard
          LaserSoft
          Hi

          Oracle Dataguard :

          1. Primary Database and Standby Database Should be same. (But 11g Onwards it supports Heteregenous Data Guard Configurations. Example : We can imeplement Oracle Data Guard between Oracle Linux server 6.2 (x86_64) and Microsoft Windows 2008 Server R2 (x64)

          2. Oracle Database version should be same in source and target

          3. No additional license required for Oracle Data Guard to install.

          Oracle GoldenGate :

          1. Operating System in Primary Database and Standby Database need not be same.

          2. Primary Database and Standby Database need not be same. (Including Database Software).

          3. Oracle GoldenGate Software Licence required in Source and Target Databases.

          Hope it will helps....

          Thanks
          LaserSoft
          • 2. Re: Options for Oracle GoldenGate and Oracle Data Guard
            mseberg
            Hello;

            Goldengate can replicate bi-directional (like RAC instance with different storage) and database independent.

            bi-directional is cool but can consume a lot of resources.

            Active Data Guard and Golden Gate require additional licenses and add more functions depending on your needs.


            Dataguard is for DR purpopse. 11g has active data guard you can query but bi-directional replication is not possible.

            Data Guard comes with Enterprise Edtion .

            More info here.

            http://www.oracle.com/technetwork/database/features/availability/dataguardgoldengate-096557.html

            Best Regards

            mseberg