Summary of faults in unused field by GoldenGate

Yesterday, the business department responded to the need to delete the fields of a table and thought about setting the fields to the state of unused, which is very convenient to restore if needed. This morning, it was found that there was a failure in OGG data replication, the main library EXTRACT process appeared ABENDED status, and the data was not synchronized. Viewing from the OGG log is a problem with the field UNNUSED.

Log exception

2015-07-25 09:08:50 WARNING OGG-00455 Oracle GoldenGate Capture for Oracle, pumpwh4.prm: Problem in resolving [TONG.FIN_CALE]: Failed to validate table TONG.FIN_CALE. Likely due to existence of unused columns. It will cause data integrity issue if you are not using sourcedefs in downstream Replicat or the target table doesn't have the same unused columns due to ASSUMETARGETDEFS or DDL replication. Please use 'DBOPTIONS ALLOWUNUSEDCOLUMN' parameter to override this., try to fix this issue in order to avoid possible fatal error.

Solution (1):

GGSCI (iZ23jtzbnliZ) 11 > stop extwh

GGSCI (iZ23jtzbnliZ) 2 > edit params extwh-- EXTRACT process of the main library

DBOPTIONS ALLOWUNUSEDCOLUMN-- just add this line of parameters

GGSCI (iZ23jtzbnliZ) 3 > start extwh

Sending START request to MANAGER...

EXTRACT EXTWH starting

GGSCI (iZ23jtzbnliZ) 4 >

Solution (2):

SQL > ALTER TABLE FIN_CALE DROP UNUSED COLUMNS;-- delete the unused field