GoldenGate Oracle同步到Mysql配置手册

GoldenGate for Oracle to MySQL

                                        

Page 1

GoldenGate for Oracle to MySQL

Objective

Upon completion of this lesson, you will be able to keep two heterogeneous databases

synchronized, in this case Oracle to MySQL.







 Configure and start the change delivery of database operations

Oracle to MySQL configuration

The following diagram illustrates GoldenGate a configuration with Oracle source data being

replicated to a MySQL target database.

Overview of Tasks

Prepare the Environment

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

GoldenGate for Oracle to MySQL

                                        

Page 2

perform initial data synchronization while your application remains active. This lesson

demonstrates using Extract to pull data from the source files and send it directly to 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 Replicat is configured to deliver the

<source> server

Network

Initial

Extract

Prepare the Environment

                                        

Page 3

The goals of this exercise are to:





 Configure and start the Manager processes





 Create and load practice data to Oracle tables





 Add supplemental logging

Prepare your Oracle source environment

1. Configure the Manager process on the source

On the

system, create the Manager parameter file and specify the port it should use.

PORT <port>

GGSCI> START MGR

GGSCI> INFO MGR

2. Create the source tables and load the initial data.

Using

SQL

and

Execute the following commands on the

Shell> cd <install location>