My Oracle Support Banner

How to Replicate Data Between Oracle and MySQL Database? (Doc ID 1605674.1)

Last updated on JANUARY 19, 2020

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.


 This note describes a set up of a GoldenGate replication between Oracle and MySQL


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Pre-requisites
 2. GoldenGate Manager
 3. GoldenGate demo tables
3.1 The demo tables for the Oracle database
 3.2 Creating the MySQL demo tables
 4. Oracle database pre-requisites
 4.1 Verify Oracle DB connection
 4.2 Add the TRANDATA
 5. GoldenGate initial load (no data pump process configured to keep it simple)

6. The SOURCEDEFS file
 6.1 DEFGEN parameter file
 6.2 Defgen command
 6.3 COPY DEFGEN file

7. MySQL initial load replicat process

8. Start Initial Load Extract process
 9. GoldenGate Extract for the Oracle database
 9.1 GoldenGate extract parameter file
9.2 Add GoldenGate extract
 9.3 start GoldenGate extract
 9.4 Status extract

10 MySQL replicat
 10.1 MySQl replicat parameter file
 10.2 add and start MySQL REPLICAT process

10.3 REPLICAT status

11. Verify the replication
 11.1 Update Oracle table content
11.2 check replicat statistics

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.