We just raised a $30M Series A: Read our story

Oracle Data Guard OverviewUNIXBusinessApplication

Oracle Data Guard is the #22 ranked solution in our list of best Backup and Recovery Software. It is most often compared to CloudEndure Disaster Recovery: Oracle Data Guard vs CloudEndure Disaster Recovery

What is Oracle Data Guard?

Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Data Guard can be used with traditional backup, restoration, and cluster techniques to provide a high level of data protection and data availability.

Oracle Data Guard is also known as Active Data Guard.

Oracle Data Guard Buyer's Guide

Download the Oracle Data Guard Buyer's Guide including reviews and more. Updated: October 2021

Oracle Data Guard Customers

Athenahealth, Discover Financial Services

Oracle Data Guard Video

Pricing Advice

What users are saying about Oracle Data Guard pricing:
  • "If you want to have everything automated and done smoothly, you have to add additional licenses."

Oracle Data Guard Reviews

Filter by:
Filter Reviews
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
MahdiBahmani
Solution Architect, IT Consultant at Merdasco - Rayan Merdas Data Prosseccing
Real User
Top 5Leaderboard
Very stable but difficult to implement and maintain

Pros and Cons

  • "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."
  • "The IP implementation and maintenance are a little bit hard to manage across Oracle solutions, including Oracle Data Guard."

What is our primary use case?

The primary use case of this solution is on disaster recovery. this software is reliable and is suited for long distances.

How has it helped my organization?

One of my customer's sites was a database made with Data Guard specifically because of some issues that were on the network. We found we could switch to Oracle Data Guard and it took less than one minute to switch over, which was fantastic. 

What is most valuable?

I'm constantly looking for the best solution for protecting my data in data filters, and most are powerless in terms of protecting our Oracle database. The Oracle Replication Solutions and Oracle Data Guard are the best in this area, however. The stability and resiliency are closely monitored, and you cannot find the same protection solution outside of Data Guard or Oracle RAC for protecting your data. 

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.

What needs improvement?

Oracle is not easy to implement, and you cannot find clear documentation on the internet or, unfortunately, on the Oracle website. You have to do a lot of research yourself and spend a lot of time seeking out all of the best documents that are related to Oracle on other websites. If they could create more documentation and improve their library of resources, it would be very helpful.

The IP implementation and maintenance are a little bit hard to manage across Oracle solutions, including Oracle Data Guard.

For how long have I used the solution?

I have been using the solution for more than eight years.

What do I think about the stability of the solution?

Oracle Data Guard is quite stable but you do need to check on it every day to ensure functionality. You have to define some of the operating system stabilities yourself and you need to be sure to deal with any problem in your operating system because good functionality really depends on the operating system. 

What do I think about the scalability of the solution?

Scalability is good because you can cluster your Oracle Data Guard and Oracle RAC. That way you can switch to Oracle Data Guard gives you scalability, and, in comparison with other solutions, it is very stable and scalable because of these features. Most engineers prefer to use Oracle Database. Compared with other solutions, Oracle is a little bit hard to implement and maintain but as a technology, it's very good.

In terms of the number of users on the solution, it varies by project. On one of our latest projects, we had more than 10,000 people directly on the database.

How are customer service and technical support?

Unfortunately, because of sanctions, we can't directly contact Oracle or use Oracle's knowledge base. I've indirectly contacted them because, in some cases, it's a must to have Oracle support. Sometimes you can't solve problems and you need to have accessibility to support to solve them. Support is very important in many cases because the information is crucial for many companies that want to avoid facing disasters in their data centers.

Which solution did I use previously and why did I switch?

We didn't previously use a different solution. We exclusively use Oracle products.

How was the initial setup?

The initial setup is very complex. Users need to be familiar with the operating system, as well as how their network and Oracle Concepts as a network, work.  

In our last implementation, deployment took between five and eight hours. There were some problems in correcting each solution on the network and then we wanted to test for its stability and we wanted to simulate the environment quality before pushing it online. 

Ultimately, we found some problems and discovered how to resolve them after a few hours. We just needed to figure out how to connect the database directly on S08 LAN. We had many issues. In one case the link of S-storage was disconnected for example. 

Some countries try to persuade that you should use all of the networks, but in some cases, you have to find your own best way forward. In this case, we found we had to connect the storage models directly through the user feature on the Oracle Database.

Implementation is not easy. Going forward, I'm going to make a script for implementation for this database, and I think it's going to be easier for implementation in the future.

For most projects, we have two people that handle the implementation of the solution. One as a solutions engineer and the other was DBA administrator. Sometimes you also may need to use a network administrator as well. At minimum, you need two experts and maybe three in some cases. You want accurate maximum availability in-network, especially on the network.

What about the implementation team?

I implement this solution for some of my clients and I consult on the best way to implement the solution. Most of the information on the net is not reliable, but at this point, I'm an expert. I could write my own book on how to implement this solution for my customers. Most of the time I prefer dealing with user experience. Some firms also use ADEO to ensure my implementations are good and stable.

What was our ROI?

It is not easy to calculate of ROI of this software.

What's my experience with pricing, setup cost, and licensing?

In some cases, some costumers chose to buy a lot of licenses to have software - at least at first. I'm not happy and okay with some policies of Oracle. In some cases, you have to pay extra money for some features. It's very hard to have access to software directly in comparison to buying some licenses. You can adjust them for some Oracle software, however, if you want to develop or expand your features, it's typically hard to do so in my country.

Based on my friend's and colleague's experience, they find it a little bit tricky to use Oracle for buying certain software or getting extra features, and based on my experience, most free and open-source projects are already pretty good. 

Which other solutions did I evaluate?


There is no redundant software as stable, and resilient data guard.

What other advice do I have?

Most of my projects are on-premise, and most of them are based on low-cost engineers and information on the internet.

Right now, the cloud is really good if you change units. There is a direct limitation on some solutions because of the cost being high for this type of software and I chose not to use the cloud. 

The solution is quite functional, however, I do find that some features are not great in real production. You need to have the software to ensure the continuity in the case of using Oracle.

I'd rate the solution six out of ten due to its difficulty in terms of maintenance and audio problems. I'm also looking for CTCT maintenance and implementation and wish is was a bit easier.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
Adriano-Simao
IT System Integrator at a financial services firm with 201-500 employees
Real User
Top 5Leaderboard
Works very well and hardly requires any interventions

Pros and Cons

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

What is our primary use case?

We have a primary database and a secondary database. Both databases are on different sites, which are geographically distant. One site is used as the primary site, and the other one is used as the secondary site. We have configured Oracle Data Guard to instantly replicate the data from one database to the other database on a different site. That's what we do with the Oracle Data Guard at this point. It's about business continuity.

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

We have been using Oracle Data Guard since 2010. Currently, we are using the latest version. 

What do I think about the stability of the solution?

We didn't have any incidents that caused any major problems with this implementation. There aren't any concerns regarding the stability of this solution. 

Once implemented, we can administer the whole environment with no downtime. We can switch over between sites and keep on using Oracle Data Guard like this. Until now, there aren't many things to do. It has been very good. That's why we keep on using this solution.

What do I think about the scalability of the solution?

It was a good experience when we had to replicate it to more than one database and use it for new database creations and all such things. It was very simple, and until now, there are not many problems or gaps in the usability of this solution. It works very well.

How are customer service and technical support?

We didn't have many problems and much experience with technical support. 

Once implemented, we only have to monitor and take care of the gaps in the solution. Most of them happen because of the connectivity, either bandwidth or something else, or because of the growth of the database or the data being migrated from one database to another.

How was the initial setup?

The initial setup was quite complex, but it was because of a different implementation approach. It's not so complex as such. 

When it was the manual version 9, we migrated it to version 11, and now we migrated again to version 19, which is a different approach for implementing it. In the beginning, it was new and quite complex, but not so much to be done later.

What other advice do I have?

It's mandatory in order to be ready for any incident when someone has a similar environment. 

When we talk about Oracle, we are talking about the venue database, translation of database, online translation of database, and atomic translations. When we need to guarantee the stability of the database, we have to be careful. 

In financial enterprises that use Oracle as a secure relational database management system, the data that you have is very important, and it is the asset that brings the most value to the company. I would recommend that every implementation that goes to the production environment must be done together with Oracle Data Guard. Even small databases can be powered by this solution. 

I would rate Oracle Data Guard a nine out of ten. During all these times and all these years, if I can count the number of times that we had to intervene or we had to do something by ourselves, I can't count more than three times.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Learn what your peers think about Oracle Data Guard. Get advice and tips from experienced pros sharing their opinions. Updated: October 2021.
540,984 professionals have used our research since 2012.
MS
General Manager - IT at a consumer goods company with 10,001+ employees
Real User
Top 10
Backup and recovery that is flexible, easy to maintain, and synchronizes your data to access at any time

Pros and Cons

  • "The most valuable features are the backup and restore. With this in place along with the clustering, the database is safe from hacking, hardware failure, power failures, and system crashes."
  • "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."

What is our primary use case?

The primary use case of this solution is for data protection, disaster recovery, and it's used as a backup database to restore the primary databases.

It gives the client comfort in case of any incidents, disaster or any catastrophic situation because it maintains, manages, and monitors the database and keeps a backup.

What is most valuable?

The most valuable features are the backup and restore. With this in place along with the clustering, the database is safe from hacking, hardware failure, power failures, and system crashes. 

If anything were to happen you can immediately recall your data and bring your production server back to business.

It's flexible and easy to maintain because you are configuring your primary database and a standby database in one or more locations.

What needs improvement?

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.

The data is generated on the primary database which is configured to the standby database to duplicate it on a real-time basis. So if there is a system crash or disconnection and in the time it takes to get it back up, you can lose a microsecond amount of data.

When I experienced a small crash, I compared the data between the primary database and the standby database and found that there was a small difference in the amount of data. Not all of it was replicated or backed up.

It creates issues with synchronizing the data.

Because the focus in Data Guard is in the backup and restore, there hasn't been much with the interface. 

In the next release, if there could be more focus on the interface to include add-on features that would be an added advantage going forward.

For how long have I used the solution?

I have been using Oracle Data Guard for almost six years.

What do I think about the stability of the solution?

This solution is stable. We haven't experienced any issues with it.

How was the initial setup?

The initial setup is straightforward. It's not complex.

The time it takes to deploy depends on how long it takes to replicate the primary database and to configure the standby database, but on average it can take a couple of hours.

You only need one or two people to maintain the system.

What about the implementation team?

We are integrators and we implement the solution for our clients.

What other advice do I have?

This solution is for small to medium-sized businesses, who can't afford to have two data centers or two servers.

Oracle Data Guard has many features to ensure that the database is in place. In case the primary database goes down or is corrupt in any way, you can recall the data immediately to restore the primary database.

It's important to know that backup is in place at any given time.

I would rate this solution a ten out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
MG
Lead Solution Architect at a tech services company with 10,001+ employees
Real User
Top 5
The disaster recovery is good but it is a rather complex solution

Pros and Cons

  • "The solution has been stable so far."
  • "It is a rather complex solution, so it could be more user-friendly."

What is our primary use case?

We implemented Oracle Data Guard for disaster recovery, even though one can't implement disaster recovery across multiple sites using stretch clusters, and implement a server pool at both sites. You have to build a dedicated server pool on each of the locations. 

What is most valuable?

We only use this solution from a functionality point of view to provide software coverage, so I haven't seen any special functionalities yet. It just really provides recovery in case of a disaster. It also provides a really good product forecast, like what will happen after 2023.

What needs improvement?

It is a rather complex solution, so it could be more user-friendly.

What do I think about the stability of the solution?

The solution has been stable so far. I would like to know what the performance impact will be when we go to the really big database of a customer. Because you have to synchronize everything to that effective location, with no data loss extracted, which means you have to go for a really hot interface. So you have to look at the experience for big databases. But so far there have been no problems with big databases.

How are customer service and technical support?

So far we've only had to open one ticket regarding a failure with the encryption manager of defected fault and it was handled well. We've dealt with Oracle's customer service for eight years, and their service is astonishingly good. 

How was the initial setup?

Oracle has a team that can help you with the setup. We have tested the solution for more than 2 months because moving our labeled, especially our big databases, because it's always an issue. With Data Guard, the main thing was for the application to switch the default recovery site in case of a disaster, and finding out how to score this site afterwards. 

What's my experience with pricing, setup cost, and licensing?

It's a master of making money! If you want to have everything automated and done smoothly, you have to add additional licenses. They should have more standard licenses without us having to go for additional licenses to get full support. 

Regarding infrastructure, most of the time the additional costs for uploading systems, alarming the operations, patching the operating system, caring about the shadow data, all of this needs to be maintained as well. So we end up having additional costs and that's why I would advise others to avoid it, if possible.

What other advice do I have?

I don't really have any advice for other users, because we only use the solution's basic functionality for disaster recovery. Personally, I would advise others to avoid it due to its complexity. On a scale from one to ten, I rate this solution a seven. From a functionality point of view, I can't complain about Data Guard. But I would avoid it as it adds more complexity to a configuration, which is not necessary. From a setup point of view, Oracle has experienced people that will help you with it. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Mehmet Cem Fenerci
Database and Infrastructure Architect at MNG Kargo
Real User
Top 10
Has high availability but could be cheaper

Pros and Cons

  • "We use Data Guard for online replication from data center, to data center for high availability. This is the most important feature."
  • "It is a very useful administrative IT tool. It saves on costs."

What is most valuable?

We use Data Guard for online replication from data center to data center for high availability. This is the most important feature.

What needs improvement?

I'm not really sure about what needs improvement because we use all Data Guard's features successfully.

Pricing is expensive and can use improvement. 

For how long have I used the solution?

I have been using Oracle Data Guard for about eight years. 

What do I think about the stability of the solution?

Over the course of eight years, I do think this solution is very stable. 

What do I think about the scalability of the solution?

It is scalable. 

We also use Active Data Guard. We use it to clone the production environment. We constantly use it. 

How are customer service and technical support?

I have contacted their support. We have been using their support more. We open cases one to five times a month. We use a lot of Oracle databases and because of that, we contact their support a lot. 

The quality of support will depend on the support engineer. If we speak to an agent from the Asian department, it could be a little difficult to understand the terminology. If it's with somebody from the US, Canada, or Europe, they're easier to understand.  

Which solution did I use previously and why did I switch?

We also use a real application cluster rack database. I have experience with IBM. 

How was the initial setup?

The initial setup was not complex. At first, many years back it was complex, but it's getting easier to set up in the last couple of years. It's been easier in the last few years and has been easier than past versions. 

We had somebody help us with the deployment. 

What other advice do I have?

It is a very useful administrative IT tool. It saves on costs.

I strongly recommend Data Guard. I've been using it for eight years and I would strongly recommend it. 

I'd rate Oracle Data Guard a seven out of ten. To make it a ten, the core base license could be cheaper. The cloud environment would also make it cheaper. 

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
AM
CTO at National Research Center, Egypt
Real User
Top 10
Stable and scalable, with a simple setup

Pros and Cons

  • "The solution is quite stable. We haven't experienced any bugs, glitches, or crashes. We find it to be quite reliable."
  • "The pricing of the solution is quite high. They should do what they can to bring it down so that it is more reasonable for customers like us."

What is most valuable?

The solution is quite complete. The entire package, and all the features that come with it, is very good.

What needs improvement?

The pricing of the solution is quite high. They should do what they can to bring it down so that it is more reasonable for customers like us.

The response times for technical support can be quite slow. They should work to lower these wait times so there are fewer delays in assistance.

For how long have I used the solution?

We've been using the solution for eight years.

What do I think about the stability of the solution?

The solution is quite stable. We haven't experienced any bugs, glitches, or crashes. We find it to be quite reliable.

What do I think about the scalability of the solution?

The solution is scalable. If a company needs to expand it they can.

We typically work with enterprise-level clients.

How are customer service and technical support?

We've only reached out to technical support maybe one or two times. The technical support response times can be a bit long. However, overall, we've been satisfied with their level of assistance.

How was the initial setup?

The initial setup is quite simple. I would describe it as straightforward. It's not complex.

What other advice do I have?

We're Oracle partners. We've worked with databases 11G and 12C.

If a company is planning to implement Oracle solutions, I would suggest they also implement Data Guard.

I'd rate the solution nine out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
Buyer's Guide
Download our free Oracle Data Guard Report and get advice and tips from experienced pros sharing their opinions.