July 14

0 comments

Data Guard vs GoldenGate

Ok, so you have an Oracle Database and you need to implement Disaster Recovery and/or High Availability strategies? First, let´s clearly understand what´s the difference between these two terms:

High Availability (HA) means eliminating single points of failure and Disaster Recovery (DR) is the process of getting a system back to an operational status when a system is rendered inoperative. In essence, Disaster Recovery rescues you when High Availability fails.

With these concepts clarified, you must define which one will be implemented (maybe both), since the tool to be used depends on it.

So, what are Oracle's most recommended products for this kind of job? 

Currently, Active Data Guard and GoldenGate are Oracle´s best Solutions.

In general terms, Data Guard provides a robust, high-performance disaster recovery environment that is ideal for critical production databases and can be used simultaneously as a backup, reporting, and test environment.

GoldenGate, on the other hand, is a heterogeneous real-time replication tool, with enormous flexibility. It allows you to precisely select the data to be replicated, send only the necessary data to each destination, and even apply transformations to this replicated data. All this without being intrusive in the source databases.

Subscribe to the best newsletter there is.

You won't regret it!

The Challenge?

Well, the problem could be the cost involved in implementing these solutions depending on the current state of your technology environment.

GoldenGate is more expensive than Data Guard in terms of named user licenses and processor licenses, but has the advantage of working in a Standard Edition of Oracle, so you don't need to migrate to a high cost environment to benefit of the tool. In the other hand, Data Guard cost less in terms of named user licenses and processor licenses, but the product only operates in Enterprise edition, so if you don't have that version, your implementation could have a representative impact on cost.

What to do then?

Well, at Allari, we are characterized by our flexibility, so if you have an Oracle database and want / need a High Availability and / or Disaster Recovery tool, we can offer you the best solution available oriented to your specific needs. We can even suggest a custom solution for those environments where total investment is an issue, proposing well-tested software in a SaaS scheme that can help you.

About Allari

Allari implements customized service plans for IT Operations & Cyber-security which allow you to complete a higher volume of planned work, gain the capacity to innovate and help your business to win.


Tags

Business Continuity, Data Guard, Disaster Recovery, GoldenGate, High Availability, Oracle Database


About the author

Carlos Corral

I work for Allari since 2018, as a Service Manager and occasionally I have functioned as Account Manager and/or Project Manager depending on the customer and the project. I'm very pleased to work with such an extraordinary group of people and amazing company.

You may also like

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
>