Try our new research platform with insights from 80,000+ expert users
reviewer1069209 - PeerSpot reviewer
DBA Team Lead at a manufacturing company with 1,001-5,000 employees
Real User
Requires minimum maintenance, is stable, and is scalable
Pros and Cons
  • "The most valuable feature is the flashback standby, which allows us to test without scrapping the database."
  • "The initial setup is complex."

What is our primary use case?

Oracle Data Guard is a critical part of our business applications. The solution helps protect our data from accidental or unauthorized changes.

The solution can be deployed on-prem and on the cloud.

How has it helped my organization?

The solution has helped improve our organization by making the data more accessible quicker.

What is most valuable?

The most valuable feature is the flashback standby, which allows us to test without scrapping the database.

What needs improvement?

I would like the ability to use the read-only format from other sites for more reporting not only for disasters but also to offload the workloads on our production site. This will require some investment.

Buyer's Guide
Oracle Data Guard
February 2025
Learn what your peers think about Oracle Data Guard. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
839,319 professionals have used our research since 2012.

For how long have I used the solution?

I have been using the solution for 15 years.

What do I think about the stability of the solution?

I give the stability a nine out of ten.

What do I think about the scalability of the solution?

The solution is scalable.

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

I previously used Dell EMC RecoverPoint. Oracle Data Guard is more native to the database, so it will have better features, better flexibility, and be easy to operate or activate in terms of disaster. The solution has also reduced the traffic of the network. EMC RecoverPoint used too much data to be transferred, but with Oracle Data Guard less data will be transferred.

How was the initial setup?

The initial setup is complex. I give the setup a two out of ten.

We tested internally and then configured the Oracle Data Guard according to the procedures we found from the published Oracle site. We then deployed the solution. The deployment takes around four months and requires three people.

What about the implementation team?

We use the experts who are there for the provisioning of the Cloud infrastructure, but most of the implementation is completed by our technical team.

What was our ROI?

We have seen a return on investment because the solution is available almost instantly, making it a worthwhile investment.

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

There is no set cost for the solution. The cost of the Oracle license will depend on the negotiations with Oracle. The license is costly compared with other database systems.

The license includes primary support, patches, and technical support.

Which other solutions did I evaluate?

We evaluated CloudEndure but it did not meet our requirements.

What other advice do I have?

I give the solution a nine out of ten.

The maintenance is completed in-house but is rarely required. We monitor the solution with the help of our operation team.

Oracle Data Guard can allow us to enhance our system by making each of our databases, primary and standby, usable at the same time. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Adriano-Simao - PeerSpot reviewer
Chief Technology Officer at Triana Business Solutions Lda
Real User
Top 20Leaderboard
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.
PeerSpot user
Buyer's Guide
Oracle Data Guard
February 2025
Learn what your peers think about Oracle Data Guard. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
839,319 professionals have used our research since 2012.
reviewer998298 - PeerSpot reviewer
Will only provide via email at a consumer goods company with 10,001+ employees
Real User
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.
PeerSpot user
it_user515316 - PeerSpot reviewer
Director of Technical Operations - Storage, Databases & Business Intelligence at a transportation company with 10,001+ employees
Vendor
Provides online replication.

What is most valuable?

This is one of the most stable products to support critical DR sites.

How has it helped my organization?

It provides us with online replication.

What needs improvement?

I would like to see replication/fail-over sites.

For how long have I used the solution?

We have been using this for over five years.

What was my experience with deployment of the solution?

There were not many deployment issues.

What do I think about the stability of the solution?

There were not many stability issues.

What do I think about the scalability of the solution?

We sometimes had scalability issues with read only.

How are customer service and technical support?

Customer Service:

I would give customer service a rating of 8/10.

Technical Support:

I would give technical support a rating of 7/10.

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

There were no previous solutions.

How was the initial setup?

It was a self-driven setup. It was not too much trouble.

What about the implementation team?

We implemented in-house.

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

We are under ULA.

Which other solutions did I evaluate?

We did not evaluate many other solutions.

What other advice do I have?

It simply works.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Database and Infrastructure Architect at MNG Kargo
Real User
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.
PeerSpot user
Claudio Augusto Rosa David - PeerSpot reviewer
Specialist Database Management at Claranet
MSP
Top 5
A scalable solution with high deployment costs
Pros and Cons
  • "Oracle Data Guard is scalable. I rate it a ten out of ten."
  • "The deployment cost is expensive."

What needs improvement?

The deployment cost is expensive. 

For how long have I used the solution?

I have been using the product for ten years. 

What do I think about the scalability of the solution?

Oracle Data Guard is scalable. I rate it a ten out of ten. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer2316501 - PeerSpot reviewer
Oracle DBA Section Head at a security firm with 11-50 employees
Real User
Top 5Leaderboard
A stable disaster recovery solution that helps during a crisis in the primary database
Pros and Cons
  • "Oracle Data Guard has a nice feature called the DataGuard snapshot to open the solution in the read-write mode and make some changes to the database."
  • "Sometimes, the technical support team takes time to respond."

What is our primary use case?

I use Oracle Data Guard as a DR (disaster recovery) solution. Usually, I use the free license Data Guard, which is called the physical Data Guard.

What is most valuable?

Oracle Data Guard has a nice feature called the DataGuard snapshot to open the solution in the read-write mode and make some changes to the database. When you finish your work, you can do a rollback to the point that you started the snapshot and continue working.

What needs improvement?

Sometimes, the technical support team takes time to respond.

For how long have I used the solution?

I have been using Oracle Data Guard for ten years.

What do I think about the stability of the solution?

I rate Oracle Data Guard a nine out of ten for stability.

What do I think about the scalability of the solution?

I rate Oracle Data Guard a nine out of ten for scalability.

How are customer service and support?

Sometimes, the technical support team responds quickly; other times, they take time to respond. Usually, the first response or action from the Oracle site on my service request is rapid.

How was the initial setup?

The solution’s initial setup is straightforward.

What about the implementation team?

The solution's deployment time may vary according to factors like the database, storage, size, network facilities, and security. On average, the deployment takes three days.

What other advice do I have?

Oracle Data Guard provides DR and acts as a high-availability solution in case of a crisis in the primary database.

Overall, I rate Oracle Data Guard a nine out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer929742 - PeerSpot reviewer
System support engineer at a financial services firm with 1,001-5,000 employees
Real User
Reliable solution with real-time replication
Pros and Cons
  • "One of the most valuable features is real-time replication. The version we're using is reliable and easy to deploy."
  • "Oracle could be improved by the ability to manage it on the cloud. This on-premises version is secure and reliable, but I'm sure that they will soon provide a cloud solution that will be even better. In one to two years, we will probably move to the cloud—we have already moved to the cloud with Microsoft Exchange, but our databases are still on-premises. I would prefer managing a cloud version of Oracle."

What is our primary use case?

My primary use case is to cache our monthly data and ensure that same data is copied for DR (disaster recovery) side. This solution is deployed on-premises. 

What is most valuable?

One of the most valuable features is real-time replication. The version we're using is reliable and easy to deploy.

What needs improvement?

Oracle could be improved by the ability to manage it on the cloud. This on-premises version is secure and reliable, but I'm sure that they will soon provide a cloud solution that will be even better. In one to two years, we will probably move to the cloud—we have already moved to the cloud with Microsoft Exchange, but our databases are still on-premises. I would prefer managing a cloud version of Oracle.

For how long have I used the solution?

I have been using Data Guard for about five years. 

What do I think about the stability of the solution?

This is a stable solution. We have one person who is responsible for maintaining and working on the database. 

What do I think about the scalability of the solution?

In our organization, we have over thirty to forty people using Oracle ERP solutions. 

How are customer service and support?

We have Oracle's Extended Support. Whenever an issue arises, we log in to the portal and our queries are resolved with the help of Oracle's technical support. The support could be better, but we are still using the support offering of our old version of Oracle and the legal portion normally suggests an early upgrade to the newer release. 

How was the initial setup?

The installation is straightforward. It's not complex at all, and our IT guy managed it easily. 

What about the implementation team?

We implemented through an in-house team. 

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

We work for a non-profit organization, so we have a discounted rate on licensing and other purchasing agreements. 

What other advice do I have?

I rate this solution a nine out of ten. We are currently running version 11g, but we are planning on upgrading to 12c. I always recommend Oracle Data Guard for anyone considering implementing it in their organization. 

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.
PeerSpot user
Buyer's Guide
Download our free Oracle Data Guard Report and get advice and tips from experienced pros sharing their opinions.
Updated: February 2025
Product Categories
Backup and Recovery
Buyer's Guide
Download our free Oracle Data Guard Report and get advice and tips from experienced pros sharing their opinions.