1
oracle goldengate(ogg)概念、安装步骤及基本的
378
17页
9次
墨值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
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜
近期活动
全部
暂无活动,敬请期待...
相关课程
全部