Upgrading a Configuration That Includes DDL Support

This section contains considerations and steps you should take when DDL support is active in the Oracle GoldenGate environment.

In the Integrated mode, if the source database is Oracle 11.2.0.4 or later, DDL capture support is integrated into the database logmining server as long as the database COMPATIBLE parameter is set to 11.2.0.4 or higher.

Table 12-2 shows possible DDL upgrade paths and guidelines.

Table 12-2 Possible Upgrade Paths to Oracle GoldenGate and Requirements for DDL Support

Upgrade from: To: Integrated capture, no trigger

Integrated capture using trigger method (all 11.2.1 database versions)

Can be used for a container database.

  1. Source database must be 11.2.0.4 or higher.

  2. Source database COMPATIBLE setting must be 11.2.0.4 or higher.

  3. Upgrade Oracle GoldenGate per these upgrade instructions.
Foot 1

Footnote Legend

Footnote 1:

An upgrade of the database to 11.2.0.4 or 12.1 automatically takes a data dictionary snapshot in the redo stream as part of the patch set upgrade.