GoldenGate安装部署及解决方案

GoldenGate安装部署及解决方案

目录

GoldenGate安装部署及解决方案 .................................................................................................. 1

1、GoldenGate 简介 ............................................................................................................... 2 2、文档约定和说明 ................................................................................................................ 5 3、GoldenGate软件安装 ........................................................................................................ 5

3.1 GoldenGate软件安装包下载 .................................................................................... 5 3.2 Windows下安装 ........................................................................................................ 6 3.3 Linux和Unix下安装 ................................................................................................. 7 4、GoldenGate同步基本配置 ................................................................................................ 8

4.1 oracle之间同步和GoldenGate基础 ........................................................................ 8 4.2 oracle与db2同步 ................................................................................................... 15 4.3 oracle与sybase同步 .............................................................................................. 16 5、GoldenGate同步方案 ...................................................................................................... 16

5.1 使用GoldenGate初始化加载 ................................................................................ 17 5.2 一对多数据同步(广播复制) ............................................................................. 18 5.3 多对一数据同步(集中复制) ............................................................................. 19 5.4 数据转换和过滤 ..................................................................................................... 20 5.5 关于目标端高数据安全性下的GoldenGate配置方案 ........................................ 24 5.6 GoldenGate双向复制(active-active).................................................................. 26 6、GoldenGate数据同步性能测试 ...................................................................................... 29

6.1 测试中主要监测数据和监测方式 ......................................................................... 30 6.2 测试脚本和GoldenGate配置 ................................................................................ 30 6.3 测试步骤 ................................................................................................................. 34 6.4 性能测试结果 ......................................................................................................... 36 7、GoldenGate推荐配置 ...................................................................................................... 37

7.1 添加必要的环境参数 ............................................................................................. 37 7.2 BATCHSQL参数 ........................................................................................................ 37 7.3 数据库用户密码加密 ............................................................................................. 38 7.4 trail再压缩 ............................................................................................................... 39 8、GoldenGate Troubleshooting ........................................................................................... 40

8.1 一些常用的进程信息和日志的查看方式 ............................................................. 40 8.2 解析trail文件 ......................................................................................................... 40 附: GoldenGate新版本的一个特性 .................................................................................. 41 参考文档 ................................................................................................................................ 42

你可能喜欢

  • 容灾解决方案
  • goldengate
  • 实施方案模板
  • 三思笔记
  • oracle维护
  • Oracle解决方案
  • GoldenGate介绍
  • 系统解决方案

GoldenGate安装部署及解决方案相关文档

最新文档

返回顶部