Goldengate 12c key changes for Oracle 12c configuration

Here is some of the things to keep on mind when dealing with OGG and 12c multitenant architecture.

• It's available only in integrated capture mode and not classic capture.

• One extract can configured to capture changes from multiple PDBs

• Since we have to use integrated capture mode, a log mining server is involved and this are only accessible from the root Co Ntainer (Cdb$root).

• We have to connect as a common user to attach to the log mining server. For example a user called C # #GGADMIN is the what we are using with our example.

• There is a 3 part naming convention in Ggsci and Parameter file. For example Container Name.Schema.Table (or Sequence)

• The parameter Sourcecatalog when used enables us to use the earlier Schema.table type naming convention.

• Replicat can only connect and apply to one pluggable database.

• The Dbms_goldengate_auth.grant_admin_privilege package grants the appropriate privileges for capture and apply within a MU Ltitenant container database. This includes the container parameter, which must is set to all, as shown in the following example:

Dbms_goldengate_auth.grant_admin_privilege (' C # #GGADMIN ', Container=>all)

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

1. Extraction mode can only be integrated (integrated) mode, does not support the capture of Claasic capture traditional mode;

2. 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.

3. 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;

4. The source side uses the common user, the C # #ogg这种用户来访问源端DB, to access the Redo log & all PDBs of the db.

5. In the Ggsci or parameter file, you can use pdb.schema.table to access the specific table or sequence;

6. You can use the Sourcecatalog parameter in the parameter file, specify a PDB, the following parameters only need schema.table;

7. Target 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.

8. The source-side Ogg user needs 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;

9. Source-side DB In addition to the previous opening of the archive, force logging, the smallest additional log, may also need to open a switch: Alter system set enable_goldengate_replication=true;

Reference

Configuring Oracle GoldenGate in a multitenant Container Database

http://docs.oracle.com/goldengate/1212/gg-winux/GIORA/config_containerdb.htm#GIORA942

Goldengate 12c key changes for Oracle 12c configuration