Forum Stats

  • 3,826,326 Users
  • 2,260,624 Discussions
  • 7,896,898 Comments

Discussions

GG trail file replication

Robeen
Robeen Member Posts: 2,179 Silver Badge

Oracle DB 12.1.0.2

GoldenGate 18c

Hello Team,


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

Answers

  • ORASCN
    ORASCN Member Posts: 1,874 Bronze Crown

    Hi Roshan,

    The below should work,

    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

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

    But you need to perform the DDL operations manually on the Target, whenever you have DDL operations on Source. But this doesn't affect the source.

    Regards,

    Veera