gg

***********************************************************************
**                     Run Time Messages                             **
***********************************************************************

2011-11-14 14:33:09  INFO    OGG-01517  Position of first record processed Sequence 13840, RBA 62035984, SCN 2019.2049415575, Nov
 10, 2011 9:12:24 AM.

2011-11-14 14:33:12  INFO    OGG-01644  BOUNDED RECOVERY: COMPLETE: for object pool 1: p21954_extr at SeqNo: 13840, RBA: 11340904
0, SCN: 2019.2049627011 (8673588597635).
TABLE resolved (entry GBSMAN.CLIENT_INFO):
  TABLE GBSMAN.CLIENT_INFO;

Source Context :
  SourceModule            : [ggdb.ora.dbx]
  SourceID                : [/home/ecloud/workspace/Build_FBO_OpenSys_r11.1.1.0.0_078_[34085]/perforce/src/gglib/ggdbora/dbxoci.c
]
  SourceFunction          : [get_object_attributes]
  SourceLine              : [5102]

2011-11-14 14:33:21  ERROR   OGG-00751  Failed to validate table GBSMAN.CLIENT_INFO. Likely due to existence of unused columns. I
t will cause data integrity issue if you are not using sourcedefs in downstream Replicat or the target table doesn't have the sam
e unused columns due to ASSUMETARGETDEFS or DDL replication. Please use 'DBOPTIONS ALLOWUNUSEDCOLUMN' parameter to override this.

***********************************************************************
**                     Run Time Messages                             **
***********************************************************************

Opened trail file ./dirdat/e0000010 at 2011-11-14 15:01:55
TABLE resolved (entry GBSMAN.CLIENT_INFO):
  TABLE GBSMAN.CLIENT_INFO;

Source Context :
  SourceModule            : [ggdb.ora.dbx]
  SourceID                : [/home/ecloud/workspace/Build_FBO_OpenSys_r11.1.1.0.0_078_[34085]/perforce/src/gglib/ggdbora/dbxoci.c]
  SourceFunction          : [get_object_attributes]
  SourceLine              : [5102]

2011-11-14 15:01:55  ERROR   OGG-00751  Failed to validate table GBSMAN.CLIENT_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 ALLOWUNUSEDCOLU
MN' parameter to override this.

产生原因：
==========
源表一些列被set unused，导致def文件与日志中取得的数据不一致。

解决办法：
==========
在Extract（Capture）,Extract（Data-Pump）的参数文件中，SOURCEDB，USERID之前加入：DbOptions AllowUnusedColumn。
依次重启Extract（Capture），Extract（Data-Pump）。

 

 

 

 

 

 

***********************************************************************
**                     Run Time Messages                             **
***********************************************************************

Opened trail file ./dirdat/d7000002 at 2011-11-14 14:41:53

MAP resolved (entry PASDATA.PAS_MASTER_PLAN):
  MAP PASDATA.PAS_MASTER_PLAN, TARGET CDMDATA.ODS_PBS_PAS_MASTER_PLAN, colmap ( PLAN_NO=PLAN_NO, COMPANY_PHONE_ID=COMPANY_PHONE_ID, COMPANY_ADDRESS_ID=COMPANY_ADDRESS_ID, ANNUALL
Y_INCOME=ANNUALLY_INCOME, PRIMARY_BUSINESS=PRIMARY_BUSINESS, AGT_CODE=AGT_CODE, IS_SERVICE_PLAN=IS_SERVICE_PLAN, UPLOAD_CIF2_DATE=UPLOAD_CIF2_DATE, END_REASON=END_REASON, END_DAT
E=END_DATE, LCU=LCU, LCD=LCD, FCU=FCU, FCD=FCD, STATUS=STATUS, PLAN_SOURCE=PLAN_SOURCE, APPROVE_DATE=APPROVE_DATE, APPLY_DATE=APPLY_DATE, DEPT_NO=DEPT_NO, PLAN_TYPE=PLAN_TYPE, MA
RKETING_CHANNEL=MARKETING_CHANNEL, SERVICE_MODE=SERVICE_MODE, GROUP_FLAG=GROUP_FLAG, EMPLOYEES_COUNT=EMPLOYEES_COUNT, LAST_YEAR_AMOUNT=LAST_YEAR_AMOUNT, COMPANY_EMAIL=COMPANY_EMA
IL, COMPANY_FAX=COMPANY_FAX, COMPANY_PHONE=COMPANY_PHONE, COMPANY_POSTCODE=COMPANY_POSTCODE, COMPANY_ADDRESS=COMPANY_ADDRESS, BANK_SUBBRANCH=BANK_SUBBRANCH, BANK_CITY=BANK_CITY,
BANK_PROVINCE=BANK_PROVINCE, BANK_ACCOUNT_NAME=BANK_ACCOUNT_NAME, BANK_ACCOUNT=BANK_ACCOUNT, BANK=BANK, TRUSTEE_DATE=TRUSTEE_DATE, JOIN_DATE=JOIN_DATE, CUSTOMER_NO=CUSTOMER_NO, S
CHEME_NO=SCHEME_NO, SCHEME_ID=SCHEME_ID, PLAN_REGISTER_NO=PLAN_REGISTER_NO, PARENT_PLAN_NO=PARENT_PLAN_NO, IMAGE_BARCODE=IMAGE_BARCODE );

Using the following key columns for target table CDMDATA.ODS_PBS_PAS_MASTER_PLAN: PLAN_NO.

2011-11-14 14:41:56  WARNING OGG-01004  Aborted grouped transaction on 'CDMDATA.ODS_PBS_PAS_MASTER_PLAN', Database error 100 (retrieving bind info for query).

2011-11-14 14:41:56  WARNING OGG-01003  Repositioning to rba 32769 in seqno 2.

2011-11-14 14:41:56  WARNING OGG-01154  SQL error 1403 mapping PASDATA.PAS_MASTER_PLAN to CDMDATA.ODS_PBS_PAS_MASTER_PLAN.

2011-11-14 14:41:56  WARNING OGG-01003  Repositioning to rba 32769 in seqno 2.

Source Context :
  SourceModule            : [er.main]
  SourceID                : [/home/ecloud/workspace/Build_FBO_OpenSys_r11.1.1.0.0_078_[34086]/perforce/src/app/er/rep.c]
  SourceFunction          : [take_rep_err_action]
  SourceLine              : [15780]
  ThreadBacktrace         : [8] elements
                          : [/paic/app/mdmdev/goldengate/replicat(CMessageContext::AddThreadContext()+0x26) [0x5da0b6]]
                          : [/paic/app/mdmdev/goldengate/replicat(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x7b2) [0x5d0b52]]
                          : [/paic/app/mdmdev/goldengate/replicat(_MSG_ERR_MAP_TO_TANDEM_FAILED(CSourceContext*, DBString<777> const&, DBString<777> const&, CMessageFactory::Mess
ageDisposition)+0x9b) [0x57c91b]]
                          : [/paic/app/mdmdev/goldengate/replicat [0x7f36e3]]
                          : [/paic/app/mdmdev/goldengate/replicat [0x8c0c21]]
                          : [/paic/app/mdmdev/goldengate/replicat(main+0x1d30) [0x4f5360]]
                          : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3d47e1d994]]
                          : [/paic/app/mdmdev/goldengate/replicat(__gxx_personality_v0+0x1da) [0x4d8e8a]]

2011-11-14 14:41:56  ERROR   OGG-01296  Error mapping from PASDATA.PAS_MASTER_PLAN to CDMDATA.ODS_PBS_PAS_MASTER_PLAN.

 

 

2011-11-16 17:37:56  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.

2011-11-16 17:37:56  GGS ERROR       190  PROCESS ABENDING.

产生原因：
==========
数据库附加日志没有打开。GoldenGate无法从日志中提供记录。
select supplemental_log_data_min from v$database;

解决办法：
==========
打开数据库日志：
alter system checkpoint;
alter system checkpoint;
alter database add supplemental log data;

 

 

New Events for mdm
Process: r_gbs_mdm
Time: 2011-12-21 01:59:18
Event Text: Oracle GoldenGate Delivery for Oracle, r_gbs_mdm.prm:  Error mapping from GBSMAN.ENDO_MAIN to CDMDATA.ODS_EGIS_ENDO_MAIN.

Process: r_gbs_mdm
Time: 2011-12-21 01:59:18
Event Text: Oracle GoldenGate Delivery for Oracle, r_gbs_mdm.prm:  PROCESS ABENDING.

产生原因：
==========
源端有UPDATE或DELETE操作时，目标端没有对应的记录。一般是由于数据初始化时，未同步数据初始化阶段的源端产生的记录造成。

解决办法：
==========
第一种办法：重新初始化。数据量较大时，工作量比较大。
第二种办法：r进程参数文件，开启handlecollisions选项，让goldengate处理冲突。然后手工比对数据差异，补全数据后，再关闭r进程的handlecollisions选项。

 

Q:insert和delete都可以同步，唯独update操作有问题，而且update主键字段是可以的，别的字段不行，被discard

A:用info trandata CCHDATANEW.CCH_CAMPAIGN_OFFER命令看到没有add trandata，add一遍就好了