GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Enabling Supplemental Logging on Source database

We are going to use Golden Gate 19.1 classic architecture to upgrade our database 12.1.0.2 to 19c.
The documentation mentions about enabling Supplemental Logging. It is not clear if I still need to run TRANDATA from ggsci after enabling at the database level.

For example, after running the commands below at the database level (source database), do I still need to run ADD SCHEMATRANDATA or ADD TRANDATA from ggsci?

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
SQL> ALTER DATABASE FORCE LOGGING;

Thanks, Brad.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center