OGG-01169 Encountered an update where all key columns for target table CHERR...

显示全部楼层 · 2021-12-7 15:19:11

2021-12-07T15:19:11.934+0800INFOOGG-06510:Using the following key columns for target table CHERRY.REAL_ACCOUNT_INFO: OUT_TRADE_NO.
2021-12-07T15:19:12.048+0800ERROR OGG-01169:Encountered an update where all key columns for target table CHERRY.INTERFACE_USED_LOG are not present.
2021-12-07T15:19:12.048+0800INFOOGG-02333:Reading /opt/oracle/app/ogg/ggs/dirdat/t9000000000, current RBA 9,038,535, 846 records, m_file_seqno = 0, m_file_rba = 9,045,096.
ogg同步报以上错误，主备库表的索引和主键都是一直的还可能是什么原因导致的。

千问 · 2021-12-7 15:19:11

你确认备表有主键和约束？仔细对比看看吧
select index_name,table_name,column_name,COLUMN_POSITION from dba_ind_columns where TABLE_OWNER='A' and table_name='B';

千问 · 2021-12-7 15:19:11

jieyancai 发表于 2021-12-7 21:02
你确认备表有主键和约束？仔细对比看看吧select index_name,table_name,column_name,COLUMN_POSITION from...
谢谢，查过了，是有的，备库这边完全安装主库语句来的，还是报这个错误。。。