GoldenGate 不迷茫
10墨值下载
Step by Setp Oracle GoldenGate
Installation and Configure Guide
For Oracle Database 10gR2
With Automtic Storage Management(ASM)
Version 1.0
邱金华
第 2 页 /共 55 页
Internal Partner Win Story
Step by Setp
Oracle GoldenGate
Installation and Configure Guide
目录
目录目录
目录
1
说明 ................................................................................................... 5
2
安装前的准备 ........................................................................................ 5
2.1 GoldenGate 表空间 .................................................................................................................. 5
2.2 源端 GoldenGate 模式用户 ....................................................................................................... 5
2.3 RAC 节点时钟同步 ................................................................................................................... 5
2.4 数据库归档模式 ........................................................................................................................ 5
2.5 归档目录 .................................................................................................................................. 6
2.6 配置环境变量 ........................................................................................................................... 6
2.7 AIX 系统的特殊要求 ................................................................................................................. 6
2.8 Windows 系统的特殊要求 ......................................................................................................... 7
2.9 网络设置 .................................................................................................................................. 7
2.10 操作系统用户 ........................................................................................................................... 7
2.11 创建文件系统 ........................................................................................................................... 7
2.12 补充日志 .................................................................................................................................. 7
3
G
OLDEN
G
ATE
源和目标端的安装 ................................................................. 8
3.1 源端 GoldenGate 安装 .............................................................................................................. 8
3.2 目标端 GoldenGate 安装 .......................................................................................................... 8
3.3 测试 GoldenGate 控制台 .......................................................................................................... 8
3.4 创建 GoldenGate 运行时目录 ................................................................................................... 8
3.5 设置 GoldenGate Manager 参数 .............................................................................................. 8
4
G
OLDEN
G
ATE
进程配置 ............................................................................. 9
4.1 源端设置 ASM 实例 TNS 别名 .................................................................................................. 9
4.2 源端添加表级附加日志 ............................................................................................................. 9
4.3 源端创建 Capture 进程 ............................................................................................................. 9
4.4 验证源端 Capture 进程 ........................................................................................................... 10
4.5 排除不复制的表 ...................................................................................................................... 10
4.6 中文表/中文字段处理 .............................................................................................................. 10
4.7 源端创建 DataPump 进程 ....................................................................................................... 11
4.8 验证源端 DataPump 进程 ....................................................................................................... 11
4.9 源端数据库获取 SCN ............................................................................................................. 11
4.10 源端数据库备份 ...................................................................................................................... 11
4.11 源库到目标库的数据初始化 .................................................................................................... 11
4.12 禁用目标库的 trigger 和外键约束; ........................................................................................... 15
4.13 禁止目标库 job 守护进程： ..................................................................................................... 15
4.14 创建目标端 GoldenGate 表空间 .............................................................................................. 15
4.15 创建目标端 GoldenGate 模式用户 .......................................................................................... 15
4.16 创建目标端 Replicat 进程 ....................................................................................................... 16
4.17 目标端启动 Replicat 进程 ....................................................................................................... 16
4.18 目标端 Replicat 优化 .............................................................................................................. 16
4.19 REPERROR 用法................................................................................................................... 17
4.20 复制进程常见数据库错误类型与处理方法 ............................................................................... 17
5
DDL 复制支持 ..................................................................................... 17
5.1 源端数据库运行 DDL 支持脚本 ............................................................................................... 17
of 55
10墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
文档被以下合辑收录
评论