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.
本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!