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