OGG相關參數 SUPPRESSTRIGGERS 、DEFERREFCONST

OGG注意事項:

1.同步前須確認disable目標端triggers, disable目標端foreign keys

(或使用DBOPTIONS SUPPRESSTRIGGERS、 DBOPTIONS DEFERREFCONST參數)

P.S.
1.SUPPRESSTRIGGERS is the default and prevents triggers from firing on target objects that are configured for replication with Oracle GoldenGate. 
2.SUPPRESSTRIGGERS is valid for Oracle 11.2.0.2 and later 11gR2 versions
3.You can use DEFERREFCONST instead of disabling the constraints on the target tables or setting them to DEFERRED.

ref: https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/gg_parameters034.htm#GWURF437

2.Replicat的用戶必須有Streams的管理許可權
exec dbms_goldengate_auth.grant_admin_privilege("USERNAME");

相關注意事項請再參照安裝手冊.

---

如果同步10.2.0.5 , 11.2.0.2 之後版本的資料庫, 請先參考以下連結

http://www.askmaclean.com/archives/goldengate-parameter-suppresstriggers-deferrefconst.html

http://oracleabout.blogspot.tw/2013/06/goldengate-user-creation.html

OGG Tuning 所需注意的tips

http://jaychu649.blogspot.tw/2015/11/ogg-tuning-tips.html

Goldengate Best Parameters & TEST from Maclean

http://www.askmaclean.com/archives/goldengate-best-parameters-test-from-maclean.html