数据驱动 成就未来 运维手册
云和恩墨（北京）信息技术有限公司米乐app官网下载的版权所有，严禁翻印
1
概述
....................................................................................................................................... 5
2 基本概念 ............................................................................................................................... 5
2.1 goldengate基本架构 .............................................................................................................. 6
2.2 capture模式简介 .................................................................................................................... 7
3 安装部署 ............................................................................................................................... 8
3.1 安装规范 .................................................................................................................................. 8
3.2 准备阶段 .................................................................................................................................. 9
3.2.1
数据库日志操作 .......................................................................................................... 9
3.2.2
检查是同步表索引情况 ........................................................................................... 10
3.2.3
数据库补丁检查 ........................................................................................................ 10
3.2.4
配置合理的归档路径 ............................................................................................... 11
3.3 创建 goldengate 数据库用户 ....................................................................................... 11
3.4 禁用外键约束及其触发器（目标端设置） ................................................................ 14
3.5 在源端配置复制库 manager 进程 ................................................................................. 17
3.6 在目标端配置复制库 manager 进程 ............................................................................. 18
3.7 在源端配置 global 全局参数 ......................................................................................... 19
3.8 创建 wallet （ogg 12c 版本使用） .......................................................................... 19
3.9 实施阶段 ................................................................................................................................ 20
3.9.1
在源端编辑开启extract 抽取进程ex_xx ........................................................... 20
3.9.2
在源端编辑开启datadump投递进程dp_xx ................................................... 26
3.9.3
目标端复制库配置rpxx ........................................................................................... 27
4 数据初始化 ......................................................................................................................... 31
4.1 expdp 导出 .......................................................................................................................... 31
4.2 impdp 导入 .......................................................................................................................... 32
4.3 打开投递进程 ....................................................................................................................... 33
4.4 验证阶段 ................................................................................................................................ 33
5 ogg 操作规范 ................................................................................................................... 34
5.1 日常监控规范 ....................................................................................................................... 34
5.2 日常操作规范 ....................................................................................................................... 34
6 ogg 日常监控 ................................................................................................................... 35
文档被以下合辑收录
评论