Applies to:

Oracle GoldenGate - Version 4.0.0 and later
Information in this document applies to any platform.

Fix

Starting Extract you see the error:

GGS ERROR 190 No minimum supplemental logging is enabled. This may cause extract process to handle key update incorrectly if key column is not in first row piece.

What should I do?

Check to see if Supplement Logging is enabled in the database, and if it is not, enable it.
Delete and Re-add your Extract(or alter extract tranlog begin now)

Do the following query in SQLPLUS from an account with DBA Privilidge.

If any of the columns in this query return YES, you DO have Supplemental Logging enabled and you would have to examine other possible security problems in the database.

SQL > select SUPPLEMENTAL_LOG_DATA_MIN SLDM, SUPPLEMENTAL_LOG_DATA_PK SLP, SUPPLEMENTAL_LOG_DATA_UI SLU, FORCE_LOGGING FL from v$database;
SQL > SLDM SLP SLU FD
------ ---- ----- ----
NO NO NO NO

Since they are all "NO", Supplemental Logging is NOT enabled in your database in this example. If any of the fields return YES it is enabled.

You should also have Supplmental Logging enabled for every Table in your Replicat you are capturing updates for, Supplemental Logging ensures all the Key Data is put in the Redolog.

To enable Supplemental Logging in your database please follow the instructions in Knowledge Base Ticket Note 965876.1.

ITPub博客

GGS ERROR 190 No Minimum Supplemental Logging Is Enabled

Applies to:

Fix

最新文章