使用OGG for Oracle微服务双向同步Oracle数据库搭建双主架构（含DDL）
👉 本文共约3507个字，系统预计阅读时间或需14分钟。
类似文章
OGG有传统的经典架构，也有最新的微服务，2个都可以远程捕获和应用数据，对数据库服务器是0侵入，而传统的经典架构是纯命令行模式，最新的微服务架构是图形化界面操作，几乎所有操作都可以在界面进行。相关文章可以参考：
- 使用OGG for MySQL微服务快速双向同步RDS数据库：https://www.xmmup.com/shiyongoggweifuwukuaisushuangxiangtongburdsshujuku.html
- OGG用于跨云RDS for MySQL之间配置双主实时同步–OGG远程捕获和投递：https://www.xmmup.com/oggyongyukuayunrdszhijianpeizhishuangzhushishitongbuyuanchengbuhuohetoudi.html
- otter用于跨云RDS for mysql之间配置双主实时同步：https://www.xmmup.com/otteryongyukuayunrdszhijianpeizhishuangzhushishitongbu.html
- OGG用于PG数据库之间双主实时同步（RDS for PG亦可）–OGG远程捕获和投递：https://www.xmmup.com/oggyongyupgshujukuzhijianshuangzhushishitongburds-for-pgyikeoggyuanchengbuhuohetoudi.html
- 使用OGG for PG微服务快速双向同步RDS数据库（双主）：https://www.xmmup.com/shiyongogg-for-pgweifuwukuaisushuangxiangtongburdsshujukushuangzhu.html
使用OGG for Oracle微服务
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 | -- 创建专用网络 docker network create --subnet=172.72.7.0/24 ora-network -- OGG微服务 docker pull lhrbest/ogg213maoracle:v1.0 docker rm -f lhrogg213maoracle docker run -d --name lhrogg213maoracle -h lhrogg213maoracle \ --net=ora-network --ip 172.72.7.25 \ -p 9391:3389 -p 29000-29005:9000-9005 \ -v /sys/fs/cgroup:/sys/fs/cgroup \ --privileged=true lhrbest/ogg213maoracle:v1.0 \ /usr/sbin/init -- oracle 压测工具 docker pull lhrbest/lhrdbbench:1.0 docker rm -f lhrdbbench docker run -d --name lhrdbbench -h lhrdbbench \ --net=ora-network --ip 172.72.7.26 \ -v /sys/fs/cgroup:/sys/fs/cgroup \ --privileged=true lhrbest/lhrdbbench:1.0 \ /usr/sbin/init -- ora19c docker rm -f ora19c docker run -d --name ora19c -h ora19c \ -p 1529:1521 --net=ora-network --ip 172.72.7.20 \ --privileged=true \ lhrbest/oracle19clhr_rpm_db_12.2.0.3:2.0 init -- ora21c docker rm -f ora21c docker run -d --name ora21c -h ora21c \ -p 1531:1521 --net=ora-network --ip 172.72.7.21 \ -v /sys/fs/cgroup:/sys/fs/cgroup \ --privileged=true lhrbest/oracle21c_ee_db_21.3.0.0 \ /usr/sbin/init -- 数据库配置 1.开启数据库归档--如果没有开启 2.开启数据库级别附加日志--如果没有开始最小附加日志 3.开启强制日志--如果没有开启强制日志 4.设置ENABLE_GOLDENGATE_REPLICAT参数为TRUE 5.创建OGG用户包括包括源端用户、目标端用户以及OGG抽取用户 select name,supplemental_log_data_min , force_logging, log_mode from v$database; alter database add supplemental log data; alter database add supplemental log data (all) columns; alter database force logging; alter system set enable_goldengate_replication=TRUE; alter system set streams_pool_size = 50M scope=spfile; CREATE USER ogg identified by lhr; GRANT DBA to ogg; grant SELECT ANY DICTIONARY to ogg; GRANT EXECUTE ON SYS.DBMS_LOCK TO lhr; -- pdb CREATE USER ogg identified by lhr container=all; GRANT DBA to ogg container=all; GRANT SELECT ANY DICTIONARY to ogg container=all; GRANT EXECUTE ON SYS.DBMS_LOCK TO lhr container=all; exec dbms_goldengate_auth.grant_admin_privilege('OGG',PRIVILEGE_TYPE=>'*',GRANT_SELECT_PRIVILEGES=>true); |
访问：http://192.168.66.35:29000 ，用户名：oggadmin，密码：lhr
创建身份证明
或直接访问：http://192.168.66.35:29001/
创建检查点表
添加trandata
添加脉动表
配置ora19c到ora21c的实时同步
创建extract进程
1 2 3 4 5 6 7 | extract ext19c USERIDALIAS ora19c, DOMAIN OGGMA DDL INCLUDE MAPPED DDLOPTIONS REPORT TRANLOGOPTIONS EXCLUDETAG 99 exttrail ./dirdat/e1 table lhr.*; |
创建replicate进程
1 2 3 4 5 6 | REPLICAT rep19c USERIDALIAS ora21c DOMAIN OGGMA DDL INCLUDE MAPPED DDLOPTIONS REPORT DBOPTIONS SETTAG 99 MAP lhr.*, TARGET lhr.*; |
测试同步
在Oracle 19c端建表和插入数据：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | create table t1 (id number primary key,name varchar2(255)); insert into t1 select object_id,object_name from dba_objects where object_id<=20; commit; select count(8) from t1; LHR@lhrsdb> create table t1 (id number primary key,name varchar2(255)); Table created. LHR@lhrsdb> insert into t1 select object_id,object_name from dba_objects where object_id<=20; 19 rows created. LHR@lhrsdb> commit; Commit complete. LHR@lhrsdb> select count(8) from t1; COUNT(8) ---------- 19 |
从源端查看：
查看目标端：
1 2 3 4 5 | LHR@127.0.0.1/pdb2> select count(8) from t1; COUNT(8) ---------- 19 |
可见，DDL和DML同步都已经完成！
配置ora21c到ora19c的实时同步
创建extract进程
1 2 3 4 5 6 7 | extract ext21 USERIDALIAS ora21c, DOMAIN OGGMA DDL INCLUDE MAPPED DDLOPTIONS REPORT TRANLOGOPTIONS EXCLUDETAG 99 exttrail ./dirdat/e2 table lhr.*; |
创建replicate进程
1 2 3 4 5 6 | REPLICAT rep21 USERIDALIAS ora19c DOMAIN OGGMA DDL INCLUDE MAPPED DDLOPTIONS REPORT DBOPTIONS SETTAG 99 MAP lhr.*, TARGET lhr.*; |
测试同步
在Oracle 21c操作：
1 2 3 4 | create table t2 (id number primary key,name varchar2(255)); insert into t2 select object_id,object_name from dba_objects where object_id<=20; commit; select count(8) from t2; |
可见，DDL和DML同步都已经完成！
配置完成后的效果
简单测试以下DDL语句类型：
1 2 3 4 5 | create table drop table CREATE INDEX CTAS truncate |
都没有问题，其它类型没有测试！
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | [oracle@lhrogg213maoracle ~]$ adminclient Oracle GoldenGate Administration Client for Oracle Version 21.3.0.0.0 OGGCORE_21.3.0.0.0_PLATFORMS_210728.1047 Copyright (C) 1995, 2021, Oracle and/or its affiliates. All rights reserved. Oracle Linux 7, x64, 64bit (optimized) on Jul 28 2021 12:32:46 Operating system character set identified as UTF-8. OGG (not connected) 1> CONNECT http://127.0.0.1:9000 deployment deploy213 as oggadmin password lhr OGG (http://127.0.0.1:9000 deploy213) 2> info all Program Status Group Type Lag at Chkpt Time Since Chkpt ADMINSRVR RUNNING DISTSRVR RUNNING PMSRVR RUNNING RECVSRVR RUNNING EXTRACT RUNNING EXT19C INTEGRATED 00:00:00 00:00:03 EXTRACT RUNNING EXT21 INTEGRATED 00:00:00 00:00:07 REPLICAT RUNNING REP19C INTEGRATED 00:00:00 00:00:06 REPLICAT RUNNING REP21 INTEGRATED 00:00:00 00:00:04 |
压测同步并查看检测数据
ora19c造数据：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 | /usr/local/swingbench/bin/oewizard -s -create -c /usr/local/swingbench/wizardconfigs/oewizard.xml -create \ -version 2.0 -cs //172.72.7.20/lhrsdb -dba "sys as sysdba" -dbap lhr -dt thin \ -ts users -u lhr -p lhr -allindexes -scale 0.001 -tc 16 -v -cl col TABLE_NAME format a30 SELECT a.table_name,a.num_rows FROM dba_tables a where a.OWNER='LHR' ; select object_type,count(*) from dba_objects where owner='LHR' group by object_type; select sum(bytes)/1024/1024 from dba_segments where owner='LHR'; LHR@lhrsdb> SELECT a.table_name,a.num_rows FROM dba_tables a where a.OWNER='LHR' AND NUM_ROWS>=20 ; TABLE_NAME NUM_ROWS ------------------------------ ---------- CUSTOMERS 1000 ADDRESSES 1500 CARD_DETAILS 1500 WAREHOUSES 1000 ORDER_ITEMS 7110 ORDERS 1430 INVENTORIES 903126 PRODUCT_INFORMATION 1000 LOGON 2383 PRODUCT_DESCRIPTIONS 1000 ORDERENTRY_METADATA 0 |
-s是静默，-create表示创建数据，-c是指定配置文件，就是oewizard.xml，-version指定swingbench版本，-cs表示数据库连接串，-dba表示连接到oracle数据库的用户，-dbap表示连接到oracle数据库的密码，-dt表示连接类型，-ts是指定表空间为users, -u表示压测的用户，-p表示压测用户的密码，-scale是数据量，1就是1G，0.001就是1Mb数据，-tc 是并发度，-allindexes是支持所有的索引类型，-v显示详细信息，-cl表示运行在字符模式。
由于造出来的数据可能不是一条条的DML语句，所以，若有OGG同步到ora21c，并不能保证数据的一致性，有可能造成数据错误，所以，这里使用数据泵初始化数据！
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | 1、停止所有ext和rep进程 2、数据泵导出导入 SYS@lhrsdb> select current_scn from v$database; CURRENT_SCN ----------- 5228371 expdp lhr/lhr directory=DATA_PUMP_DIR dumpfile=LHR.dmp SCHEMAS=LHR FLASHBACK_SCN=5228371 scp /opt/oracle/admin/lhrsdb/dpdump/LHR.dmp 172.72.7.21:/home/oracle/ conn lhr/lhr@127.0.0.1/pdb2 create directory d1 as '/home/oracle/'; grant all on directory d1 to public; impdp lhr/lhr@127.0.0.1/pdb2 DIRECTORY=D1 schemas=LHR dumpfile=LHR.dmp TABLE_EXISTS_ACTION=REPLACE 3、重置所有ext和rep进程的CSN为5115566，然后启动所有ext和rep进程 alter extract ext19c scn 5228371 alter extract ext21 scn 5228371 alter REPLICAT rep19c begin now alter REPLICAT rep21 begin now start * |
在ora19c侧加压
1 2 3 4 | /usr/local/swingbench/bin/charbench -c /usr/local/swingbench/configs/SOE_Server_Side_V2.xml \ -u lhr -p lhr -cs //172.72.7.20/lhrsdb -dt thin -uc 100 \ -a -v "users,tpm,tps,dml,cpu" \ -rr 2 -rt "00:02" -min 5 -max 5 -r "/tmp/test_lhrsdb.xml" |
参数介绍：
-c 使用配置文件：SOE_Server_Side_V2.xml
-cs 指定数据库连接字符串：//172.72.7.20/lhrsdb
-a 自动运行
-v 显示运行统计值（使用逗号分隔，不能有空格）,就是对应的指标
- Users：用户数;
- Tpm：每分钟事务数;
- Tps：每秒事务数;
- Trans：事务信息，对应swingbench的Transactions页签中的Short Name
- Dml：包括：查询、插入、更新、删除、提交
-r 指定测试结果文件名称，默认为results.xml
-rr 控制台刷新显示频率（单位：秒），默认每秒显示一次；
-rt 设置负载运行时间，格式：hh:mm.sec，默认一直运行;
-min
设置内部事务最小思考时间；Min. Intra Delay Within Transactions(ms)，线程思考时间（暂停时间），用于模拟实际用户操作。 -max
设置内部事务最大思考时间；Min. Intra Delay Within Transactions(ms)，线程思考时间（暂停时间），用于模拟实际用户操作。 -vo 输出测试结果到文件，默认输出到控制台；
-env 打印出环境变量的信息
-bg是后台运行
执行过程：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 | [root@lhrdbbench /]# /usr/local/swingbench/bin/charbench -c /usr/local/swingbench/configs/SOE_Server_Side_V2.xml \ > -u lhr -p lhr -cs //172.72.7.20/lhrsdb -dt thin -uc 100 \ > -a -v "users,tpm,tps,dml,cpu" \ > -rr 2 -rt "00:02" -min 5 -max 5 -r "/tmp/test_lhrsdb.xml" Author : Dominic Giles Version : 2.6.0.1137 Results will be written to /tmp/test_lhrsdb.xml. Time Users TPM TPS Select Insert Update Delete Commit Rollback User SystemWait Idle 20:10:22 [0/100] 0 0 0 0 0 0 0 0 0 0 0 0 20:10:25 [0/100] 0 0 0 0 0 0 0 0 0 0 0 0 20:10:27 [0/100] 0 0 0 0 0 0 0 0 0 0 0 0 20:10:29 [0/100] 0 0 0 0 0 0 0 0 0 0 0 0 20:10:31 [0/100] 0 0 0 0 0 0 0 0 0 0 0 0 20:10:33 [100/100] 0 0 0 0 0 0 0 0 0 0 0 0 20:10:36 [100/100] 172 166 1350 144 85 0 165 0 0 0 0 0 20:10:38 [100/100] 379 207 3660 492 355 0 368 0 0 0 0 0 20:10:40 [100/100] 846 237 8552 1294 919 0 821 0 0 0 0 0 20:10:42 [100/100] 1288 191 13304 1864 1402 0 1255 0 0 0 0 0 20:10:44 [100/100] 1724 203 17973 2514 1856 0 1684 0 0 0 0 0 20:10:46 [100/100] 2192 253 22924 3211 2405 0 2142 0 0 0 0 0 20:10:48 [100/100] 2681 278 28239 3897 2895 0 2618 0 0 0 0 0 20:10:50 [100/100] 3537 307 37269 5096 3756 0 3452 0 0 0 0 0 20:10:52 [100/100] 3870 333 40968 5571 4116 0 3781 0 0 0 0 0 20:10:54 [100/100] 4544 372 48499 6514 4842 0 4436 0 0 0 0 0 20:10:56 [100/100] 5062 225 54115 7245 5369 0 4942 0 0 0 0 0 20:10:58 [100/100] 5625 297 60410 8068 5960 0 5494 0 0 0 0 0 20:11:00 [100/100] 6296 412 67552 9067 6695 0 6148 0 0 0 0 0 20:11:02 [100/100] 6946 359 75134 10085 7489 0 6784 0 0 0 0 0 20:11:04 [100/100] 8016 526 86957 11734 8763 0 7832 0 0 0 0 0 20:11:06 [100/100] 8837 342 96044 12912 9632 0 8637 0 0 0 0 0 20:11:08 [100/100] 9261 147 100653 13515 10108 0 9048 0 0 0 0 0 20:11:10 [100/100] 9636 173 104690 14081 10498 0 9415 0 0 0 0 0 20:11:12 [100/100] 10076 193 109495 14684 10903 0 9844 0 0 0 0 0 20:11:14 [100/100] 10557 302 114584 15330 11392 0 10311 0 0 0 0 0 20:11:16 [100/100] 11082 226 120300 16046 11954 0 10820 0 0 0 0 0 20:11:18 [100/100] 11548 250 125652 16791 12525 0 11272 0 0 0 0 0 20:11:20 [100/100] 12037 255 131050 17537 13078 0 11746 0 0 0 0 0 20:11:22 [100/100] 12617 262 137348 18405 13715 0 12319 0 0 0 0 0 20:11:24 [100/100] 13059 222 142222 19057 14207 0 12752 0 0 0 0 0 20:11:26 [100/100] 13584 264 148201 19838 14801 0 13267 0 0 0 0 0 20:11:28 [100/100] 14592 579 159193 21262 15911 0 14251 0 0 0 0 0 20:11:30 [100/100] 15372 288 167626 22334 16786 0 15023 0 0 0 0 0 20:11:32 [100/100] 16454 473 179045 23780 17847 0 16078 0 0 0 0 0 20:11:34 [100/100] 17325 364 188367 24924 18725 0 16930 0 0 0 0 0 20:11:37 [100/100] 17920 235 195183 25761 19338 0 17512 0 0 0 0 0 20:11:39 [100/100] 18180 342 198441 26237 19705 0 17775 0 0 0 0 0 20:11:41 [100/100] 18730 439 204838 27001 20298 0 18319 0 0 0 0 0 20:11:43 [100/100] 19082 339 208359 27499 20610 0 18660 0 0 0 0 0 20:11:45 [100/100] 19147 235 209439 27604 20701 0 18720 0 0 0 0 0 20:11:47 [100/100] 19152 214 209575 27668 20716 0 18723 0 0 0 0 0 20:11:49 [100/100] 19198 318 210300 27721 20791 0 18771 0 0 0 0 0 20:11:51 [100/100] 19160 314 210459 27626 20755 0 18732 0 0 0 0 0 20:11:53 [100/100] 19121 334 209917 27662 20806 0 18690 0 0 0 0 0 20:11:55 [100/100] 19112 344 209670 27673 20830 0 18686 0 0 0 0 0 20:11:57 [100/100] 19443 405 213126 28186 21245 0 19009 0 0 0 0 0 20:11:59 [100/100] 19647 408 215471 28568 21610 0 19212 0 0 0 0 0 20:12:01 [100/100] 19918 550 218369 28946 21907 0 19482 0 0 0 0 0 20:12:03 [100/100] 20392 568 222926 29469 22224 0 19944 0 0 0 0 0 20:12:05 [100/100] 20274 454 221525 29203 21954 0 19833 0 0 0 0 0 20:12:07 [100/100] 20499 446 223602 29435 22173 0 20038 0 0 0 0 0 20:12:09 [100/100] 20690 221 225800 29715 22407 0 20231 0 0 0 0 0 20:12:11 [100/100] 20822 297 228808 30086 22684 0 20477 0 0 0 0 0 20:12:13 [100/100] 21060 332 230079 30372 22946 0 20591 0 0 0 0 0 20:12:15 [100/100] 21214 333 231883 30633 23134 0 20741 0 0 0 0 0 20:12:17 [100/100] 21128 319 231166 30580 23052 0 20662 0 0 0 0 0 20:12:19 [100/100] 21132 239 231323 30511 23015 0 20672 0 0 0 0 0 20:12:21 [100/100] 21211 260 231797 30509 22955 0 20752 0 0 0 0 0 20:12:23 [100/100] 21138 245 231134 30469 22941 0 20679 0 0 0 0 0 Saved results to test_lhrsdb00002.xml 20:12:25 [0/100] 20952 18 229459 30215 22745 0 20495 99 0 0 0 0 Completed Run. |
可以看到数据是完全同步的！
在ora21c侧加压
1 2 3 4 | /usr/local/swingbench/bin/charbench -c /usr/local/swingbench/configs/SOE_Server_Side_V2.xml \ -u lhr -p lhr -cs //172.72.7.21/pdb2 -dt thin -uc 100 \ -a -v "users,tpm,tps,dml,cpu" \ -rr 2 -rt "00:02" -min 5 -max 5 -r "/tmp/test_lhrsdb.xml" |
过程：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 | [root@lhrdbbench /]# /usr/local/swingbench/bin/charbench -c /usr/local/swingbench/configs/SOE_Server_Side_V2.xml \ > -u lhr -p lhr -cs //172.72.7.21/pdb2 -dt thin -uc 100 \ > -a -v "users,tpm,tps,dml,cpu" \ > -rr 2 -rt "00:02" -min 5 -max 5 -r "/tmp/test_lhrsdb.xml" Author : Dominic Giles Version : 2.6.0.1137 Results will be written to /tmp/test_lhrsdb.xml. Time Users TPM TPS Select Insert Update Delete Commit Rollback User SystemWait Idle 20:26:10 [0/100] 0 0 0 0 0 0 0 0 0 0 0 0 20:26:12 [0/100] 0 0 0 0 0 0 0 0 0 0 0 0 20:26:14 [0/100] 0 0 0 0 0 0 0 0 0 0 0 0 20:26:17 [0/100] 0 0 0 0 0 0 0 0 0 0 0 0 20:26:19 [100/100] 0 0 0 0 0 0 0 0 0 0 0 0 20:26:21 [100/100] 76 76 617 18 15 0 74 17 0 0 0 0 20:26:23 [100/100] 321 138 3086 86 67 0 304 118 0 0 0 0 20:26:25 [100/100] 564 138 5527 163 133 0 539 241 0 0 0 0 20:26:27 [100/100] 859 151 8643 246 211 0 833 366 0 0 0 0 20:26:29 [100/100] 1198 188 12048 337 310 0 1162 495 0 0 0 0 20:26:31 [100/100] 1707 340 17288 492 460 0 1659 699 0 0 0 0 20:26:33 [100/100] 2644 504 26847 755 710 0 2566 1137 0 0 0 0 20:26:35 [100/100] 3379 316 34285 944 915 0 3284 1473 0 0 0 0 20:26:37 [100/100] 3927 274 39649 1097 1065 0 3810 1703 0 0 0 0 20:26:39 [100/100] 4470 277 45168 1263 1238 0 4337 1941 0 0 0 0 20:26:42 [100/100] 5100 365 51870 1449 1406 0 4945 2206 0 0 0 0 20:26:44 [100/100] 5607 153 57353 1591 1541 0 5439 2415 0 0 0 0 20:26:46 [100/100] 6060 212 61965 1708 1665 0 5872 2600 0 0 0 0 20:26:48 [100/100] 6489 235 66312 1834 1779 0 6287 2775 0 0 0 0 20:26:50 [100/100] 6896 203 70496 1953 1902 0 6684 2967 0 0 0 0 20:26:52 [100/100] 7352 242 74941 2079 2035 0 7123 3151 0 0 0 0 20:26:54 [100/100] 7791 175 79389 2201 2161 0 7541 3337 0 0 0 0 20:26:56 [100/100] 8203 215 83602 2313 2266 0 7938 3497 0 0 0 0 20:26:58 [100/100] 8607 219 87877 2430 2344 0 8332 3641 0 0 0 0 20:27:00 [100/100] 8959 189 91467 2529 2456 0 8667 3792 0 0 0 0 20:27:02 [100/100] 9607 343 98068 2708 2634 0 9293 4053 0 0 0 0 20:27:04 [100/100] 10439 413 106788 2953 2888 0 10104 4437 0 0 0 0 20:27:06 [100/100] 10981 242 112146 3116 3056 0 10626 4694 0 0 0 0 20:27:08 [100/100] 11770 405 120175 3324 3285 0 11387 5063 0 0 0 0 20:27:10 [100/100] 12199 216 124480 3435 3393 0 11801 5281 0 0 0 0 20:27:12 [100/100] 12624 189 128711 3561 3517 0 12211 5493 0 0 0 0 20:27:14 [100/100] 13023 169 133048 3662 3615 0 12595 5668 0 0 0 0 20:27:16 [100/100] 13402 180 137032 3773 3729 0 12963 5836 0 0 0 0 20:27:18 [100/100] 13809 203 141228 3891 3838 0 13357 5995 0 0 0 0 20:27:20 [100/100] 14653 446 149784 4123 4055 0 14180 6385 0 0 0 0 20:27:22 [100/100] 15161 227 155228 4276 4195 0 14674 6621 0 0 0 0 20:27:24 [100/100] 15404 215 157961 4330 4266 0 14918 6764 0 0 0 0 20:27:26 [100/100] 15572 207 159959 4365 4281 0 15079 6821 0 0 0 0 20:27:28 [100/100] 15642 182 160679 4397 4305 0 15139 6867 0 0 0 0 20:27:30 [100/100] 15759 233 161829 4429 4331 0 15249 6952 0 0 0 0 20:27:32 [100/100] 15887 384 163485 4462 4346 0 15360 7029 0 0 0 0 20:27:35 [100/100] 15818 444 162945 4445 4334 0 15302 6993 0 0 0 0 20:27:37 [100/100] 15896 458 163781 4468 4381 0 15377 7010 0 0 0 0 20:27:39 [100/100] 15976 302 164757 4497 4379 0 15456 7056 0 0 0 0 20:27:41 [100/100] 16103 322 166137 4515 4402 0 15574 7109 0 0 0 0 20:27:43 [100/100] 16132 379 166440 4525 4420 0 15605 7144 0 0 0 0 20:27:45 [100/100] 16179 303 166766 4542 4430 0 15650 7170 0 0 0 0 20:27:47 [100/100] 16261 221 167644 4575 4442 0 15732 7223 0 0 0 0 20:27:49 [100/100] 16163 141 166905 4538 4400 0 15635 7189 0 0 0 0 20:27:51 [100/100] 16227 228 167537 4550 4409 0 15694 7194 0 0 0 0 20:27:53 [100/100] 16116 169 166624 4528 4366 0 15589 7163 0 0 0 0 20:27:55 [100/100] 16079 179 166338 4526 4349 0 15565 7156 0 0 0 0 20:27:57 [100/100] 16021 182 165900 4507 4340 0 15515 7156 0 0 0 0 20:27:59 [100/100] 16000 166 165594 4510 4365 0 15487 7204 0 0 0 0 20:28:01 [100/100] 16071 247 166468 4526 4352 0 15562 7222 0 0 0 0 20:28:03 [100/100] 16144 417 167327 4569 4380 0 15645 7305 0 0 0 0 20:28:05 [100/100] 16235 393 167894 4576 4401 0 15723 7288 0 0 0 0 20:28:07 [100/100] 16385 326 169824 4604 4432 0 15878 7366 0 0 0 0 20:28:09 [100/100] 15974 196 165922 4523 4300 0 15485 7153 0 0 0 0 Saved results to test_lhrsdb00003.xml 20:28:11 [41/100] 15980 203 164781 4709 4297 0 15325 7020 0 0 0 0 Completed Run. |
同步正常！
查看性能数据
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！
其它内容不再截图。
OGG健康巡检
参考：https://www.xmmup.com/ogg-for-oraclejiankangxunjianguanfangjiaoben.html
1 2 3 4 | cd $OGG_HOME/lib/sql/healthcheck sqlplus sys/lhr@172.72.7.20/lhrsdb as sysdba @ogghc_install.sql @ogghc_run.sql |
双向同步测试完成，图形界面比较爽，完美！
能不能出个传统安装方式的教程
参考：https://www.xmmup.com/dbbao63xiangmufenxiangshiyongora2pgqianyioracle19cdaopg13bingshiyongoggpeizhishi.html/3#421_yuan_duan_an_zhuangOGG_ruan_jian
这个教程感觉源端跟目标端是分开的，如果像本文那样的架构，独立部署，实现远程抽取和投递，传统方式怎么安装，并且源和目标端的数据库版本还不一样
一样的