OracleGoldenGateWindows平台oracle-mysql的单向复制资源-CSDN文库

需积分: 13 2 浏览量 2017-07-07 14:18:21 上传评论 1 收藏 1.68MB DOCX 举报

资源推荐

资源详情

资源评论

Oracle GoldenGate Windows 平台 oracle-mysql 的单向复制
 概述
简介
 技术架构
 进程
 进程
 进程
 文件
 进程
  命令
 拓扑结构
搭建实验环境
实验环境
源端环境搭建
下载并安装 
添加  进程到 !!" 服务#
设置环境变量$
配置  数据库%
目标端环境搭建
下载并安装 
添加  进程到 !!" 服务
 主要目录介绍
目标端创建 &' 数据库并进行用户授权
启动源端和目标端  进程
启动目标端  进程
启动源端  进程
配置和启动源端  进程和  进程
源端  进程
源端  进程#
源端生成对象定义文件，并拷贝到目标端%
创建对象定义文件%
拷贝对象定义文件(
#配置并启动目标端 )*' 和  进程(
$+, 同步并验证
$目标端创建测试表
$启动源端捕获进程
$验证 +, 操作
$脚本
$源端执行 " 操作
$源端执行  操作#
$源端执行  操作$

%配置 ++, 同步%
%不支持及有限支持的 ++, 类型%
%++, 处理方法%
%不支持 ++, 类型的处理方法%
%受限支持的 ++, 的处理方法(
%++, 复制配置(
%关闭源端  进程组(
%安装 ++, 对象
%验证 ++, 安装
(其它配置说明
( 进程参数配置说明
(抽取进程参数配置说明
(复制进程参数配置说明
(配置源端  进程自启动
(配置目标端  进程自启动#
1. GoldenGate 概述
1.1. 简介
- 公司的  软件是一种基于日志的结构化数据复制软件，它通过抽取源
数据库在线日志或归档日志获得数据的增删改变化，然后通过  . 投递到目标端，使目
标端实现同源端的数据同步。
软件可以在异构的基础结构（包括几乎所有常用操作系统平台和数据库平
台）之间实现大量数据亚秒一级的实时复制。
图一 + 复制原理