Try our new research platform with insights from 80,000+ expert users
Oracle Data Guard Logo

Oracle Data Guard pros and cons

Vendor: Oracle
4.2 out of 5
575 followers
Post review

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Oracle Data Guard offers robust data protection through real-time replication and failover capabilities, ensuring high data availability and safety across data centers.
It features the Data Guard Broker for streamlined administration and management, enhancing operational efficiency and disaster recovery processes.
Oracle Data Guard supports scalable configurations to meet varying organizational demands, growing alongside enterprise needs without compromising performance.
The Flashback technology and the ability to revert databases to a specific point in time minimize the need for complete restorations, thereby ensuring business continuity.
Users appreciate the snapshot feature which allows testing or making temporary changes without altering the primary data, providing flexibility in handling data across different environments.

CONS

There is a possibility of data loss during replication when there is a network disconnection between the primary and secondary databases or a crash in the primary database.
IP implementation and maintenance are difficult to manage across Oracle solutions, including Oracle Data Guard.
The pricing of Oracle Data Guard is quite high and should be reduced to be more reasonable for customers.
Operational issues exist, such as support for migrating storage types and improving the communication link between secondary and primary databases.
The initial setup of Oracle Data Guard is complex and the deployment cost is expensive.
 

Oracle Data Guard Pros review quotes

MB
Jul 18, 2021
It's a very good solution if you want to protect your data across two data centers, or you have a middle man or many administrators who use these solutions for protecting their data. It's very reliable compared to other solutions that are most often not storage-based.
Azhagupandi Parthiban - PeerSpot reviewer
Jan 4, 2024
We have not encountered any major challenges with replication. We were able to achieve near-real-time replication. Also, with the switchover failover, we were not getting any technical issues. It's a pretty stable product.
AH
Mar 7, 2024
With Data Guard, Oracle guarantees zero data loss, providing peace of mind for organizations relying on their data for critical operations.
Learn what your peers think about Oracle Data Guard. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,528 professionals have used our research since 2012.
IfeoluwaOshinowo - PeerSpot reviewer
Feb 6, 2024
Data Guard also improved because customers with an active Data Guard license want to reduce the I/O in a production environment. Some application complaints to it for Oracle reporting purposes. It has a production environment that needs to be enhanced.
Federico Bonifazi - PeerSpot reviewer
Jan 31, 2024
The most valuable aspect for me is undoubtedly the failover capability and the assurance of data safety provided by Oracle Data Guard.
Adriano-Simao - PeerSpot reviewer
Aug 11, 2020
We have found the replication feature the most useful. We use this feature the most. The ability to recover a database with less effort and the use of Oracle Data Guard Broker to administer the complete environment are also very useful features.
MS
Jul 29, 2019
We chose this solution for the availability of the databases. We can't afford Oracle Grid, this is the best solution if you want something similar that's less expensive.
Oz Pozner - PeerSpot reviewer
Feb 16, 2022
Backup and application continuity are most valuable.
MK
Nov 2, 2023
It is a top-notch product, super stable, making it our go-to for internal operations.
OM
Jun 6, 2019
Oracle Data Guard is a free solution. When you apply for Enterprise Manager, it comes for free with the solution.
 

Oracle Data Guard Cons review quotes

MB
Jul 18, 2021
The IP implementation and maintenance are a little bit hard to manage across Oracle solutions, including Oracle Data Guard.
Azhagupandi Parthiban - PeerSpot reviewer
Jan 4, 2024
The only difficult part is the cost factor, licensing. Another area of improvement is support.
IfeoluwaOshinowo - PeerSpot reviewer
Feb 6, 2024
There is an issue with their application on ODG. There were a lot of edits in the logs. Sometimes, we only get a little cue from the Data Guard Broker logs if there's an issue.
Learn what your peers think about Oracle Data Guard. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,528 professionals have used our research since 2012.
Federico Bonifazi - PeerSpot reviewer
Jan 31, 2024
For Italian medium-sized companies, the main challenge lies in the cost associated with licenses.
Adriano-Simao - PeerSpot reviewer
Aug 11, 2020
One thing that can be improved is the GUI. It would be good to have a very nice GUI to easily configure and administer, providing different presentations to the database administrator. The feature that can be included is the integration with third-party monitoring systems, that is, monitoring systems from other vendors, not only from Oracle.
MS
Jul 29, 2019
For every standby server you have, you must pay a licensing fee, which is the main disadvantage.
Oz Pozner - PeerSpot reviewer
Feb 16, 2022
The usage of block storage devices in the cloud or migration of a type of storage from one site to another site can be improved. Currently, we have to use multi-node to single node because of the lack of storage support on the Azure side. It did not really work. Our DBA had to spend a lot of time tweaking the Data Guard tools, or the underlying Oracle VMs, to make sure that Data Guard would run on top of different types of storage. So, if it can support transporting or getting from one type of storage to another type of storage in a different site or a different technology, it would be very helpful.
MK
Nov 2, 2023
A significant improvement for Oracle Data Guard would be enabling the disaster recovery site to handle read and write operations, not just data storage.
OM
Jun 6, 2019
Oracle Data Guard is stable, but you need to keep monitoring the system all the time. You need to keep monitoring the archives.
MS
Dec 4, 2019
When the data replicates into the standby database there is a possibility of having a microsecond amount of data loss. The data loss occurs when there is a network disconnection between the primary and secondary standby database located in the data centers or if there is a crash in the primary database.