Oracle Data Guard Reviews

The product is used for disaster recovery as well as being able to put in read only mode and run queries or reports on DR site. 

You can run reports or test scripts on standby and tune them without having to worry about affecting anything going on in productions. That way, you know exactly how the reports and queries will perform in production before installing it. 

You have the exact data and environment provided your standby is set up the same as your production database and server.  This also help gives you a better ROI on the DR site to.

We had some very intensive reports we used to run on prod and switched to using the standby site for the reports, which really helped our production run better for our loads. Developers can test their code thoroughly before installing it into production and know precisely how it will perform. It eliminates a lot of guesswork and issues. You can tune and ensure the result set is exactly what they expect and install the code one time instead of having to fix code on the fly or back out the code.

It is excellent as a data guard broker. You can see how the logs are applied, check the apply time, and how far behind the standby is at any given time. It can help you make sure all the parameters are set up correctly, much easier to switch over to the standby side and back to production without data loss. Also, you can put into snapshots a clone to do a quasi-DR test to make sure standby is set up with the application and everyone can connect. The app performs as expected before a DR happens.

Running reports and scripts from the standby side to tune in advance.

We would like to be able to see the date time stamp when you execute DGMGRL commands. In our recovery test, we have to include the timestamp when we start and end the switchover or snapshot tests, and it is difficult to do when the timestamp is not there when you run the commands. It is a very manual process to try to include the start and end time of each along with the screenshot of the DGMGRL screens.

We need to be able to run more SQL commands in DGMGRL.

We need to be able to automate commands and scripts better in DGMGRL.

I've used the solution for over ten years.

The solution has been very stable since version 11.2.

The solution is very scalable.

Check with Oracle to make sure you are using your products effectively.

We did look at other options. However, those we saw did not have as many features as Oracle ADG.

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.

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

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

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.

I have been using the solution for 15 years.

I give the stability a nine out of ten.

The solution is scalable.

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.

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.

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.

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

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.

We evaluated CloudEndure but it did not meet our requirements.

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. 

We have a couple of Oracle systems that are attached to different types of applications.
In terms of Data Guard, we use it for factory monitoring.

We like Oracle because the solution is very robust. It's also efficient for queries and is easy to scale.

The database administration needs improvement. With Oracle, we have a lot of features for administrating data, but it might be too many. It needs to be simplified. It should be automated. Looking at Enterprise Manager, there are too many KPIs in place. Directly on-site, we do not need to choose all of them. Administration, generally speaking, needs to be improved.

Oracle should also continue to simplify the upgrade using Data Guard. We have already seen reduced outage timing any time we are doing upgrade, so maybe they are heading in that direction, but it can always be improved.

The stability of the solution is good.

The scalability of the solution is good. We have roughly 1,000 users right now.

Technical support is very good. If at any time we write a ticket, we get the appropriate answer on time. 

The set is straightforward but it is dependent on the audience you have. Internally, we have experienced DBAs, so deploying Oracle is straightforward. If we had to do the same job for an external company it could be complex. 

Previously we were doing the set up ourselves. Now, for more than a decade, we work with a third party, and we delegate the deployment, the support, and the maintenance of the Oracle Database.

The pricing of Oracle is average. It's not inexpensive but it's okay.

Currently, we are using the on-premise version on the solution.

I would rate this solution eight out of ten. I would recommend the solution because it is a good product and it's working fine. But I'm not sure if it's suitable for every consideration or any environment.

We use it for application disaster recovery. It is deployed on-prem, and one side is our side, and the second side is Microsoft Azure.

Backup and application continuity are most valuable.

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.

Its support should also be improved.

I have been working with this solution for the last two years.

If one is most stable, I'd rate it a two out of five. We were facing some issues. It isn't something that you set up and then go to sleep for two years. We have to maintain it and tweak it several times, but it is still very good in terms of stability.

It is very scalable and reliable. 

I would rate it a two out of five. It is not very good. There are a lot of community guides, but Oracle documentation is not straightforward, specifically when you use one site as the cloud site and one site as your on-prem site. If one is the best, in the cloud arena, I would rate them a two out of five. There is some community support, and there is some Oracle support, but they still have room to improve.

It was complex. My DBA had a difficult time. If five represents the most complex, I would rate it a five out of five in terms of complexity. 

It required multiple experts. It required Microsoft support, our own system experts, and an external DBA to make the transition work. It took us two weeks to move from one Data Guard replication to another Data Guard replication.

It is not a cheap product, but if you look at the price, features, availability, scalability, and maturity, it is a very good product. 

Involve Oracle as early as you can and do a version upgrade to the latest DB version before you try to migrate to the cloud. First, do all the migrations that you need to do locally in your Oracle database, and only after that, do a cloud migration.

I would rate it an eight out of 10. It is quite reliable, but there are problems. It is not perfect. There is a monopoly of technology, and this is the only cost-sensitive product around. The other products are either very expensive or not reliable.

Data focus is the main issue. Most of the features of a new database still go to an Oracle administration section.

The monitor can predict if you have any issues or develop actions to find a solution for them.

We use the product for data recovery.

There is always room for improvement. This product needs some improvement in administration. I would love to see something that makes monitoring much easier. 

The product needs some of the GUI tools so there is no need for all the long process.

Oracle Data Guard is stable, but you need to keep monitoring the system all the time. You need to keep monitoring the archives. If some of the archives have been deleted, you need to do it manually. It is a lot of work pressure and a lot of monitoring. 

You need to do the dummy work every day just to ensure that Oracle Data Guard is working at the point when you need it.

Scalability with Oracle Data Guard is not straightforward, i.e. the configuration.

We use two different kinds in that case of data guard. You cannot keep looking at the overhead of the projection servers. Oracle Data Guard should know what you are doing. This is the problem. For migrations, it can be a long time.

For Oracle tech support, you do it yourself. When you open a ticket, it can take time to solve it. Often you can find a bug that went unreported.

The initial setup is straightforward. Just follow the documentation. For our present situation, it was dependent on the project and the database files. 

Sometimes the setup took one day, sometimes only one hour. It was depending on the size of the database. It could be very fast for me.

I did the implementation of Oracle Data Guard by myself.

Oracle Data Guard is a free solution. When you apply for Enterprise Manager, it comes for free with the solution. When you apply an enterprise solution to a database, you have to pay. It depends on the connotation of the project and what you need for the protocol.

Keep monitoring. This is the problem with the product. You have to keep monitoring the system all the time, just to avoid the interruption from the archive mode.

I am going to give Oracle Data Guard a seven out of ten. It still needs improvements. When you are doing the troubleshooting there are no monitoring tools. You have to keep watching the log all the time. Also, for the configuration, if you miss one of the backlogs, you have to re-issue again. Re-issuing is not easy. It's a long process to do it.

Oracle Data Guard ensures data protection and disaster recovery. The better way to configure Data Guard is by having an Oracle production database on one site as the primary database, and an Oracle standby database on another site. This solution provides high availability.

If you have a problem with your primary site and can't access your primary database, you can continue working with the database that you have as standby on the other site, by changing its role to primary.

Another valuable feature is the possibility of backing up the database from the standby database instead of the primary database, to avoid backup process overhead in the primary system.

Active Data Guard is other feature with advanced capabilities that extend basic Data Guard functionality. Some of the functions of Active Data Guard are: 

• Real Time Query - Offloads read-only workloads to an up-to-date standby database
• Automatic Block Repair - Automatically detects a block corruption and repairs it.

I think it would be great to have a graphical interface assistant (like DBCA, ASMCA, NETCA, etc.) for initial configuration, monitoring, configuring Oracle Data Guard Broker and all the Data Guard Broker commands, without needing Oracle Enterprise Manager Cloud Control installed.

There is no issue with primary database stability. Once Data Guard is configured, you don't have to change anything more in your primary database.

Oracle Data Guard is a feature available only in Oracle Database Enterprise Edition, and is available for extra cost.

Provides an active data guard.

I would like to see better failover.

We have been using this solution for five years.

There were no scalability issues.

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

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

We did not evaluate another solution.

We did not implement through a vendor team.

We did not evaluate other options.

We primarily use the solution to have the peer site and a copy of it available in our global data center.

The installation process is straightforward. 

The solution is stable and the performance is good. 

The solution can scale as needed. 

Recently we had a P1 case that we needed to raise. There were so many other problems that cropped out of it when we were trying to execute a fix. 

Overall, there are some operational issues that need to be dealt with. 

The solution should be more secure from a protection perspective. 

There may be some bugs in the solution right now. 

We've used the solution for eight to ten instances. It's been a few years. 

The performance and stability are great. It doesn't crash or freeze. I find it to be a reliable product. 

I would say that the solution is scalable. If a company needs to expand it, it can do so. 

We have about 3,000 users on the solution right now.

The initial setup is not overly difficult. It's not complex. It's very easy, very straightforward. 

I cannot recall the exact amount of time the actual deployment took. 

We have some engineers that can handle the setup process. We have eight or nine that can handle deployment or maintenance tasks. 

We pay a yearly licensing fee to Oracle. 

I also looked at MySQL as a potential option before choosing this solution. 

I'd rate the solution at a five out of ten. We've recently had some issues and aren't very satisfied with it right now. 

At this point, I would not recommend it to others. It might be too buggy for most people.