Goldengate 12c key changes for Oracle 12c configuration

Since Oracle 12c is already a multitenant architecture, there are a few things to consider when using Ogg synchronization

• A CDB contains multiple PDB, and one extract of the source-side deployment can access all PDB redo, which theoretically does not require a separate configuration of extract per PDB.
  
• Extraction mode can only be integrated (integrated) mode, not support Claasic capture traditional mode captures;
• Because you want to use integrated extract, you need to be able to access the Log mining server, which can only be accessed from Cdb$root;
• The source side uses the common user, the C # #ogg这种用户来访问源端DB, to access the Redo log & all PDBs of the db.
• In a ggsci or parameter file, you can use pdb.schema.table to access a specific table or sequence;
• You can use the Sourcecatalog parameter in the parameter file, specify a PDB, and only the schema.table in the following parameters;
  
• Target side each PDB has a replicat process, that is, a replicat process can only be delivered to a single PDB and cannot be delivered to multiple.
  
• Source-side Ogg users need to empower: Dbms_goldengate_auth.grant_admin_privilege (' C # #GGADMIN ',container=> ' all '), It is also recommended that the user settings of Ogg be empowered as Grant DBA to C # #ogg Container=all;
• Source-side DB In addition to the previously open archive, Force logging, minimum additional log, you may also need to open a switch: Alter system set enable_goldengate_replication=true;
• 
  

Extract Example:

TABLE pdb1.schema1.table*;
Sourcecatalog PDB2
TABLE schema2.table*;
TABLE schema3.table*;
Sourcecatalog PDB3
TABLE schema4.table*;
After add extract, you also need to

Pump Example:

UserID c##[email protected], password ogg
Rmthost Orasql-test, Mgrport 7809  

TABLE pdb1.schema1.table*;
Sourcecatalog PDB2
TABLE schema2.table*;
TABLE schema3.table*;
Sourcecatalog PDB3
TABLE schema4.table*;

Replicat Example:




Assumetargetdefs
MAP pdb1.schema1.table*, Target schema1.table*;
MAP pdb3.schema4.table*, Target schema1.table*;
Sourcecatalog
MAP schema2.table*, Target schema1.table*;
MAP schema3.table*, Target schema1.table*;

Goldengate 12c key changes for Oracle 12c configuration