没有合适的资源?快使用搜索试试~ 我知道了~
首页GoldenGate Oracle同步到Mysql配置手册
GoldenGate Oracle同步到Mysql配置手册
4星 · 超过85%的资源 需积分: 9 32 下载量 112 浏览量
更新于2023-03-16
评论
收藏 211KB PDF 举报
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.
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
<database>
Replicat
Collector
Trails
Manager
<source> server
Oracle
Source
<owner/schema>
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
<install location>
and the target
<install
location>.
The MySQL
<database>
defined in the target environment.
<source> server
Oracle
<target> server
Target
<database>
Source
<owner/schema>
Network
Initial
Extract
Initial
Replicat
Prepare the Environment
Page 3
Exercise 1.
Prepare the Environment
Objective
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
<source>
system, create the Manager parameter file and specify the port it should use.
Create the Manager parameter file.
Shell> cd <install location>
Shell> ggsci
GGSCI> EDIT PARAMS MGR
Use the editor to assign a port.
--GoldenGate Manager parameter file
PORT <port>
Start the Manager.
GGSCI> START MGR
Verify that the Manager has started.
GGSCI> INFO MGR
2. Create the source tables and load the initial data.
Using
SQL
*Plus, create and populate the
TCUSTMER
and
TCUSTORD
tables by running the
demo_ora_create.sql
and
demo_ora_insert.sql
files found in the install directory.
Execute the following commands on the
<source>
system.
Shell> cd <install location>
Shell> sqlplus <login>/<password>
SQL> @demo_ora_create
SQL> @demo_ora_insert
剩余14页未读,继续阅读
Tirith
- 粉丝: 0
- 资源: 14
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- RTL8188FU-Linux-v5.7.4.2-36687.20200602.tar(20765).gz
- c++校园超市商品信息管理系统课程设计说明书(含源代码) (2).pdf
- 建筑供配电系统相关课件.pptx
- 企业管理规章制度及管理模式.doc
- vb打开摄像头.doc
- 云计算-可信计算中认证协议改进方案.pdf
- [详细完整版]单片机编程4.ppt
- c语言常用算法.pdf
- c++经典程序代码大全.pdf
- 单片机数字时钟资料.doc
- 11项目管理前沿1.0.pptx
- 基于ssm的“魅力”繁峙宣传网站的设计与实现论文.doc
- 智慧交通综合解决方案.pptx
- 建筑防潮设计-PowerPointPresentati.pptx
- SPC统计过程控制程序.pptx
- SPC统计方法基础知识.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论1