2019-07-29T10:12:00Z
it_user434868 - PeerSpot reviewer
Senior Director of Delivery at a tech services company with 51-200 employees
  • 0
  • 3

What needs improvement with Oracle Data Guard?

Please share with the community what you think needs improvement with Oracle Data Guard.

What are its weaknesses? What would you like to see changed in a future version?

13
PeerSpot user
13 Answers
KD
Senior Database Administrator at Argo Group
User
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.

Search for a product comparison
SrikanthS - PeerSpot reviewer
Senior Manager - Technical at Sify Technologies
Real User
Top 10
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
Head of Product - CloudHome at Bynet
Real User
Top 5
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
System support engineer at a financial services firm with 1,001-5,000 employees
Real User
Top 5Leaderboard
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.

Adriano-Simao - PeerSpot reviewer
IT System Integrator at a financial services firm
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.

Mehmet Cem Fenerci - PeerSpot reviewer
Database and Infrastructure Architect at MNG Kargo
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.

Learn what your peers think about Oracle Data Guard. Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
657,849 professionals have used our research since 2012.
AE
CTO at a financial services firm with 1,001-5,000 employees
Real User
Top 20
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.

Mahdi Bahmani - PeerSpot reviewer
Solution Architect, IT Consultant at Merdasco - Rayan Merdas Data Prosseccing
Real User
Top 5Leaderboard
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
Will only provide via email at a consumer goods company with 10,001+ employees
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
Manager at a tech services company with 10,001+ employees
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
Intersystem Manager at Interplast
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
Computer Engineer at Nestle
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
Oracle DBA Customer Capacity Leader at a tech services company with 10,001+ employees
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.

Related Questions
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot (formerly IT Central Station)
Jul 8, 2022
How do you or your organization use this solution? Please share with us so that your peers can learn from your experiences. Thank you!
2 out of 10 answers
MS
Oracle DBA Customer Capacity Leader at a tech services company with 10,001+ employees
Jul 29, 2019
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.
HO
Computer Engineer at Nestle
Jul 30, 2019
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.
it_user434868 - PeerSpot reviewer
Senior Director of Delivery at a tech services company with 51-200 employees
Jul 8, 2022
Hi Everyone, What do you like most about Oracle Data Guard? Thanks for sharing your thoughts with the community!
2 out of 13 answers
MS
Oracle DBA Customer Capacity Leader at a tech services company with 10,001+ employees
Jul 29, 2019
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.
HO
Computer Engineer at Nestle
Jul 30, 2019
Technical support is very good. If at any time we write a ticket, we get the appropriate answer on time.
Download Free Report
Download our free Oracle Data Guard Report and get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
DOWNLOAD NOW
657,849 professionals have used our research since 2012.