The configuration of Oracle GoldenGate / Data Guard has the purpose of synchronizing data between two or more systems .
The basic features of the two products may look similar but takes GoldenGate uses replication while dataguard not.
Oracle Data Guard and GoldenGate involving at least two systems where transactional data from one database is required to be moved to another database. The purpose of the replication of data can be disaster recovery, migration of data or preparation of a secondary system.
Data Guard is best for disaster recovery and data protection problems, GoldenGate is a more flexible heterogeneous replication mechanism and is also able to transform the data while it is being replicated.
- Data Guard is an Oracle specific technology while GoldenGate support heterogeneous database systems including all the major RDBMS as DB2,Sybase, MySQL .
- Data Guard supports active-passive replication. One of the database is the primary database and the other one is in an inactive Data Guard mode.
- GoldenGate supports an active-active replication mode and allows both systems to work simultaneously while maintaining the data integrity.
- GoldenGate allows transformation of the data, with conflict management while it is being replicated between both database systems.
- GoldenGate allows replication across platform. Data can be extracted from a Unix platform and replicated to an Oracle database running on platform Windows.
- GoldenGate has many case of utilization. The use of flat files for data transportation and the support of heterogeneous systems makes the technology so very interesting
GoldenGate is the best solution:
- Replicate one or many tables to a read-write database.
- Replicate and transform tables.
- Bi-directional replication.
- Zero or near-zero downtime upgrade.
- Heterogeneous replication
GoldenGate replication.
• Zero Downtime Upgrade/Migration: You may want to setup an exact replica of your database for upgrade or migration, keep the data in sync till the last moment.
• High Availability: Your applications cannot afford to have downtime so you want to have two databases up and running at the same time to support those applications.
• Query or Reporting: You want to offload the reporting or long query operations from your production database.
• Real Time BI: For your data warehouse requirements.
• Data Synchronization: You want to Synchronize data across different departments of the company (different databases).
Furthermore the GoldenGate software supports extraction from the legacy systems and does not have any limitation on the distance either. Additionally, the trail files generated by GoldenGate capture can also be compressed and encrypted.
Oracle Data Guard
Used for
- High availability
- Data protection
- Disaster recovery
- Primary database workload reduction
Database roles
Primary database
Standby databases
Physical and logical standby databases
Cascading standby database
SQL*Plus
Role of redo
Data Guard basically works as follows:
- Archived redo log files from the production DB are copied to the standby DB.
- They are then registered with the standby DB.
- Finally, using media recovery, the redo is used to roll forward the standby database.
Preventing physical errors
Changing roles of databases
The role (primary vs standby) of a database can be changed by either a
- switch over or
- a fail-over
RAC
Active Data Guard
Data protection modes
These protection modes are:
- Maximum performance (default)
- Maximum protection
- Maximum availability
Automatic gap detection
Catch Me On:- Hariprasath Rajaram Telegram:https://t.me/joinchat/I_f4DkeGfZuxgMIoJSpQZg LinkedIn:https://www.linkedin.com/in/hariprasathdba Facebook:https://www.facebook.com/HariPrasathdba FB Group:https://www.facebook.com/groups/894402327369506/ FB Page: https://www.facebook.com/dbahariprasath/? Twitter: https://twitter.com/hariprasathdba