内容发布更新时间 : 2025/3/1 2:09:18星期一 下面是文章的全部内容请认真阅读。

Oracle_GoldenGate软件安装、配置、运维管理 整理版

目录

Oracle_GoldenGate安装、配置、管理 整理版 ....................................................................................................................................................................................... 1

a) Oracle GoldenGate主要组件 ...................................................................................................................................................................................................... 5

GoldenGate for Oracle ............................................................................................................................................................................................................. 8

b) 把源端数据库的数据同步到目标数据库 ................................................................................................................................................................................ 13 c) 源数据库的修改实时同步到目标数据库 ................................................................................................................................................................................ 34 d) 把源数据库的DDL修改同步到目标数据库中 ....................................................................................................................................................................... 42 e) 术语和缩略语 ........................................................................................................................................................................................................................... 61 基于命令行的监控 ................................................................................................................................................................................................................................... 63

f) 说明 ........................................................................................................................................................................................................................................... 63 g) 启动GoldenGate进程 .............................................................................................................................................................................................................. 63 h) 停止GoldenGate进程 .............................................................................................................................................................................................................. 64 i) 查看整体运行情况.................................................................................................................................................................................................................... 66 j) 查看参数设置 ........................................................................................................................................................................................................................... 67 k) 查看进程状态 ........................................................................................................................................................................................................................... 67 l) 查看延时 ................................................................................................................................................................................................................................... 70

m) 查看统计信息 ....................................................................................................................................................................................................................... 70 n) 查看运行报告 ........................................................................................................................................................................................................................... 71 基于GoldenGate Director的监控 ............................................................................................................................................................................................................ 73

o) GoldenGate Director概述 ......................................................................................................................................................................................................... 73 p) GoldenGate Director的安装部署 ............................................................................................................................................................................................. 75

部署方案及必需条件 ............................................................................................................................................................................................................ 75 安装GoldenGate Director Server .......................................................................................................................................................................................... 77 安装GoldenGate Director Client ........................................................................................................................................................................................... 82

q) 启动GoldenGate Server ............................................................................................................................................................................................................ 83 r) 配置被监控实例 ....................................................................................................................................................................................................................... 83 s) 登录Director Web监控界面 .................................................................................................................................................................................................... 86 t) 监控整体运行情况.................................................................................................................................................................................................................... 88 u) 监控进程状态 ........................................................................................................................................................................................................................... 89 v) 手工配置重点监控列表 ............................................................................................................................................................................................................ 89 w) 查看事件日志 ....................................................................................................................................................................................................................... 92 x) Email告警 ................................................................................................................................................................................................................................. 93 y) 运行GGSCI命令 ....................................................................................................................................................................................................................... 94 日常维护指南 ........................................................................................................................................................................................................................................... 96

z) 日常维护注意事项.................................................................................................................................................................................................................... 96 aa) 配置自动删除队列................................................................................................................................................................................................................ 96 bb) 配置启动MGR时自动启动Extract和Replicat进程.......................................................................................................................................................... 97 cc) 配置MGR自动重新启动Extract和Replicat进程 ............................................................................................................................................................. 97 dd) 长事务管理 ........................................................................................................................................................................................................................... 98 a) 源端和目标端数据库增减复制表 .......................................................................................................................................................................................... 101 b) 修改表结构 ............................................................................................................................................................................................................................. 104

c) 表的重新再同步 ..................................................................................................................................................................................................................... 105 异常处理预案 ......................................................................................................................................................................................................................................... 106

d) 网络故障 ................................................................................................................................................................................................................................. 106 e) RAC环境下单节点失败 .......................................................................................................................................................................................................... 106 f) Extract进程常见异常 ............................................................................................................................................................................................................. 107 g) Replicat进程常见异常 ............................................................................................................................................................................................................ 108 h) 异常处理一般步骤.................................................................................................................................................................................................................. 108 参考文献 ................................................................................................................................................................................................................................................. 110

GoldenGate工作原理