OGG-00751錯誤處理一例

skuary發表於2012-05-23
今天下午觀察ogg報表庫，發現主站的dump程式abend掉了，err log裡報錯資訊如下：
 
2012-05-23 16:56:42  ERROR   OGG-00751  Oracle GoldenGate Capture for Oracle, dpksr1.prm:  Failed to validate table MYNET_APP.M_ORDER_INFO. 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.
2012-05-23 16:56:42  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, dpksr1.prm:  PROCESS ABENDING.
 
仔細觀察發現，是由於一張表中存在unused列導致，回想下，昨天我們經理在這張表上加了一列，之後發現加錯了，想直接drop，由於業務高峰期，就先執行了unused操作，從而導致dump程式異常abend，這個錯誤的官方說明如下：
 
OGG-00751: Failed to validate table {0}. 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.
Cause: The specified table contains unused columns. Oracle Supports tables with
unused columns, but the support is disabled by default. Extract abends on these
columns unless you use the DBOPTIONS parameter with the
ALLOWUNUSEDCOLUMN option to force Extract to generate a warning and
continue processing.
Action: Specify DBOPTIONS with ALLOWUNUSEDCOLUMN. When using this
parameter, either the same unused column must exist in the target table, or a
source definitions file must be created for Replicat with the DEFGEN utility. For
more information about the source definitions file, see the Oracle GoldenGate
administration documentation.
 
解決方法也給出了，很簡單，停掉dump程式，新增引數：
 
DBOPTIONS  ALLOWUNUSEDCOLUMN
 
然後重啟程式就ok了，正常啟動後，該錯誤就變成了警告，相關log資訊如下：
 
2012-05-23 16:59:07  WARNING OGG-00752  Oracle GoldenGate Capture for Oracle, dpksr1.prm:  Failed to validate table MYNET_APP.M_ORDER_INFO. Likely due to existence of unused column. Please make sure you use sourcedefs in downstream Replicat, or the target table has exactly the same unused columns when using ASSUMETARGETDEFS or DDL replication.
 
這個警告的官方說明如下：
 
OGG-00752: Failed to validate table {0}. Likely due to existence of unused column.
Please make sure you use sourcedefs in downstream Replicat, or the target table
has exactly the same unused columns when using ASSUMETARGETDEFS or
DDL replication.
Cause: The specified table contains unused columns. Oracle Supports tables with
unused columns, but the support is disabled by default. Extract abends on these
columns unless you use the DBOPTIONS parameter with the
ALLOWUNUSEDCOLUMN option to force Extract to generate a warning and
continue processing.
Action: Specify DBOPTIONS with ALLOWUNUSEDCOLUMN. When using this
parameter, either the same unused column must exist in the target table, or a
source definitions file must be created for Replicat with the DEFGEN utility. For
more information about the source definitions file, see the Oracle GoldenGate
administration documentation.
 
可以忽略。
 
記錄一下~~

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/25618347/viewspace-730697/，如需轉載，請註明出處，否則將追究法律責任。

相關文章