1. Oracle GoldenGate Classic Architecture Documentation
  2. Administer
  3. Data Management
  4. Using Procedural Replication
  5. Enabling and Disabling Supplemental Logging

Enabling and Disabling Supplemental Logging

Oracle GoldenGate provides GGSCI commands to allow you to enable or disable procedural supplemental logging.

To enable supplemental logging:

  1. Connect to the source database as the Oracle GoldenGate administrator with dblogin.

    CONNECT https://localhost:9000 DEPLOYMENT demo AS admin PASSWORD adminpw

    DBLOGIN USERIDALIAS admin_dba DOMAIN OracleGoldenGate

  2. Add supplemental logging for procedural replication.

    ADD PROCEDURETRANDATA

    INFO OGG-13005 PROCEDURETRANDATA supplemental logging has been enabled.

Supplemental logging is enabled for procedure replication.

To disable supplemental logging:

  1. Connect to the source database as the Oracle GoldenGate administrator with dblogin.

    CONNECT https://localhost:9000 DEPLOYMENT demo AS admin PASSWORD adminpw

    DBLOGIN USERIDALIAS admin_dba DOMAIN OracleGoldenGate

  2. Remove supplemental logging for procedure replication.

    DELETE PROCEDURETRANDATA

Supplemental logging is disabled for procedure replication.

To view information about supplemental logging:

  1. Connect to the source database as the Oracle GoldenGate administrator with dblogin.

    CONNECT https://localhost:9000 DEPLOYMENT demo AS admin PASSWORD adminpw

    DBLOGIN USERIDALIAS admin_dba DOMAIN OracleGoldenGate

  2. Display supplemental logging information for procedure replication.

    INFO PROCEDURETRANDATA

Supplemental logging information for procedure replication is displayed.