Oracle Dataguard vs Oracle GoldenGate
|SNO||ORACLE DATAGUARD||ORACLE GOLDENGATE|
|1||Replication can configured Only between Oracle to Oracle||Heterogeneous Replication can be done independent of the Database Platforms.|
|2||Use Active Data Guard where emphasis
is on simplicity,
best data protection, data
availability and highest performance.
|Use Oracle GoldenGate when a replica database must be
open read-write while replication is active,
or for advanced replication requirements beyond
what is addressed by Active Data Guard
|3||Secure physical replication, standby database
is open read-only,
it is impossible to modify
standby data independent of
|Any requirement where the replica database must be
open read-write while synchronizing with the primary database
|4||Simplest, fastest, one-way replication
of a complete Oracle Database.
|Any advanced replication requirements such as:
multimaster and bidirectional replication, subset replication,
many to one replication, cross endian
replication, and data transformations.
|5||No requirements for supplemental logging
or performance implications for tables having
no primary key or unique index.
Little if any performance tuning
required at the standby database,
the default configuration handles most workloads.
|A Minimal Supplemental Log should be enabled. Some performance
Implications on the tables having no primary key or unique index.
|6||No restrictions – Oracle Data Guard Redo Apply
supports all Oracle features and transparently
replicates all data and storage types,
PL/SQL packages and DDL without special considerations
|Restrictions on support to DATATYPES like XML, BLOB etc.,|
|7||Transparency of backups – an Oracle Data Guard
primary and standby are physically exact copies of
each other, RMAN backups are completely interchangeable.
|Only DATA which are replicated are similar to each other. It does
not have transparency of backup.
|8||Minimize planned downtime and risk using
Data Guard standby. Standby first patching,
database rolling upgrades, and select platform migrations.
|Zero downtime for Maintenance and migrations,
but a Bi-Directional replication should be
Reducing planned downtime for various
planned maintenance activities not supported
by Data Guard such as cross-endian
or application upgrades etc.,
|9||A single command will convert a physical
standby database as a test system open read-write
(Snapshot Standby). A second command will convert it
back to a physical standby database and
resynchronize it with the primary.
|No such testing is required since both the
systems are in open read-write mode.
|10||Active Data Guard is a superset of Data Guard
capabilities included with Oracle Enterprise
Edition and can be purchased as the Active
Data Guard Option for Oracle Database Enterprise Edition.
It is also included with every Oracle GoldenGate license,
offering customers the ability to acquire the
complete set of advanced Oracle replication capabilities
with a single purchase.
Basic Data Guard functionality does not require
a separate license, it is included with
Oracle Enterprise Edition
|Need to purchase Oracle GoldenGate license for both Source
Machine and Target Machine. When buying license for GoldenGate
license, Active Dataguard is also included in it.