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
第 3 页 /共 55 页
Internal Partner Win Story
Step by Setp
Oracle GoldenGate
Installation and Configure Guide
5.2 源端 Capture 进程配置 DDL 捕获 ............................................................................................ 24
5.3 源端 Capture 进程配置 DDL 捕获后自动添加 TRANDATA ....................................................... 25
6
G
OLDEN
G
ATE
优化 ................................................................................ 26
6.1 多个 Capture 进程优化捕获性能 ............................................................................................. 26
6.2 DataPump 进程优化 ............................................................................................................... 26
6.3 Replicat 进程优化 ................................................................................................................... 26
6.4 用 filter 和 range 函数优化 Replicat 进程 ................................................................................. 29
7
监控 G
OLDEN
G
ATE
................................................................................ 32
7.1 info all .................................................................................................................................... 32
7.2 status ..................................................................................................................................... 33
7.3 info, detail .............................................................................................................................. 33
7.4 send status ............................................................................................................................ 34
7.5 stats ....................................................................................................................................... 34
7.6 Stats reportrate ...................................................................................................................... 35
7.7 查看 Goldengate 进程处理之间的延时 .................................................................................... 36
8
G
OLDEN
G
ATE
常用技巧 ........................................................................... 36
8.1 指定特定的列复制 .................................................................................................................. 36
8.2 Mapping 异构表 ..................................................................................................................... 36
8.3 COLMATCH 选项 ................................................................................................................... 37
8.4 WHERE 语法及使用 ............................................................................................................... 38
8.5 FILTER 语法及使用 ................................................................................................................ 38
8.6 FILTER 过滤行 ....................................................................................................................... 38
8.7 使用 filter+@GETENV 在线重新初始化指定的表 ..................................................................... 38
8.8 诊断命令工具 ......................................................................................................................... 40
9
G
OLDEN
G
ATE
常见问题及处理 .................................................................. 40
9.1 队列文件保存期限设置 ........................................................................................................... 40
9.2 AIX 使用裸设备 ...................................................................................................................... 40
9.3 UNIX GGSCI 需要 lib 包验证 .................................................................................................. 40
9.4 OGG-01296 ........................................................................................................................... 41
9.5 OGG-01154 ........................................................................................................................... 41
9.6 OGG-01088 ........................................................................................................................... 42
9.7 OGG-01224 ........................................................................................................................... 42
9.8 OGG-01031 ........................................................................................................................... 42
9.9 OGG-01072 ........................................................................................................................... 43
9.10 OGG-01476 ........................................................................................................................... 43
9.11 OGG-01416 ........................................................................................................................... 44
9.12 复制进程拆分及指定队列文件及 RBA ..................................................................................... 44
9.13 BOUNDED RECOVERY ........................................................................................................ 45
9.14 排除不复制的表 ...................................................................................................................... 45
9.15 从指定时间重新抓取 ............................................................................................................... 45
9.16 进程无法停止 ......................................................................................................................... 45
9.17 CLOB 处理 ............................................................................................................................. 45
9.18 Datapump 进程每次只传一个文件 .......................................................................................... 46
9.19 Extract 进程产生 core 文件 ..................................................................................................... 46
9.20 中文字节数问题 ...................................................................................................................... 46
9.21 中文表/中文字段处理 .............................................................................................................. 47
9.22 Extract 拆分方法 .................................................................................................................... 49
9.23 Datapump 和 replicat 拆分方法 ............................................................................................... 52
10
G
OLDEN
G
ATE
反向切换步骤 ............................................................ 54
of 55
10墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
云和恩墨（北京）信息技术有限公司 运营
最新上传
下载排行榜
1
2
centos7下oracle11.2.0.4 rac安装详细图文（虚拟机模拟多路径）.docx
3
白鳝-DBAIOPS：国产化替换浪潮进行时，信创数据库该如何选型？.pdf
4
PostgreSQL 缓存命中率低？可以这么做.doc
5
达梦数据2024年年度报告.pdf
6
李飞-AI 引领的企业级智能分析架构演进与行业实践.pdf
7
吕昕-如何建设人人都能训大模型的技术氛围-V脱敏.pdf
8
刘杰-江苏广电：从Oracle+Hadoop到TiDB，数据中台、实时数仓运维0负担.pdf
9
从指令到 Agent：基于大语言模型构建智能编程助手.pdf
10
贾玮-蚂蚁集团向量检索技术的挑战与实践.pdf
文档被以下合辑收录
相关文档
评论