Tag Archives: ORA30567: name already used by an existing

ORA-30567: name already used by an existing [How to Solve]

ogg error message:
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.
Query log group GGS_75783 on that table by querying dba_log_groups, dba_log_group_columns view

Delete the log group
alter table yz.TMPLJAPAYPERSON drop SUPPLEMENTAL LOG GROUP “GGS_75783”
In the startup process
LAAGENTB, TMPLJAPAYPERSON 2 tables will automatically add table-level attachment logs
Add additional logs
alter table test add supplemental log data(all,primary key,unique,foreign key) columns;
Delete the additional log
alter table test drop supplemental log data(all,primary key,unique,foreign key) columns;
Note: This kind of delete supplemental log may report an error
Suggest to delete the supplemental log group
alter table yz.TMPLJAPAYPERSON  drop SUPPLEMENTAL LOG GROUP “GGS_75783”