Enabling GoldenGate 12c DDL replication

For some IT demands it’s necessary to replicate DDL’s (Data Definition) to maintain source/target equalized.

So Oracle delivery excellent feature DDL Replication since GG 10G.

In GG 12c the procedure turns simplified.

So, under GoldenGate home, do SQLPLUS as sysdba:

SQL> @role_setup.sql

GGS Role setup script

 

Enter GoldenGate schema name:ggate
Wrote file role_setup_set.txt

PL/SQL procedure successfully completed.

Role setup script complete

Grant this role to each user assigned to the Extract, GGSCI, and Manager processes, by using the following SQL command:

GRANT GGS_GGSUSER_ROLE TO 

where  is the user assigned to the GoldenGate processes.
SQL> GRANT GGS_GGSUSER_ROLE TO ggate;

Grant succeeded.

SQL> @ddl_enable.sql

Trigger altered.

Configure Extract/Pump/Replicat with DDL Replication:

Insert into those process parameter ” DDL INCLUDE MAPPED”

Sample:

EXTRACT E_DBA
USERID OGG PASSWORD OGGPASS
EXTTRAIL ./dirdat/fo
TRANLOGOPTIONS EXCLUDEUSER OGG
DDL INCLUDE MAPPED
TABLE OGG.*;

Maiquel.

 

 

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.