|GoldenGate Replicatie Hub - Remote Capture and Delivery|
Oracle GoldenGate Remote Capture and Delivery Support Overview
GoldenGate Replicate Hub or GoldenGate Remote Capture and Delivery deployment allows us to offload the GoldenGate processes from the source and target databases servers. The Remote Capture and Delivery process uses the SQL*Net for connection to the source and target database. The GoldenGate Manager, the Capture and Delivery processes runs on the GoldenGate Replicate Hub including the maintenance of the trail and other goldengate files in the Goldengate file-structure on the GoldenGate server. The GoldenGate capture process uses the Logmining server at the source database to mine the redo logs. The GoldenGate Replicate Hub Capture process does not offload the source database for log mining like the GoldenGate Downstream deployment does.
Hereby a summary what is supported by Oracle GoldenGate
- What is Supported
- As of 12.1.2.+ version, the following Oracle GoldenGate packages support remote capture and delivery:
- Oracle GoldenGate for Oracle DB (capture/delivery)
- Oracle GoldenGate for MySQL (delivery)
- Oracle GoldenGate for DB2 LUW (capture/delivery)
- Oracle GoldenGate for Informix (capture/delivery)
- Oracle GoldenGate for Big Data (delivery)
- Oracle GoldenGate for Teradata (delivery)
- Oracle GoldenGate for iSeries (delivery)
- Oracle GoldenGate for SQL Server (delivery)
- Oracle GoldenGate for JMS (capture/delivery)
- GoldenGate NOT support remote capture.
- Oracle GoldenGate for DB2 z/OS
- DB2 iSeries
- SQL Server
- To run remote capture/delivery, different databases use different approaches.
- Oracle GoldenGate for Oracle DB
You can perform remote capture with the following two methods:
- Integrated Capture with SQL*Net connection
- Downstream capture in either real-time or archive log mode.
For downstream data capture mode, you need to setup Oracle Data Guard redo log files shipment to the downstream database [link]. It's required the source database to be 10.2.0.4+ and the downstream database to be 188.8.131.52.0+.
With DB2 connect, user can setup the remote DB2 as if they are an local database instance. Oracle GoldenGate then can capture from the remote DB2 database via the local accessing point setup by the DB2 connect.
You can setup the ODBC connection to access the informix database on the remote server Oracle GoldenGate machine for access. The followings requirements need to be met: Endian order of both the systems should be same and the second is the bit width (32bit or 64bit) has to be same. For example from Linux to Linux, Windows to Windows, Solaris to Solaris but not across.
For Oracle GoldenGate to delivery to MySQL database remotely, you just need to use the TARGETDB to specify the target database connection with the username and password. The MySQL user should have the remote access privileges.
- References GoldenGate Remote Capture and Delivery
Technical Questions to Ask Before Choosing setup the Remote Capture and Delivery
What should you ask yourself before implementing a Goldengate Remote capture and delivery architecture or GoldenGate Replicate Hub
Questions to ask and validate for implementing GoldenGate Remote Capture and Delivery
- Does Oracle GoldenGate support the remote capture and delivery for the source and target databases?
- Validate the Remote capture and delivery Matrix for Source and Target database types/versions
- Which Goldengate Version can handle remote capture or delivery processes
- Answer should be => Yes
- Oracle remote capture and delivery is general 15-20 slower than a nativeGoldengate implementation, because of network communications
- Answer should be => No
- The server running Oracle GoldenGate and the server running the database or database server have to have the same Endiannes
- Answer should be => Yes
How to Configure Remote Capture and Delivery for Oracle Database
The implementation og Remote GoldeGate capture and delivery process does not change from the steps of Native Goldengate implementation. The only thing that is different, Goldengate is not installed on a Database server.
- Configure the OGG server hub for installing the Goldengate binaries
- Setup a SQL*Net on the OGG Replicate server Hub
- Source DB SQL*Net
source_db = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sourcedb.joords.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = source_db) ) )
- Target DB SQL*Net
target_db = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = targetdb.joords.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = target_db) ) )
- Add Credential store
- Source alias
alter credentialstore add user source_db_admin@source_db password XXX alias oggadmin_source
alter credentialstore add user source_db_admin@target_db password XXX alias oggadmin_target
EXTRACT EXT01 useridalias oggadmin_source TranlogOptions IntegratedParams (max_sga_size 256) ExtTrail ./dirdat/in DiscardFile ./dirrpt/ext01.dsc, Append Megabytes 50 LOGALLSUPCOLS UPDATERECORDFORMAT COMPACT REPORTCOUNT EVERY 2 HOURS, RATE Table JOORDS_src.*;
REPLICAT REP01 useridalias oggadmin_target DBOPTIONS INTEGRATEDPARAMS (parallelism 6) DISCARDFILE ./dirrpt/REPIN.dsc, Purge REPORTCOUNT EVERY 5 records, RATE MAP JOORDS_src.*, TARGET JOORDS_trg.*;
The GoldenGate Replicate Hub is not a GoldenGate Downstream implementation.
- GoldenGate Downstream deployment allows you to offload the source database extract load to intermediate or target server. The source database ships its redo logs to a downstream database, and Extract uses the logmining server at the downstream database to mine the redo logs. A downstream mining database can accept both archived logs and online redo logs from a source database. On the Downstream server there is a Native GoldenGate operational.
- Oracle GoldenGate Remote Capture and Delivery Support Overview
- Configure GoldenGate Extract to read from remote logs
- Endianness and the Operating System 1
- Endianness and the Operating System 2
- Oracle GoldenGate Best Practices: Configuring Downstream Integrated Extract (Doc ID 1485620.1)
- Using Oracle GoldenGate Downstream Deployment for Oracle-to-Oracle Database Synchronization on Linux
- GoldenGate Downstream mining setup - uses NOREGISTER