oracle官方针对ogg同步oracle到mysql的操作方法
免费下载
2021/1/15 Document 1605674.1
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrl-state=z5rvkvcj1_109&id=1605674.1 1/11
Copyright (c) 2021, Oracle. All rights reserved. Oracle Confidential.
How to Replicate Data Between Oracle and MySQL Database? (Doc ID 1605674.1)
In this Document
Goal
Solution
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
2021/1/15 Document 1605674.1
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrl-state=z5rvkvcj1_109&id=1605674.1 2/11
11. Verify the replication
11.1 Update Oracle table content
11.2 check replicat statistics
APPLIES TO:
Oracle GoldenGate - Version 10.4.0.0 and later
Information in this document applies to any platform.
GOAL
This note describes a set up of a GoldenGate replication between Oracle and MySQL
SOLUTION
Please make sure you have installed GoldenGate on the Oracle and the MySQL server. First let's start with the configuration of
GoldenGate on the MySQL machine.
1. Pre-requisites
So let's start ggsci: ./ggsci
and in ggsci let's create the subdirectories:
GGSCI 1> create subdirs
Creating subdirectories under current directory /var/lib/mysql/ggs
Parameter files /var/lib/mysql/ggs/dirprm: already exists
Report files /var/lib/mysql/ggs/dirrpt: created
Checkpoint files /var/lib/mysql/ggs/dirchk: created
Process status files /var/lib/mysql/ggs/dirpcs: created
SQL script files /var/lib/mysql/ggs/dirsql: created
Database definitions files /var/lib/mysql/ggs/dirdef: created
Extract data files /var/lib/mysql/ggs/dirdat: created
Temporary files /var/lib/mysql/ggs/dirtmp: created
Stdout files /var/lib/mysql/ggs/dirout: created
2. GoldenGate Manager
The next step is to configure a basic GoldenGate manager process:
GSCI (server) 2> edit param mgr
of 11
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论