Common Methods for adding GoldenGate extraction processes

Common Methods for adding GoldenGate extraction processes

The OGG configuration is very flexible. Each component has multiple configuration methods and can be prepared as needed. The following lists several common ways to add extraction processes.

To facilitate reading, the extraction group is named ex1, and the process is responsible for extracting changes from the transaction logs of the source database.

1. EXTRACT from the end of the add extract command.

Add extract ex1, TRANLOG, BEGIN NOW

2. The source database has three RAC nodes. Each tread corresponds to an extraction process. Note that the threads parameter is followed by the number of nodes.

Add extract ex1, TRANLOG, begin now, THREADS 3

3. Extract records generated from the beginning and after on January 1, October 1, 2014. This time is one month ago, And the redo log buffer is no longer in the redo logfile. The extraction process searches for archivelog.

Add extract ex1, TRANLOG, BEGIN

4. Create an integrated capture extraction group

Add extract finance, integrated tranlog, BEGIN NOW

Note: The Oracle Goldengate 11g version introduces the Integrated Capture Mode. This method is implemented by the log mining tool in the database and is not directly extracted from redo. The main benefits of this change are in compatibility.

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

Oracle GoldenGate Quick Start Tutorial: Basic Concepts and configurations