GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Full database supplemental logging is it mandatory?

edited Apr 14, 2014 12:00PM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered

In our db, we have hundreds of tables, but in GG replication we want to replicate only few tables .

Is it mandatory to add the full database logging i.e ALTER DATABASE ADD SUPPLEMENTAL LOG DATA & db force logging? i am bit concerned the redolog generate huge in full db supplemental logging. So i want to add just table supplemental logging i.e add trandata  <schema>.<table>. Will  GG replication work  on just table supplemental logging?

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