In Bi-Directional Replication, Supplemental Logging via DDL Is NOT Replicated to the Target Unless the Extract on the Target Is Running.
Last updated on FEBRUARY 03, 2017
Applies to:Oracle GoldenGate - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
After supplemental logging is enabled by been adding for a table(either by ADD TRANDATA command or Automatically by the EXTRACT ADDTRANDATA param), captured DDL changes should be sent to the target environment. In the problem case, INFO TRANDATA command on the target shows showing Supplement logging Disabled.
If you start EXTRACT on the target you will see supplemental logging enabled, but sometimes extract on the target extract may be down and you want to ensure that all operations are captured correctly on the new target table.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms