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.
System support engineer at a financial services firm with 1,001-5,000 employees
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?
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.
Buyer's Guide
Oracle Data Guard
December 2024
Learn what your peers think about Oracle Data Guard. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,168 professionals have used our research since 2012.
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.
Will only provide via email at a consumer goods company with 10,001+ employees
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.
Buyer's Guide
Oracle Data Guard
December 2024
Learn what your peers think about Oracle Data Guard. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,168 professionals have used our research since 2012.
Oracle DBA Customer Capacity Leader at a tech services company with 10,001+ employees
Adds an extra layer of a high-availability platform and minimizes the application outages
Pros and Cons
- "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."
- "For every standby server you have, you must pay a licensing fee, which is the main disadvantage."
What is our primary use case?
The primary use of this solution is for the high availability. If the database or server crashes, the switches go over to the standby database becoming the primary database. We use Data Guard in order to have a high-availability solution and high-availability configuration in our data center.
How has it helped my organization?
Data Guard adds an extra layer of a high-availability platform. The database minimizes the outage of applications in case something goes wrong with the primary database, allowing us to resume activities, losing minimal time.
What is most valuable?
We chose this solution for the availability of the databases. Since we can't afford Oracle Grid, this is the best solution if you want something similar that's less expensive.
What needs improvement?
A disadvantage is that the available disk space must be doubled. This is because Data Guard is made of two databases, one primary and one as a standby running permanently. We must pay the Oracle license on the second server. For every standby server you have, you must pay a licensing fee, which is the main disadvantage.
For how long have I used the solution?
I have been using Oracle Data Guard for the past ten years.
What do I think about the stability of the solution?
The stability is quite stable and it's reliable. From time to time I have had some issues, where I get an error message saying that both databases stopped synchronizing for a while. It doesn't mean that the problem comes from Data Guard. The problem could come from other areas like the network, a slow network for example.
What do I think about the scalability of the solution?
I don't have an opinion about scalability. I have always followed the same kind of installation.
How are customer service and technical support?
There is no specific Data Guard support in place. You either pay for the support or for an Enterprise edition giving you support for features that are included in this edition of Oracle. If you don't pay then you don't get support.
I am satisfied with the support.
Which solution did I use previously and why did I switch?
Data Guard was already in place with this company.
How was the initial setup?
As far as the installation, you should have an understanding of Data Guard. I am experienced with it and didn't require the script for the whole configuration and connection. If you don't have experience with Data Guard, then you must read the installation and configuration instructions.
What about the implementation team?
I implemented this solution.
What's my experience with pricing, setup cost, and licensing?
This is the best solution if you want something similar that's less expensive than Oracle Grid. We pay once per year.
Which other solutions did I evaluate?
We use a cluster for some customers instead of Data Guard, but it is a different concept. However, it is more or less the same.
What other advice do I have?
They could enhance their GUI or they should have a cloud control tool. They should have Data Guard tools in order to troubleshoot whenever there is a problem. There isn't anything in place for the configuration. Everything has to be done manually within the standard guide in Data Guard-related commands. Having a GUI with Data Guard is something that would be appreciated.
I would rate this solution an eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Solution Architect, IT Consultant at Merdasco - Rayan Merdas Data Prosseccing
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.
Manager Database Administration at a financial services firm with 5,001-10,000 employees
Logical standby database is a handy feature for reporting purposes.
Valuable Features:
I have found its switchover functionality to be most useful using which you can perform disaster recovery within no time. Its feature of FAL is also pretty useful that helps to keep both sites (primary and standby) synchronized. Logical standby database is also a pretty handy feature for reporting purposes.
Improvements to My Organization:
Active Data Guard has helped us a lot in achieving the real time reporting by offloading our heavy reports from Production to Standby database.
Room for Improvement:
Limited functionality to exclude any schema/table from replication would be helpful.
Currently Data Guard replicates whatever DML operation is performed on primary database is replicated to standby database as it is. To improve it bit further, if Oracle can provide some kind of feature in which user can select any schema or 5-10 collection to tables in some schema that user doesn't want to replicate. Because this kind of feature is available in Oracle Golden Gate which a separate licensed product with a lot of features like that one that I mentioned for limited replication, heterogeneous replication, cross database replication.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
CTO at a financial services firm with 1,001-5,000 employees
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
Business Analyst at a tech company with 1,001-5,000 employees
We've experienced no issues with performance.
What is most valuable?
We use it for backing up our data, so from the standby instance.
What needs improvement?
Data Guard has been around for a very long time and a lot of big companies are using it. I don't see that it needs any improvement or anything like that. I think it's pretty solid.
For how long have I used the solution?
I've been using it for more than 15 years.
What do I think about the stability of the solution?
We've experienced no issues with performance.
How is customer service and technical support?
When you open up SR Oracle has a list of things which they ask for. Being an end customer, when we open SR, we give as much as information as we want and again the support person comes into the picture, and without reading what we have put through, they just has the same question over and over. What version, what product, all that kind of things, which is not at all fair.
What other advice do I have?
It’s the backbone. Nobody interacts with it, it's only the DBAs who use it I think. Once you set it up it's pretty much done. You don't deal with it on a daily basis.
Maybe not all products are up to the speed or like any product you take, there is space to improve. I think for our company, the way we use it, we are very happy with it and the end customer is very happy with it.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free Oracle Data Guard Report and get advice and tips from experienced pros
sharing their opinions.
Updated: December 2024
Product Categories
Backup and RecoveryPopular Comparisons
Veeam Data Platform
Commvault Cloud
Acronis Cyber Protect
Veritas NetBackup
Cohesity DataProtect
Dell PowerProtect Data Manager
Azure Backup
Dell Avamar
Dell NetWorker
IBM Spectrum Protect
Microsoft DPM
Veritas NetBackup Appliance
OpenText Data Protector
Buyer's Guide
Download our free Oracle Data Guard Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- When evaluating backup and recovery software, what aspect do you think is the most important to look for?
- Veeam vs. Dell AppAssure vs. ShadowProtect
- Help! Need an opensource backup solution to work with OVM, Linux, Windows, Sql server, Exchange, Sharepoint. Plus bare metal recovery.
- What will be the best strategy for develop a up to date BCRS?
- CommVault vs. EMC NetWorker vs. Dell vRanger
- Should I get a third-party backup solution for Office 365?
- What is the best next generation backup tool?
- Best backup for 100Gbps+ read and write with hardware encryption?
- Major Differences Between These 4 Backup and Disaster Recovery Solutions?
- Do you have an RFP template for Backup Solutions which you can share?
I agree with you, it never degrades performance in the Primary Database, quite the contrary, it downloads the load that generates backups because it is done from the standby.