Oracle GoldenGate Quick Start Tutorial: Basic Concepts and configurations

Oracle GoldenGate Quick Start Tutorial: Basic Concepts and configurations

1. Introduction to GoldenGate

Oracle Golden Gate is a log-based copy and backup software for structured data. It parses online logs of the source database or archive logs to obtain incremental data changes, apply these changes to the target database to synchronize the source database with the target database. Oracle Golden Gate can implement Sub-second-level real-time replication of large amounts of data between heterogeneous IT infrastructure (including almost all common operating system platforms and database platforms, in this way, in the emergency system, online reports, real-time data warehouse supply, Transaction Tracking, data synchronization, centralized/distribution, Disaster Tolerance, data warehouse upgrade and transplantation, dual-business center, and more application in different scenarios. At the same time, Oracle Golden Gate can implement one-to-one, broadcast (one-to-multiple), aggregation (Multiple-to-one), bidirectional, point-to-point, cascading, and other flexible topology structures.

Management OGG-HA in RAC Environment

Configure OGG synchronization in RAC Environment

GoldenGate unidirectional table DML Synchronization

Oracle GoldenGate series: restoration principles of Extract processes

Oracle GoldenGate installation Configuration

OGG-01004 OGG-1296 error for Oracle goldengate

Ii. Technical Structure

Like traditional logical replication, Oracle GoldenGate extracts the source redo log or archive log, and then delivers it to the target end through TCP/IP, finally, the application is parsed and restored to the target end, so that the target end can synchronize the number of same-source ends. The following is the technical architecture of OracleGoldenGate.

3. OGG Process

1. Manager 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.

2. Extract Process

Extract runs on the database source and is responsible for capturing data from the source data table or log.

3. Pump Process

The pump process runs on the database source.

If the source end uses a local trail file, the pump process will send the trail to the target end in the form of data blocks through the TCP/IP protocol, this is usually recommended. The pump process is essentially a special form of the extract process. If you do not use the trails file, the extract process will be directly delivered to the target end after data is extracted.

4. 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 the 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.

5. Replicat Process

The Replicat process is also called an application process. Running on the target end is the last station for data transmission. It is responsible for reading the content in the target end's trail file, parsing it as DML or DDL statements, and then applying it to the target database.

6. GGSCI

GGSCI is the abbreviation of GoldenGate Software Command Interface,

It provides a wealth of commands to perform various operations on Goldengate, such as creating, modifying, and monitoring the GoldenGate process.

3. Application expansion structure, support platform, and database

For more details, please continue to read the highlights on the next page:

1 2 3 Next Page