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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7199859/viewspace-703737/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7199859/viewspace-703737/