Try our new research platform with insights from 80,000+ expert users
it_user719811 - PeerSpot reviewer
Tech Lead Oracle DBA / SME
Vendor
A simple replication solution for small businesses

What is most valuable?

The Active Data Guard and Fast-Start Failover features are excellent. The Active Data Guard helps in providing read only data for reporting purposes. The Fast-Start Failover is an automatic feature that allows failover from primary database instance/server to the preferred standby instance/server.

How has it helped my organization?

I've implemented these features in several projects.

What needs improvement?

Oracle Data Guard is part of the Oracle Database Enterprise Edition. Oracle Corporation has provided features in Data Guard for its new Database version Oracle 12c.

For how long have I used the solution?

I've used Oracle Data Guard for over eight years.

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

What do I think about the stability of the solution?

Yes, If the underlying Network is not stable, then the Data Guard and Standby Databases will disconnect and not be operational.

What do I think about the scalability of the solution?

No.

How are customer service and support?

Oracle Support is rated an eight out of 10.

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

If the Database SLA is much higher than Oracle RAC, it is a better product than Data Guard.

How was the initial setup?

The initial setup was simple, but there were problems setting up the connectivity between the different servers. Once these problems are resolved, then the Data Guard was operational.

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

The Oracle Data Guard is part of the Oracle Database Enterprise Edition, there is no extra licensing cost for the software. However, there is a hardware cost for the number of Standby Databases for each server and storage.

Which other solutions did I evaluate?

The only other product is Oracle RAC which is very expensive for small businesses as it involves software for clustering, hardware for networking and larger SAN environments.

What other advice do I have?

It's a simple replication solution for small businesses.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user515112 - PeerSpot reviewer
Oracle DBA at a transportation company with 1,001-5,000 employees
Real User
Provides an active data guard.

What is most valuable?

Provides an active data guard.

What needs improvement?

I would like to see better failover.

For how long have I used the solution?

We have been using this solution for five years.

What do I think about the scalability of the solution?

There were no scalability issues.

How are customer service and technical support?

Customer Service:

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

Technical Support:

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

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

We did not evaluate another solution.

What about the implementation team?

We did not implement through a vendor team.

Which other solutions did I evaluate?

We did not evaluate other options.

Disclosure: My company has a business relationship with this vendor other than being a customer:
PeerSpot user
Buyer's Guide
Oracle Data Guard
May 2025
Learn what your peers think about Oracle Data Guard. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,028 professionals have used our research since 2012.
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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user436194 - PeerSpot reviewer
Business Analyst at a tech company with 1,001-5,000 employees
Real User
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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Rita Nuñez - PeerSpot reviewer
Rita NuñezCEO at Tecnix Solutions
Real User

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.

PeerSpot user
Manager Database Administration at a financial services firm with 5,001-10,000 employees
Vendor
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: My company does not have a business relationship with this vendor other than being a customer.
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: My company does not have a business relationship with this vendor other than being a customer.
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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Download our free Oracle Data Guard Report and get advice and tips from experienced pros sharing their opinions.
Updated: May 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.