OGG搭建完成后，源端insert数据导致目标端复制进程报错OGG-00768、OGG-00769

问题描述：OGG搭建完成后，源端insert数据导致目标端复制进程报错OGG-00768、OGG-00769，如下所示：
1、异常重现
--告警日志如下
WARNING OGG-02761 Source definitions file, /opt/ogg/target_endpoint/dirdef/ogg_test.info_tab, is ignored because trail file /opt/ogg/target_end
point/dirdat/rt000000000 contains table definitions.

2024-07-17 10:13:12 WARNING OGG-00769 Failed to validate table name (info_tab) in Database (ogg). SQL error (0).

2024-07-17 10:13:12 ERROR OGG-00768 No rows found while fetching the metadata for table ogg.info_tab. SQL error (0).

2024-07-17 10:13:12 ERROR OGG-01668 PROCESS ABENDING.

2024-07-17 10:13:12 INFO OGG-25701 The file caching thread was shutdown. Thread ID: 140121457022720.

2、问题分析
--复制进程文件内容如下
GGSCI (leo-mysql-ogg) 20> view param r_tab1

replicat r_tab1
targetdb ogg@192.168.133.35:3306,userid ogg,password ogg
sourcedefs /opt/ogg/target_endpoint/dirdef/ogg_test.info_tab
HANDLECOLLISIONS
MAP ORCLPDB.test_ogg.*,target ogg.info_tab;

--查目标端是否存在表ogg.info_tab
mysql> select database();
+------------+
| database() |
+------------+
| ogg |
+------------+
1 row in set (0.00 sec)

mysql> show tables;
+--------------------+
| Tables_in_ogg |
+--------------------+
| ggs_checkpoint |
| ggs_checkpoint_lox |
| test_ogg |
+--------------------+
3 rows in set (0.00 sec)

说明：经确认目标端不存在ogg.info_tab表.

--后来发现在搭建OGG源端建表结构时，表名建错导致.
mysql> use ogg
Database changed
mysql> create table test_ogg(id int,name varchar(20),primary key(id));
Query OK, 0 rows affected (0.00 sec)

3、解决方案
--目标端删除test_ogg表
mysql> drop table test_ogg;
Query OK, 0 rows affected (0.01 sec)

mysql> create table info_tab(id int,name varchar(20),primary key(id));
Query OK, 0 rows affected (0.00 sec)

--目标端重启复制进程
GGSCI (leo-mysql-ogg) 23> start r_tab1

Sending START request to Manager ...
Replicat group R_TAB1 starting.


GGSCI (leo-mysql-ogg) 24> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
REPLICAT RUNNING R_TAB1 00:00:00 00:00:00

4、数据验证
--目标端查询
mysql> select * from info_tab;
+----+-------+
| id | name |
+----+-------+
| 1 | alina |
+----+-------+
1 row in set (0.00 sec)

GGSCI (leo-mysql-ogg) 26> stats r_tab1

Sending STATS request to Replicat group R_TAB1 ...

Start of statistics at 2024-07-17 14:07:19.

Replicating from ORCLPDB.TEST_OGG.INFO_TAB to ogg.info_tab:

*** Total statistics since 2024-07-17 11:32:23 ***
Total inserts 5.00
Total updates 0.00
Total deletes 4.00
Total upserts 0.00
Total discards 0.00
Total operations 9.00

*** Daily statistics since 2024-07-17 11:32:23 ***
Total inserts 5.00
Total updates 0.00
Total deletes 4.00
Total upserts 0.00
Total discards 0.00
Total operations 9.00

*** Hourly statistics since 2024-07-17 11:32:23 ***
Total inserts 5.00
Total updates 0.00
Total deletes 4.00
Total upserts 0.00
Total discards 0.00
Total operations 9.00

*** Latest statistics since 2024-07-17 11:32:23 ***
Total inserts 5.00
Total updates 0.00
Total deletes 4.00
Total upserts 0.00
Total discards 0.00
Total operations 9.00

End of statistics.

--源端insert数据
test_ogg@ORCLPDB> select * from info_tab;

ID NAME
---------- --------------------------------------------------------------------------------
1 alina

test_ogg@ORCLPDB> insert into info_tab values (2,'miss');

1 row created.

test_ogg@ORCLPDB> commit;

Commit complete.

test_ogg@ORCLPDB> select * from info_tab;

ID NAME
---------- --------------------------------------------------------------------------------
1 alina
2 miss

--目标端查询数据
mysql> select * from info_tab;
+----+-------+
| id | name |
+----+-------+
| 1 | alina |
| 2 | miss |
+----+-------+
2 rows in set (0.00 sec)

说明：如上所示，源端oracle与目标端mysql数据保持一致.