2019-06-06T08:18:00Z

What needs improvement with Oracle Data Guard?

Julia Miller - PeerSpot reviewer
  • 0
  • 6
PeerSpot user
20

20 Answers

Federico Bonifazi - PeerSpot reviewer
Real User
Top 10
2024-01-31T13:52:00Z
Jan 31, 2024

For Italian medium-sized companies, the main challenge lies in the cost associated with licenses. In certain situations, we cannot utilize Data Guard swiftly for executing specific queries or statements that require temporary data manipulation. This is because opening the Data Guard system involves serving the changes and rolling back, even though snapshot features are available. In such scenarios, when customers need to test new application features or in the event of system vulnerabilities, it might be preferable to operate Data Guard without resorting to snapshot or flashback functionalities, thereby avoiding the need to recreate the system or start from a backup. These challenges were encountered within a high-traffic environment.

Search for a product comparison
Azhagupandi Parthiban - PeerSpot reviewer
Real User
Top 5
2024-01-04T10:08:50Z
Jan 4, 2024

The only difficult part is the cost factor, licensing. Another area of improvement is support. Morever, Oracle's partner is not also doing good. For that, they should improve. Such enterprise features need a good partner. That is where Oracle Data Guard failed. They never had a good partner. I never found a good partner in India.

AA
Real User
Top 5Leaderboard
2023-11-29T14:15:57Z
Nov 29, 2023

Sometimes, the technical support team takes time to respond.

MK
Real User
Top 5Leaderboard
2023-11-02T11:35:35Z
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. Currently, the DR site is read-only. If we could make both the primary and DR sites read and write capable, it would be a game-changer. This means the DR site could actively contribute to data management, not just save it. This enhancement would make Data Guard more versatile and impactful for database operations.

SM
Real User
Top 5Leaderboard
2023-08-08T08:17:22Z
Aug 8, 2023

The product could improve its pricing.

AM
Real User
Top 20
2023-01-25T14:00:21Z
Jan 25, 2023

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.

Learn what your peers think about Oracle Data Guard. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
KD
User
Top 20
2022-07-08T17:51:00Z
Jul 8, 2022

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.

SrikanthS - PeerSpot reviewer
Real User
Top 5
2022-05-06T13:53:49Z
May 6, 2022

They may need to include the monitoring and the alerting part in Data Guard. In case there is a delay in the sync from the primary to the DR site, it is going against more than the expected RTO or the RPO, we should be able to get an alert or see it in the dashboard.

Oz Pozner - PeerSpot reviewer
Real User
2022-02-16T17:29:08Z
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. Its support should also be improved.

UF
Real User
2021-11-25T11:39:34Z
Nov 25, 2021

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.

AS
Real User
Top 5Leaderboard
2020-08-11T06:17:00Z
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.

MF
Real User
2020-05-05T06:08:00Z
May 5, 2020

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.

AE
Real User
2020-03-05T08:39:37Z
Mar 5, 2020

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.

MB
Real User
Top 10
2020-01-16T08:44:00Z
Jan 16, 2020

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.

MS
Real User
2019-12-04T05:40:00Z
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. 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.

MG
Real User
2019-10-22T04:42:00Z
Oct 22, 2019

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

it_user1123491 - PeerSpot reviewer
Real User
2019-08-22T05:49:00Z
Aug 22, 2019

Once you get used to it, you get to know what to do when certain things happen. However, for a person who's just jumping into it, the management of it and how to implement it probably would be something that could be improved upon. The GUI could be better.

HO
Real User
2019-07-30T10:41:00Z
Jul 30, 2019

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.

MS
Real User
2019-07-29T10:12:00Z
Jul 29, 2019

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.

OM
Consultant
2019-06-06T08:18:00Z
Jun 6, 2019

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 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.
Download Oracle Data Guard ReportRead more