Need help in configuring GG Replication on a Source Server with multiple databases to Target Server with Multiple Databases. Databases are 11.2.0.4 version residing in the same Oracle home.
- Using a single manager for the single Golden Gate Instance installed.
-
Do we add checkpoint table on the source side too and if yes or just replicate side. Is it required to add checkpoint table and if yes how can we set it up for multiple databases.
-
Do we need to specify the GGSCHEMA gguser in the ./GLOBALS file when we have multiple databases. If yes do I just create the same name GGUSER in all the databases.
-
Do we need to create separate directories for each database or is it fine if they go to the same directory with different trail file names.
dirrpt,dirprm,dirchk,dirpcs,dirsql,dirdmp,dirwlt,dircrd, dirdat, dirdef,dirtmp,dirver,