1
oracle goldengate(ogg)概念、安装步骤及基本的
5墨值下载
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 loggin g of key va lues ..................................................................................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 m anipul ating data ..................................................................................15
6.5. data-definitions file .....................................................................................................16
第七章 初始化数据加载...............................................................................................................17
创建记录
时间 作者 版本 备注
2011-08-01 WangYang Ocean) 1 无
修改记录
修改时间 修改者 修改点
of 17
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论