Oracle12c in accordance with the Windows default installation steps for the installation, created the CDB to former, the former directly used as as the database, this is the production of other libraries, impossible to change,

Using ogg to data collection, the former former as the source side, unable to perform the add trandata command specific operation screenshots are as follows:

Using ogg, please directly under the last instance the table data in data collection, how should the configuration?

CodePudding user response:

What steps you do, the data extraction figure there are many steps and can't see you why?

CodePudding user response:

Due to the oracle 12 c is already a multi-tenant architecture, at the time of using OGG synchronization, some need to consider the following situation

A CDB contains multiple PDB, source side deployed a extract can access all PDB redo, does not require each PDB separate configuration theory extract.
Extracting schema can be integrated (integrated) model, does not support claasic capture capture in the traditional way;
Because you want to use integrated extract, therefore, need to be able to access the log mining, server, and this can only access from the last $root;
Source side to use common user, the user to access the c # # ogg source side DB, so access to the DB redo log & amp; All PDBS,
The GGSCI or parameter file, you can use the PDB. Schema. The table to access a specific table or sequence;
Can use sourceCatalog parameters in the parameter file, specify a PDB, behind the parameters in the just schema. The table;
The target side each PDB should have a replicat process, that is, a replicat process can only be delivered to a PDB, cannot be delivered to multiple,
OGG source end users need to empowerment: dbms_goldengate_auth grant_admin_privilege (' # # GGADMIN, container=& gt; "All"), at the same time suggest user Settings of the ogg empowerment as: grant dba to c # # ogg container=all;
DB in addition to open the file before the source end, force logging, minimum additional log, may also need to open a switch: the alter system set enable_goldengate_replication=true;



Extract example:

='oradb' EXTRACT ex1 the SETENV (is)
Userid c # @ # ogg oradb, password ogg

EXTTRAIL./dirdat/lt
TABLE pdb1. In. TABLE *;
SOURCECATALOG pdb2
TABLE schema2. TABLE *;
TABLE schema3. TABLE *;
SOURCECATALOG pdb3
TABLE schema4. TABLE *;
After the add extract, need

The register extract ex12c database container (pdb1 pdb2, pdb3)



Pump example:
EXTRACT dp1
The SETENV (ORACLE_SID='oradb')
Userid c # @ # ogg oradb, password ogg
RMTHOST orasql - test, MGRPORT 7809
RMTTRAIL./dirdat/rt
TABLE pdb1. In. TABLE *;
SOURCECATALOG pdb2
TABLE schema2. TABLE *;
TABLE schema3. TABLE *;
SOURCECATALOG pdb3
TABLE schema4. TABLE *;


Replicat example:

REPLICAT TAB

The SETENV (ORACLE_SID='condb2')

DBOPTIONS INTEGRATEDPARAMS parallelism (6)

USERID c # @ # ogg tgt_pdb1, PASSWORD welcome1

ASSUMETARGETDEFS

The MAP pdb1. In. Table *, target in the table *;

The MAP pdb3. Schema4. Table *, target in the table *;

SourceCatalog

MAP schema2 table *, target in. Table *;

MAP schema3 table *, target in. Table *;

CodePudding user response:

The ADD TRANDATA {[container] owner. Table | schema. The table [JOURNAL of library/JOURNAL] |
The library/file [JOURNAL library/JOURNAL]}
[, NOSCHEDULINGCOLS | ALLCOLS]
[, COLS (columns)]
[, INCLUDELONG | EXCLUDELONG]
[, LOBSNEVER | LOBSALWAYS | LOBSIFCHANGED | LOBSALWAYSNOINDEX]
[NOKEY]

CodePudding user response:

reference 1st floor zyhlhx response:

how your operation steps and the data extraction figure there are many steps and can't see you why?

Operating at the bottom of the saw you, but the source of the data is not in the PDB, but exist in the CDB directly, the conventional way to data synchronization

CodePudding user response:

The building Lord, your problem solved? I also like you, recently, as examples to the club's official website after the login, the first step is executed