Detailed description of the main components of ORACLE GOLDENGATE

ORACLE GOLDENGATEThe main component of is what we will introduce in this article. Let's take a look at it.

1. EXTRACT

It is mainly responsible for capturing data from the online logfile of source db, or you can configure to capture data only from archive log. according to the principles of relational data, most database products have transaction logs. especially when captured from the onliene logfile, it may bring some performance response, because the read operation on the online logfile may conflict with the LOGFILE read/write process on the DB, try to use a faster disk instead of RAID5.

2. TRAIL File

After the EXTRACT captures data, it is written to the local trail file. It is generally stored in the $ GGSCI/DIRDAT directory. The TRAIL can be divided into LOCAL and RMT. RMT, which are mainly on target db.

3. DATA PUMP

Reads the local trail on the source db and sends it to the rmt trail on the target db. you can also directly send data pump to the target rmt by EXTRACT without configuring data pump. we recommend that you configure data pump as much as possible, so that you can filter, convert, and map DATA at the data pump level. in addition, the transaction loss caused by the failure of EXTRACT to communicate with target db due to network interruptions can be avoided.

4. REPLICATE

Read the local trail and apply these transactions in the DB.

5. MGR

Only one process can be used. It is mainly responsible for RESTART and MONITOR other processes, receiving GGSCI commands and sending them to the corresponding COMPONENT, executing TRAIL management, recording running logs and alarms.

Here is an introduction to the main components of oracle goldengate. I hope this introduction will be helpful to you!