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.

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s