Oracle_GoldenGate_官方学习文档.pdf

漫步者

15页

1次

2025-02-27

5墨值下载

Oracle GoldenGate for Oracle to Oracle

                                        

Page 1

Oracle GoldenGate for Oracle to Oracle

Objective

Upon completion of this lesson, you will be able to keep two Oracle databases synchronized.

During this lesson, you will:

 Prepare the database and the Oracle GoldenGate environment.

 Configure and execute the initial data load process

 Configure and start the change capture of database operations.

 Configure and start the change delivery process.

Oracle to Oracle configuration

The following diagram illustrates Oracle GoldenGate installed on two systems connected by

TCP/IP – one containing the source data and the other the replicated data.

Overview of tasks

Prepare the Environment

In order to execute this lesson, the GoldenGate application must be installed on both the

source and target systems. The installation includes a sample database and scripts to generate

initial data as well as subsequent update operations. The source and target tables are created

<source> server

Oracle

<target> server

Oracle

Target

Source

Network

Extract

Replicat

Collector

Trails

Manager Manager

Log

Oracle GoldenGate for Oracle to Oracle

                                        

Page 2

and loaded with initial data. The GoldenGate Manager processes are also started so that other

processes may be configured and started.

Configure Initial Data Load

To initially load data, there are techniques such as Backup/Restore or Export/Import, both of

which have pros and cons. Or you may use the GoldenGate application to perform your initial

data load while the application remains active. This lesson demonstrates using Extract to pull

data from the source tables and sending the data directly to the Replicat on the target system.

Configure Change Capture

For log-based Oracle capture, the capture process is configured to capture change data

directly from the Oracle online redo logs or archive logs and store the changes in queues

known as GoldenGate remote trails.

Configure Change Delivery

Once the tables have been initially loaded with data, the delivery process is configured to

deliver the captured change data into the target database.

<source> server

Oracle

<target> server

Oracle

Target

Source

Network

Initial

Extract

Initial

Replicat

of 15

5墨值下载

goldengate

关注

评论