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.