GGS_Sect_Config_WinUX_ORA_to_WinUX_MSQ.pdf

落枫0907

15页

0次

2022-09-23

100墨值下载

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.

During this lesson, you will learn how to:





 Prepare your environment to configure the GoldenGate processes





 Configure and execute the initial data load





 Configure and start the change capture of database operations





 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

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

<target> server

Target

Replicat

Collector

Trails

Manager

<source> server

Oracle

Source

Extract

Manager

Log

Network

GoldenGate for Oracle to MySQL

                                        

Page 2

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

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

processes may be configured and started. And finally, source definitions are generated and

transfered to the target system.

Initial Data Load

To initially load data across heterogeneous databases, GoldenGate provides the ability to

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

captured change data into the target database.

Prerequisites

The prerequisites for this lab include the following.



GoldenGate installed in both the source

and the target

<install

location>.

 The MySQL

defined in the target environment.

<source> server

Oracle

<target> server

Target

Source

Network

Initial

Extract

Initial

Replicat

of 15

100墨值下载

ggs msq

关注

评论