- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Difference between oracle golden gate and oracle active guard in the oracle
Oracle golden gate and oracle active data guard is the data replication technologies. They both are used for data replication but with different strategy.
As per the oracle docs −
Oracle Active Data Guard provides the best data protection and availability for Oracle Database in the simplest most economical manner by maintaining an exact physical replica of the production copy at a remote location that is open read-only while replication is active.
GoldenGate is an advanced logical replication product that supports multi-master replication, hub and spoke deployment and data transformation, providing customers very flexible options to address the complete range of replication requirements. GoldenGate also supports replication between a broad range of heterogeneous hardware platforms and database management systems.
| Sr. No. | Key | Oracle Golden Gate | Oracle Data Guard |
|---|---|---|---|
1 | Basic | Data replication can be happened only heterogeneous database platforms | Data replication can be happened only homogeneous database platforms |
2 | Data Replication | It supports multimaster and bidirectional support | one-way replication of a complete Oracle Database |
3 | Restriction | It does not support data types such as XML and blob. | No Restriction |
4 | Transparency of backups | Only DATA which are replicated are similar to each other. It does not have transparency of backup | An Oracle Data Guard ,primary and standby are physically exact copies of each other. |
5 | Performance | No performance implication | It has performance issue, if table does not has primary key |
- Related Articles
- Difference between Oracle 11g and Oracle 12c
- Difference between Oracle and SQL Server
- Difference between logical and physical standby database in the oracle
- Oracle Bones
- Cursors in Oracle DBMS
- Functions in Oracle DBMS
- Attach data from SAP system using Oracle Web Logic and Oracle Enterprise Service Bus
- Overview of Packages in Oracle
- Oracle Database Connection in Python
- How to PIVOT results in Oracle?
- How to UNPIVOT results in Oracle?
- How to find and replace text in Oracle?
- How to insert and retrieve dates in Oracle ?
- How to change the JOIN order in Oracle?
- How to change the JOIN Method in Oracle ?
