最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

Get object already exist on target using golden gate - Stack Overflow

programmeradmin5浏览0评论

I have two servers gg1 and gg2 using bidirectional replication. before i start replication I create one table on both gg1 and gg2. Then I turn on replication and insert rows into gg1 and it words fine.

However when i try to create a "new' table on gg1 replication fails on gg1 with 2025-03-15T18:13:25.318-0400 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, s_rep.prm: Fatal error executing DDL replication: error [Error code [955], ORA-00955: name is already used by an existing object ], no error handler present.

This is my replicat setting on gg2

replicat s_rep
userid ggs_owner, password Newpassword_2
assumetargetdefs
discardfile /u01/gg/dirrpt/srep1.dsc, append
reperror (default, exception)
map sender.*, target sender.*;
MACRO #exception_handler
 BEGIN
 , TARGET GGS_OWNER.GGS_EXCEPTIONS
 , COLMAP ( rep_name = @GETENV('GGENVIRONMENT', 'GROUPNAME')
 , TABLE_NAME = @GETENV ('GGHEADER', 'TABLENAME')
 , ERRNO = @GETENV ('LASTERR', 'DBERRNUM')
 , DBERRMSG = @GETENV ('LASTERR', 'DBERRMSG')
 , OPTYPE = @GETENV ('LASTERR', 'OPTYPE')
 , ERRTYPE = @GETENV ('LASTERR', 'ERRTYPE')
 , LOGRBA = @GETENV ('GGHEADER', 'LOGRBA')
 , LOGPOSITION = @GETENV ('GGHEADER', 'LOGPOSITION')
 , COMMITTIMESTAMP = @GETENV ('GGHEADER', 'COMMITTIMESTAMP')
 , GGS_FILENAME = @GETENV('GGFILEHEADER', 'FILENAME')
 , CDRFAIL = @GETENV('DELTASTATS','CDR_RESOLUTIONS_FAILED')
 , CDRSUC = @GETENV('DELTASTATS','CDR_RESOLUTIONS_SUCCEEDED')
 , CDRDETECT = @GETENV('DELTASTATS','CDR_CONFLICTS'))
 , INSERTALLRECORDS
 , EXCEPTIONSONLY;
 END;
MAP sender.* #exception_handler();

the extract and pump on gg1 is

extract s_ext
userid ggs_owner, password oracle
tranlogoptions excludeuser ggs_owner
exttrail /u01/gg/dirdat/lt
ddl include all
getupdatebefores
sequence sender.*;
table sender.*;


extract s_pmp
userid ggs_owner, password oracle
rmthost 192.168.1.146, mgrport 7809
rmttrail /u01/gg/dirdat/rt
passthru
sequence sender.*;
table sender.*;

tried recreate golden gate and same issue.

发布评论

评论列表(0)

  1. 暂无评论