david li, June 28, 2018 - 8:43 am UTC
thanks for your response!
so in another words, if my goldengate only replicate data from several tables and I can guarantee no “nologging” operations will be applied on these tables, so I dont' need to enable the "force logging" for the database, just keep the tables in logging mode and enable the supplemental log, right?
June 29, 2018 - 4:22 am UTC
Yes
Rehan Ali, January 08, 2019 - 10:22 am UTC
But what if I have enable Force logging but not supplemental logging. Will OGG work?
SQL> SELECT supplemental_log_data_min, force_logging FROM v$database;
SUPPLEME FORCE_LOGGING
-------- ---------------------------------------
NO YES
January 10, 2019 - 1:19 am UTC
Force and Supplemental are different things.
Force = even if someone says nologging, then we will log the *normal* redo information
Suplemental = we log *more* than the normal redo information into the redo logs so that GG has more to work with.