GoldenGate (OGG for short) provides real-time capturing, conversion, and delivery of transaction data in heterogeneous environments.
Golden Gate (OGG for short) provides real-time capturing, conversion, and delivery of transaction data in heterogeneous environments.
Golden Gate (OGG for short) provides real-time capturing, conversion, and delivery of transaction data in heterogeneous environments.
OGG supports the following heterogeneous environments:
OGG features:
Small impact on the production system: reads transaction logs in real time to replicate large transaction volumes in real time with low resource usage
Copies data in transaction units to ensure transaction consistency: only submitted data is synchronized.
High Performance
Flexible topology: one-to-one, one-to-multiple, multiple-to-one, multiple-to-many, and bidirectional replication are supported.
Supports data filtering and conversion
You can customize filtering rules based on tables and rows.
Flexible projection and transformation of real-time data can be performed.
Data Compression and encryption: reduces the bandwidth required for transmission and improves transmission security.
How OGG works:
OGG process:
The Manager process is the control process of GoldenGate and runs on the source and target ends. It is mainly used in the following aspects: Start, monitor, restart other Goldengate processes, report errors and events, allocate data storage space, and release threshold reports. There is only one manager process on the target and source end.
Extract runs on the database source and is responsible for capturing data from the source data table or log. The role of Extract can be divided into the following phases:
Initial loading phase: In the initial data loading phase, the Extract process extracts data directly from the data table at the source end.
Synchronization change capture phase: after the initial data synchronization is complete, the Extract process is responsible for capturing source data changes (DML and DDL)
About the OGG Trail file:
In order to deliver the database transaction information from the source end to the target end more effectively and securely. GoldenGate introduces the concept of a trail file. After extract extracts data, Goldengate converts the extracted transaction information to a file in GoldenGate proprietary format. Then, pump is responsible for shipping the source trail file to the target end, so such files exist at both ends of the source and target.
The purpose of the trail file is to prevent single point of failure (spof), persist transaction information, and use the checkpoint mechanism to record its read/write location. If a fault occurs, data can be retransmitted based on the position recorded by the checkpoint.
Oracle Tutorial: instance fault recovery
Installing Oracle 12C in Linux-6-64
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian
