Prerequisites for Configuring Oracle GoldenGate Extract to Capture from Autonomous Databases

Prior to configuring and starting the Extract process to capture from the Autonomous Database, make sure that the following requirements are met:

Oracle Autonomous Database environment is provisioned and running.
Autonomous Database-level supplemental logging should be enabled by the ADMIN or GGADMIN.

Configuring Autonomous Database Supplemental Logging for Extract

To add minimal supplemental logging to your Autonomous Database instance, log into the instance as GGADMIN or ADMIN account and execute the following commands:

ALTER PLUGGABLE DATABASE ADD SUPPLEMENTAL LOG DATA;

To DROP Autonomous Database-level supplemental logging incase you decide to stop capturing from that database instance:

ALTER PLUGGABLE DATABASE DROP SUPPLEMENTAL
        LOG DATA;

You can verify that the Autonomous Database-level supplemental logging is configured properly by issuing this SQL statement:

SELECT MINIMAL FROM dba_supplemental_logging;

The output for this statement is:

MINIMAL
-------
YES

The MINIMAL column will be YES if supplemental logging has been correctly set for this Autonomous Database instance.