ogg同步部分列

hghl

edit param ext1
EXTRACT ext1
userid ogg,password oracle
TABLE tb01, COLS (object_id,object_name,object_type);


ggserr.log
OGG-01161  Oracle GoldenGate Delivery for Oracle, REP1.prm:  Bad column index (3) specified for table SCOTT.tb01, max columns = 3.

是否需要在配置中加上什么其他参数

alibull

object_id,object_name,object_type
加其中一个为主键
添加表级日志
再试

alibull

To use COLS, the following is required:

The table must have one or more key columns, or a substitute key must be defined with the KEYCOLS option. See "KEYCOLS (columns)".

The key columns or the columns specified with KEYCOLS must be included in the column list that is specified with COLS. Otherwise, they will not be captured, and an error will be generated during processing.

Witho

hghl

加主键 加keycols 还是一样的报错

hghl

trandata delete add后 又好了

jieyancai

hghl 发表于 2016-4-12 09:52
trandata delete add后 又好了

最终的配置参数是怎样的？

hghl

jieyancai 发表于 2016-4-12 10:07
最终的配置参数是怎样的？

edit param ext1
EXTRACT ext1
userid ogg,password oracle
exttrail /opt/oracle/ogg/dirdat/tr
TABLE tb01, COLS (object_id,object_name,object_type),keycols(object_id);

tb01加上主键object_id

delete trandata ggs.tb01
add trandata ggs.tb01
关键在于delete后再add 卡就卡在这上面了