1.查询报错日志
GGSCI (target) 3> view report repa
2.处理过程
根据报错提示，排查原因为OGG用户没有对HR用户表的操作权限导致
2.1 登陆目标库确认是否有权限
SYS@PROD> conn ogg/oracle OGG@PROD> insert into hr.t1 (object_id,object_name) values (76838,'ogg_test');
2.2 源库及目标库授权
SYS@PROD> show user USER is "SYS" SYS@PROD> select TABLE_NAME from dba_tables where OWNER='HR'; select 'grant insert,update,delete on hr.'||TABLE_NAME||' to ogg;' from dba_tables where OWNER='HR';
3.启动repa进程
GGSCI (target) 4> info all GGSCI (target) 5> start repa GGSCI (target) 6> info all GGSCI (target) 7> view report repa
4.验证数据的同步性
##源库查询 [oracle@source ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 4 17:23:20 2021 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SYS@PROD> select count(*) from hr.t1; COUNT(*) ---------- 1 ----------------------------------------------------------------------------------- 目标库查询 [oracle@target ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 4 17:23:44 2021 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SYS@PROD> select count(*) from hr.t1; COUNT(*) ---------- 1
