GGS ERROR 190 No Minimum Supplemental Logging Is Enabled

renjixinchina發表於2013-01-11
Error

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部落格 ” ，連結：http://blog.itpub.net/15747463/viewspace-752537/，如需轉載，請註明出處，否則將追究法律責任。

相關文章