ORA-30567: name already used by an existing

ogg 报错信息如下

2021-08-24 18:10:49 ERROR OGG-01489 Oracle GoldenGate Capture for Oracle, yz01.prm: Could not add TRAN DATA for table, error [ORA-30567: name already used by an existing
log group SQL ALTER TABLE "YZ"."LAAGENTB" ADD SUPPLEMENTAL LOG GROUP "GGS_75783" ("EDORNO","AGENTCODE") ALWAYS /* GOLDENGATE_DDL_REPLICATION */], error code [30567], operation [ALTER TABLE "YZ"."LAAGENTB" ADD SUPPLEMENTAL LOG GROUP "GGS_75783" ("EDORNO","AGENTCODE") ALWAYS /* GOLDENGATE_DDL_REPLICATION */ (size 131)].2021-08-24 18:10:50 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, yz01.prm: PROCESS ABENDING.

通过查询dba_log_groups、dba_log_group_columns视图查询  log group GGS_75783在那张表上

删除log group

alter table yz.TMPLJAPAYPERSON  drop SUPPLEMENTAL LOG GROUP "GGS_75783"

在启动进程

LAAGENTB、TMPLJAPAYPERSON 2张表会自动添加表级附件日志

 

添加附加日志

alter table test add  supplemental log data(all,primary key,unique,foreign key) columns;

删除附加日志

alter table test drop  supplemental log data(all,primary key,unique,foreign key) columns;  

注：这种删除附加日志可能会报错

建议删除附加日志组

alter table yz.TMPLJAPAYPERSON  drop SUPPLEMENTAL LOG GROUP "GGS_75783"

删除附加日志

DELETE TRANDATA finance.acct ALLCOLS

添加附件日志

ADD TRANDATA finance.acct

查看

info TRANDATA finance.acct