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.