Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to enable supplemental logging on Autonomous ATP or ADW on Shared Infrastructure

edited Jul 12, 2022 2:26PM in Autonomous Database 4 comments

Summary:

Per the latest documentation, it shows that Goldengate should be able to extract from ATP or ADW. In order for GoldenGate to do this we need to add supplemental logging.

I understand a previous answer was provided 2 years ago here:

https://cloudcustomerconnect.oracle.com/posts/3f9a81f677

Although the documents have changed since then.

Content (required):

Per the documents, we need to execute the following command:

alter PLUGGABLE database add supplemental log data

When doing so we get the following error:

Error starting at line : 3 in command -

alter PLUGGABLE database add supplemental log data

Error report -

ORA-31541: Supplemental logging is not enabled in CDB$ROOT.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!