Home / Installation/Configurations10g / Comparison Between Oracle GoldenGate and DataGuard

Comparison Between Oracle GoldenGate and DataGuard

Comparison Between Oracle GoldenGate and DataGuard

Technical Points

Oracle Dataguard / Active Dataguard

Oracle Golden Gate

Operating System Primary Database and Standby Database Should be same. (But 11g Onwards it supports Heteregenous Data Guard Configurations.                       Example : We can imeplement Oracle Data Guard between Oracle Linux server 6.2 (x86_64)  and Microsoft Windows 2008 Server R2 (x64) Primary Database and Standby Database need not be same.
Database Should be Oracle Database in both Source and Target. Database can be different in Source and Target. Example :Source database can be Oracle and Target database can be MY SQL/MS SQL server.
Database Version Primary Database and Standby Database Should be same. Primary Database and Standby Database need not be same. (Including Database Software).
Replication method Data movement will be in-form of Log Files. It moves Data Transaction wise through Extract and Replicat process from Source to Target, when commits.
Database mode Source: Read write mode
Target:  Recovery Mode / Open Read Only.
Source: Read write mode
Target:  Read write mode
Replication Type Unidirectional. (Data movement will happen in single direction). Multi-Directional.
Integrated Feature No additional software to install. Oracle Data Guard /Active Data Guard includes in Enterprise Edition. Oracle GoldenGate software to install in Source as well as Target.
License Cost No additional license required for Oracle Data Guard to install. Oracle Active Data Guard is an enterprise option with Oracle Enterprise Edition. Oracle GoldenGate Software Licence required in Source and Target Databases.
Database Edition Source: Oracle Enterprise Edition
Target: Oracle Enterprise Edition.
Source: Can be Oracle Enterprise Edition/Oracle Standard Edition/Oracle Standard Edition One
Target:  Oracle Enterprise Edition/Oracle Standard Edition/Oracle Standard Edition One

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

OracleDBconcept

Tablespace Level Fragmentation

Tablespace Level Fragmentation in Oracle Database Introduction In this article, I will discuss tablespace level …

Leave a Reply