Oracle_GoldenGate概念、安装步骤及基本的配置步骤_for_ORACLE
5星 · 超过95%的资源 需积分: 34 152 浏览量
2011-10-05
17:53:06
上传
评论 3
收藏 422KB PDF 举报 
OGG 概念、安装步骤及基本的配置步骤 for ORACLE
第一章 系统要求：.........................................................................................................................3
第二章 安装OGG：........................................................................................................................3
2.1. OGG的几种架构 ..........................................................................................................3
2.2. 环境变量.......................................................................................................................4
2.3. unix环境安装................................................................................................................4
2.4. windows环境安装 ........................................................................................................4
第三章 配置环境.............................................................................................................................5
3.1. 创建OGG用户：..........................................................................................................5
3.2. 支持sequence配置： ....................................................................................................6
3.3. 支持DDL配置： ..........................................................................................................6
3.4. 重置DDL环境： ..........................................................................................................7
3.5. 删除DDL环境： ..........................................................................................................8
第四章 必要的配置说明：.............................................................................................................8
4.1. 关闭回收站和配置附加日志.......................................................................................8
4.2. initiate the logging of key values ..................................................................................8
4.3. 防止由于triggers 和cascade constraints带来的数据重复修改 ..................................9
4.4. Deferring constraint checking.......................................................................................9
4.5. Limiting row changes in tables that do not have a key .................................................9
4.6. 复制TIMESTAMP with TIME ZONE..........................................................................9
第五章 配置MANAGER： ..........................................................................................................10
5.1. 配置MGR参数........................................................................................................10
5.2. 配置CHECKPOINT TABLE..................................................................................10
第六章 配置一个active-active的架构 ..........................................................................................11
6.1. SOURCE端.................................................................................................................11
6.2.1 EXTRACT1 ...........................................................................................................11
6.2.2 Data pump1............................................................................................................12
6.2. TARGET端 .................................................................................................................12
6.2.1 Replicat2 ................................................................................................................12
6.2.2 Extract2..................................................................................................................13
6.2.3 Data pump2............................................................................................................14
6.3. SOURCE端.................................................................................................................14
6.2.1 Replicat1 ................................................................................................................14
6.4. mapping and manipulating data ..................................................................................15
6.5. data-definitions file .....................................................................................................16
第七章 初始化数据加载...............................................................................................................17
剩余16页未读，继续阅读
评论13
最新资源