Goldengate 12c key changes for Oracle 12c configuration

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.