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

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:31

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.

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】