Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
How to enable supplemental logging on Autonomous ATP or ADW on Shared Infrastructure — Cloud Customer Connect
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

Received Response
21
Views
4
Comments
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!