Best Practice Questions on GG
edited Jul 28, 2013 9:35AM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered ✓
1) If we have many replication setups on a single GG installation, then is it necessary or best practice to have seperate table CHECKPOINTTABLE ggadmin.ggchkpt for each replicat process ?
2) If we have atleast 2 replication setups on 3 different databases on same server which uses same database home,
then Do we need to have a seperate GG installation for each database ?
I guess ,Having a seperate GG installation will be usefull because patching/upgrading a GG installation for any fixes,
for a single replication setup, will not affect other replication setups .
Am I right ?
3) If we have configured 3 replication setups on single installation then ,
2) If we have atleast 2 replication setups on 3 different databases on same server which uses same database home,
then Do we need to have a seperate GG installation for each database ?
I guess ,Having a seperate GG installation will be usefull because patching/upgrading a GG installation for any fixes,
for a single replication setup, will not affect other replication setups .
Am I right ?
3) If we have configured 3 replication setups on single installation then ,
2