1. 首页 > ITPUX技术网 > 正文

oracle golengate数据库容灾复制实施方案大概步骤

oracle golengate数据库容灾复制实施方案大概步骤

1:项目启动

2:调研

3:确认复制需求

4:goldengate 规划和设计

5:goldengate安装和部署

6:数据初始化(可以用exp imp,dblink,sql loader或者第三方工具等)

7:监控与运维

实施goldengate要求的前提条件:

1:Enable supplemental logging.
2:Setting at database level overrides any NOLOGGING operations and ensures all changed data is written to the redo logs.
3:Forces the logging of the full before and after image for updates.
4:Ensure each source table has a primary key.
5:GoldenGate requires a primary key to uniquely identify a row.
 If the primary key does not exist on the source table, GoldenGate will create its own unique identifier by concatenating all the table columns together.

本文由风哥教程整理发布,仅用于学习测试使用,转载注明出处:http://www.fgedu.net.cn/10327.html

联系我们

在线咨询:点击这里给我发消息

微信号:itpux-com

工作日:9:30-18:30,节假日休息