No more typing reviews! Try our Samantha, our new voice AI agent.
PeerSpot user
Manager Database Administration at a financial services firm with 5,001-10,000 employees
Vendor
Jul 5, 2016
Logical standby database is a handy feature for reporting purposes.
Pros and Cons
  • "Active Data Guard has helped us a lot in achieving the real time reporting by offloading our heavy reports from Production to Standby database."
  • "Limited functionality to exclude any schema/table from replication would be helpful."

What is most valuable?

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.

How has it helped 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. 

What needs 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
Claudio Augusto Rosa David - PeerSpot reviewer
Specialist Database Management at Claranet
MSP
Dec 23, 2023
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: October 2026
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.