GoldenGate with 99.999 uptime
Anonymous | TrustRadius Reviewer
Updated November 09, 2018

GoldenGate with 99.999 uptime

Score 10 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Oracle GoldenGate

We use Oracle GoldenGate to achieve high availability, perform upgrades, and for patching and data center drills.

We use Golden Gate in active active configuration.

It meets our SLA requirement of 99999.


  • Oracle GoldenGate provides the best HA solution. It gives us 99.999% availability in a year.
  • GoldenGate is very easy to install, set up and troubleshoot. The commands are fairly simple.
  • GoldenGate is a very lightweight tool. It performs auto CDR in active setups.
  • Tuning Golden Gate is fairly very simple.
  • Golden Gate is very fast in catching up the lag.
  • Where there are open transactions GoldenGate needs to auto-detect them.
  • GoldenGate should have dba views like Oracle Database.
  • Patching or upgrading GoldenGate is a bit complicated.
  • When extract or pump trail file sequence number is about to reach the max limit, we should get a warning or critical threshold alert.
  • When Integrated replicat is altered, it converts to classic replicat. We don't get any message that the replicat is running in classic mode. There should be some sort of alerting in the ggserrlog file.
  • GoldenGate has saved us from penalties by providing 99.999% uptime.
  • DR drills are very fast due to active architecture using GoldenGate.
  • We need to pay for additionals licenses for GoldenGate but for Data Guard we don't have to pay for and additional license.

Oracle Golden Gate is very user friendly product and very easy to install, setup and troubleshoot.

Quest SharePlex is bit complicated compared to Oracle Golden Gate and has less features.


  • For real-time or tier 0 and tier 1 applications where 99.999% availability is needed GoldenGate is the best solution.
  • For tier 2 and above applications, Oracle Data Guard is a good choice.

Oracle GoldenGate Feature Ratings

Connect to traditional data sources
6
Connecto to Big Data and NoSQL
6
Simple transformations
5
Complex transformations
5
Data model creation
5
Metadata management
5
Business rules and workflow
5
Testing and debugging
5
Integration with data quality tools
5
Integration with MDM tools
5

Using Oracle GoldenGate

100 - Oracle Golden Gate is used for high availability. Golden Gate helps our application to fulfil the the active active requirement as well. We can do patching, upgrades or any maintenance tasks without any downtime due to Golden Gate.
100 - Oracle DBA, SQL Server DBA mostly use Golden Gate. Mostly DBA skills are needed to support Golden Gate.
  • High Availability
  • Migrations and Upgrades without downtime
  • Achieve Active Active requirement
  • We use Hub and Spoke model of Golden Gate
  • We use Active active feature of golden Gate
  • We used Golden Gate for Sybase to Oracle Migration.
  • Use Golden Gate micro services for easy management.
We are very Happy with the product and the support and it helps us achive our 99999 SLA.

Evaluating Oracle GoldenGate and Competitors

  • Price
  • Product Features
  • Prior Experience with the Product

Golden Gate is a very solid product with very less bugs. It's very user friendly and can be used in various Heteregenous environment.

The commands are very simple and very easy to troubleshoot.


I won't change my decision to move away from Golden Gate.

Oracle GoldenGate Implementation

We use the oracle golden gate documentation for implementation. All the steps are very well documented.
  • while impleming parallel classic replicat there was a manual error in specifying the range and that let to data out of sync.
  • data looping
  • out of sync data

Oracle GoldenGate Support

Overall support for Golden Gate is very good. Whenever we have created an SR, We get solution for it pretty fast.
ProsCons
Quick Resolution
Good followup
Knowledgeable team
Problems get solved
Kept well informed
No escalation required
Immediate help available
Support understands my problem
Support cares about my success
Quick Initial Response
None
Yes - We are happy and satisfied with the premium support
We had a case where we had to have end to end lag reduce from 10 seconds to 1 second and Golden Gate team provided us with a solution for it. This was very much needed for our active active and because of this we were able to achieve our goal.

Using Oracle GoldenGate

As stated earlier Golden Gate is very user friendly and easy to use. Has some very good features that helps troubleshooting very easy.
ProsCons
Like to use
Relatively simple
Easy to use
Technical support not required
Well integrated
Consistent
Quick to learn
Convenient
Feel confident using
Familiar
None
  • Golden Gate install and setup
  • troubleshooting and checking status of the processes
  • logdump utility.
  • golden Gate doesn't have compare and repair functionality and so if we have to sync two databases then it takes quite some time and effort to do it.
  • Setting up bidirectional replication.
  • Active Active setup.