Enabling and Disabling Supplemental Logging

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

To enable supplemental logging:

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
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:

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
Remove supplemental logging for procedure replication.
DELETE PROCEDURETRANDATA

Supplemental logging is disabled for procedure replication.

To view information about supplemental logging:

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
Display supplemental logging information for procedure replication.
INFO PROCEDURETRANDATA

Supplemental logging information for procedure replication is displayed.