DDL replication GoldenGate

[Roshan]

Oracle DB 12.1.0.2
GoldenGate 18c

Hello Erman,

I am currently testing goldengate replication from trail files to Kudu using Striim.

DDL replication is not supported between heterogeneous DBs.

We have options namely:

1. Have the GGPump generate Trail Files with DDL EXCLUDE ALL in the Pump Extract.
2. Make the DDL change in the Kudu table and restart the App from where it failed
3. More complex option - is for you to generate a DEFGEN file and use the GGTrailParser as opposed to the GGTrailReader

If I use 'EXCLUDE ALL DDL' on source pump extract, will there be discrepencies on the source tables being replicated using goldengate?

RuntimeException | SRC_REMOTEGG_CDC_KUDU
com.webaction.common.exc.UnexpectedDDLException: {DDL Event} for table={CBS_CORE.CB_INVOICE} in File={cd000006023} at Offset={347272114}caused by Event={{"_id":"01eb130c-39c3-7c25-abf1-005056a1681b","timeStamp":1603222879458,"sourceUUID":"01eb1037-f38c-f8c1-9924-005056a1681b","data":[16257634,null,null,null,1677900,null,null,null,null,null],"meta":{"TableID":18,"TableName":"CBS_CORE.CB_ACC_BALNC","TxnID":"0.20.4.3080985","OperationName":"UPDATE","FileName":"cd000006023","FileOffset":305121692,"TimeStamp":"2020-10-20T23:39:40.000+04:00","Oracle ROWID":"AAAjOYAAxAAEqHeAAp","CSN":"298849954391","RecordStatus":"VALID_RECORD"},"userdata":{}}}



Thanks,

Roshan

[ErmanArslansOracleBlog]

When you exclude DDL replication, you will need to manage the DDLs on souce and target by yourself, manually. For instance; If you add alter column that is configured to be replicated, then you need to make the alter both in source and target. This is the logic of it..

But, take a look at the following note ->

Oracle GoldenGate: Capture and Apply of Microsoft SQL Server DDL Operations (Doc ID 2059791.1)

In the note above, you will find a pdf attached -> MSS_DDL_Capture_Apply.pdf

Read that pdf and you may find some logical actions for your DDL operations in heterogenous db envirıonment.

The pdf/article starts with ->

Oracle GoldenGate (OGG) supports DDL capture and apply for the Oracle and Teradata databases only.
Because of this, maintenance tasks for other databases require a lot of coordination and typically an
extended OGG outage. In this article we shall discuss one option for automating the capture, delivery,
and execution of DDL operations using OGG for Microsoft SQL Server 2008. The techniques
discussed may also be used for other databases supported by OGG.

[Roshan]

Thanks Erman.