TrustRadius
GoldenGate with 99.999 uptime
https://www.trustradius.com/data-integrationOracle GoldenGateUnspecified8.4172101
No photo available
Updated November 09, 2018

GoldenGate with 99.999 uptime

Score 10 out of 101
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.
  • Not a member of any user groups

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

Users and Roles

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.

Support Headcount Required

100 - Oracle DBA, SQL Server DBA mostly use Golden Gate. Mostly DBA skills are needed to support Golden Gate.

Business Processes Supported

  • High Availability
  • Migrations and Upgrades without downtime
  • Achieve Active Active requirement

Innovative Uses

  • 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.

Future Planned Uses

  • Use Golden Gate micro services for easy management.

Likelihood to Renew

10
We are very Happy with the product and the support and it helps us achive our 99999 SLA.

Evaluating Oracle GoldenGate and Competitors

Products Replaced

Key Differentiators

  • 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.


Evaluation Lessons Learned

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

Oracle GoldenGate Implementation

Implementation

9
We use the oracle golden gate documentation for implementation. All the steps are very well documented.

Implementation Details / Implementation Partner

  • Implemented in-house

Implementation Phases

Implementation Issues

  • 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

Support

10
Overall support for Golden Gate is very good. Whenever we have created an SR, We get solution for it pretty fast.

Oracle GoldenGate Customer Support Pros and Cons

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

Premium Support

Yes - We are happy and satisfied with the premium support

Bug Resolution

Yes

Exceptional Examples of Oracle GoldenGate 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

Usability

9
As stated earlier Golden Gate is very user friendly and easy to use. Has some very good features that helps troubleshooting very easy.

Usability Pros and Cons

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

Easy Tasks

  • Golden Gate install and setup
  • troubleshooting and checking status of the processes
  • logdump utility.

Difficult Tasks

  • 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.