GoldenGate with 99.999 uptime
Updated November 09, 2018
GoldenGate with 99.999 uptime
Score 10 out of 10
Vetted Review
Verified User
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 GoldenGate Feature Ratings
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.
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
- Implemented in-house
- 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
| Pros | Cons |
|---|---|
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
| Pros | Cons |
|---|---|
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.