In this article, we will see GoldenGate 12c setup for Oracle Container Database.
Separate user for Extract and Replication need to be created.
User for Extract should be common user connected to Root Container in order to interact with the logmining server.
For example: C##GGADMIN@FINANCE.
REplicat User would be PDB User and a separate User will be required for each PDB
So a single Extract can supports pulling data from multiple PDBs, but a single Replicat will only support applying data to 1 PDB.
So if pulling data from multiple PDBs, multiple replicats will need to be created to apply all the data.
The dbms_goldengate_auth.grant_admin_privilege package grants the appropriate privileges for capture and apply within a multitenant container databases.
This includes the container parameter, which must be set to ALL for the extract user, as shown in the following example:
In case of Extraction:
In case of Replication:
(unixserver1) cd /ggs
GGSCI (unixserver1) > dblogin userid c##ggadmin, password ggadmin
Successfully logged into database CDB$ROOT.
GGSCI (unixserver1) > REGISTER EXTRACT EXTORA DATABASE CONTAINER (PDB1);
Register extract ext1 database container(dvlp);
Add extract ext1,integrated tranlog,begin now
Replicat Configuration would be same as for traditional Oracle Database
Follow Me On
Linkedin :Ankush Chawla