When do I use Oracle GoldenGate?
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:- Any requirement where the replica database must be open read-write while synchronizing with the primary database
- Any advanced replication requirements such as: multimaster and bidirectional replication, subset replication, many to one replication, cross endian replication, and data transformations
- Maintenance and migrations where zero downtime using bi-directional replication is required
- Application upgrades that modify back-end database objects. GoldenGate maintains availability and reduces planned downtime by replicating between old and new versions of the database (the user implements mapping between differences in database objects in old and new versions of the database
- Any cross platform migration not supported by Data Guard (e.g. cross endian platform migration)
- Any replication requirement where you replicate from a more recent version of Oracle Database to an earlier version of Oracle Database (e.g. from Oracle Database 11g to Oracle Database 10g)
More Links :
No comments:
Post a Comment