暂无图片
暂无图片
暂无图片
暂无图片
暂无图片
首页 / 达梦数据库DM8->DM8：dmhs单向同步

达梦数据库DM8->DM8：dmhs单向同步

yuanzj 2021-06-09
2223

一、实验环境

1实验环境配置基本信息

源端->目标端

DM8-->DM8
OS版本
OracleLinux-R7-U9-Server-x86_64-dvd.iso
DMHS版本
dmhs_V3.1.3_dm8_rev99813_rh6_64_veri_20210527_beta_20210527.zip
数据库
dm8_20210507_x86_rh7_64_ent_8.1.2.2_pack4.iso
dm8_20210508_x86_rh6_64_ent_8.1.2.2_pack4_dmdci.zip
源端IP
192.168.3.92
目标端IP
192.168.3.93
源端HS
安装用户：root
DMHS_HOME=/opt/dmhs
目的端HS
安装用户：root
DMHS_HOME=/opt/dmhs
传输用户‍DMHS
同步用户
YUANZJ

2.hsem和dem信息

元数据库IP‍192.168.3.93
元数据库模式
hsem/dem
jdk版本
jdk-8u291-linux-x64.tar.gz
tomcat版本
apache-tomcat-9.0.46.tar.gz
tomcat路径
/opt/apache-tomcat-9.0.46

3.源端达梦数据库开启归档和逻辑日志

1.开启归档，执行以下sql

    alter database mount;
    alter database archivelog;
    alter database add archivelog 'dest = dmarch, type = local, file_size =512, space_limit =51200';
    alter database open;

    2.开启逻辑日志，执行以下sql

      sp_set_para_value(2,'RLOG_APPEND_LOGIC',1);

      4.源端和目的端新建dmhs用户

        SQL> create user dmhs identified by dmhs12345 default tablespace main default index tablespace main;
        操作已执行
        已用时间: 18.295(毫秒). 执行号:300.
        SQL> grant dba to dmhs;
        操作已执行
        已用时间: 1.318(毫秒). 执行号:301.

        5.执行脚本，配置DMHS支持DDL

        在源端使用管理登录SYSDBA用户，执行ddl_sql_dm8.sql脚本，过程略

        验证是否成功

        检查辅助表

          select owner, table_name from dba_tables where owner = 'SYSDBA' and table_name like 'DMHS%' and status = 'VALID'; 
          行号 OWNER TABLE_NAME 
          ---------- ------ --------------- 
          1 SYSDBA DMHS_DDL_COL 
          2 SYSDBA DMHS_DDL_SQL 
          3 SYSDBA DMHS_DDL_CONS 
          4 SYSDBA DMHS_DDL_IDX 
          5 SYSDBA DMHS_DDL_RENAME 
          6 SYSDBA DMHS_DDL_SEQ 
          7 SYSDBA DMHS_DDL_PART 
          7 rows got 
          已用时间: 197.302(毫秒). 执行号:7.

          检查触发器

            select owner, trigger_name from dba_triggers where owner = 'SYSDBA' and trigger_name like 'DMHS%' and status = 'Y'; 
            行号 OWNER TRIGGER_NAME 
            ---------- ------ ----------------------- 
            1 SYSDBA DMHS_DDL_TRIGGER_AFTER 
            2 SYSDBA DMHS_DDL_TRIGGER_BEFORE 
            3 SYSDBA DMHS_DDL_TRIGGER_GRANT 
            4 SYSDBA DMHS_DDL_TRIGGER_REVOKE 
            已用时间: 12.147(毫秒). 执行号:16.

            6.创建测试用户和测试数据

            1.创建测试用户

              SQL> create user yuanzj identified by yuanzj123 default tablespace main default index tablespace main;
              操作已执行
              已用时间: 18.295(毫秒). 执行号:300.
              SQL> grant dba to yuanzj;
              操作已执行
              已用时间: 1.318(毫秒). 执行号:301.

              2.创建测试数据
              登录yuanzj用户，执行下面sql

                CREATE TABLE DEPT
                       (DEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY,
                  DNAME VARCHAR2(14) ,
                  LOC VARCHAR2(13) ) ;
                CREATE TABLE EMP
                       (EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,
                  ENAME VARCHAR2(10),
                  JOB VARCHAR2(9),
                  MGR NUMBER(4),
                  HIREDATE DATE,
                  SAL NUMBER(7,2),
                  COMM NUMBER(7,2),
                  DEPTNO NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT);
                INSERT INTO DEPT VALUES
                  (10,'ACCOUNTING','NEW YORK');
                INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');
                INSERT INTO DEPT VALUES
                  (30,'SALES','CHICAGO');
                INSERT INTO DEPT VALUES
                  (40,'OPERATIONS','BOSTON');
                INSERT INTO EMP VALUES
                (7369,'SMITH','CLERK',7902,to_date('17-12-1980','dd-mm-yyyy'),800,NULL,20);
                INSERT INTO EMP VALUES
                (7499,'ALLEN','SALESMAN',7698,to_date('20-2-1981','dd-mm-yyyy'),1600,300,30);
                INSERT INTO EMP VALUES
                (7521,'WARD','SALESMAN',7698,to_date('22-2-1981','dd-mm-yyyy'),1250,500,30);
                INSERT INTO EMP VALUES
                (7566,'JONES','MANAGER',7839,to_date('2-4-1981','dd-mm-yyyy'),2975,NULL,20);
                INSERT INTO EMP VALUES
                (7654,'MARTIN','SALESMAN',7698,to_date('28-9-1981','dd-mm-yyyy'),1250,1400,30);
                INSERT INTO EMP VALUES
                (7698,'BLAKE','MANAGER',7839,to_date('1-5-1981','dd-mm-yyyy'),2850,NULL,30);
                INSERT INTO EMP VALUES
                (7782,'CLARK','MANAGER',7839,to_date('9-6-1981','dd-mm-yyyy'),2450,NULL,10);
                INSERT INTO EMP VALUES
                (7788,'SCOTT','ANALYST',7566,to_date('13-7-87','dd-mm-rr')-85,3000,NULL,20);
                INSERT INTO EMP VALUES
                (7839,'KING','PRESIDENT',NULL,to_date('17-11-1981','dd-mm-yyyy'),5000,NULL,10);
                INSERT INTO EMP VALUES
                (7844,'TURNER','SALESMAN',7698,to_date('8-9-1981','dd-mm-yyyy'),1500,0,30);
                INSERT INTO EMP VALUES
                (7876,'ADAMS','CLERK',7788,to_date('13-7-87', 'dd-mm-rr')-51,1100,NULL,20);
                INSERT INTO EMP VALUES
                (7900,'JAMES','CLERK',7698,to_date('3-12-1981','dd-mm-yyyy'),950,NULL,30);
                INSERT INTO EMP VALUES
                (7902,'FORD','ANALYST',7566,to_date('3-12-1981','dd-mm-yyyy'),3000,NULL,20);
                INSERT INTO EMP VALUES
                (7934,'MILLER','CLERK',7782,to_date('23-1-1982','dd-mm-yyyy'),1300,NULL,10);
                CREATE TABLE BONUS
                  (
                  ENAME VARCHAR2(10)  ,
                  JOB VARCHAR2(9)  ,
                  SAL NUMBER,
                  COMM NUMBER
                  ) ;
                CREATE TABLE SALGRADE
                      ( GRADE NUMBER,
                  LOSAL NUMBER,
                  HISAL NUMBER );
                INSERT INTO SALGRADE VALUES (1,700,1200);
                INSERT INTO SALGRADE VALUES (2,1201,1400);
                INSERT INTO SALGRADE VALUES (3,1401,2000);
                INSERT INTO SALGRADE VALUES (4,2001,3000);
                INSERT INTO SALGRADE VALUES (5,3001,9999);
                COMMIT;

                二、部署dmhs

                1.在源端和目的端分别建立$DMHS_HOME

                  mkdir -p opt/dmhs

                  2.在源端和目的端分别上传dmhs到/opt/dmhs

                    [root@yuanzjdm01 dmhs]# ls -lh
                    总用量 8.0K
                    drwxr-xr-x 4 root root 4.0K 6月   8 21:17 bin
                    drwxr-xr-x 2 root root 4.0K 6月   8 21:16 hs_agent

                        源端和目的端都按照此目录规划

                    3.在源端和目的端分别上传DMHS服务脚本到$DMHS_HOME/bin目录下

                      [root@yuanzjdm01 bin]# ls -ld service_template/
                      drwxr-xr-x 2 root root 4096 6月   8 21:17 service_template/

                             此目录文件包含服务启动脚本模板，模板含义见名知意（有此模板脚本，dmhs服务可以在hsem平台前台启动）：

                        [root@yuanzjdm01 bin]# ls -l service_template/
                        总用量 264
                        -rw-r--r-- 1 root root 14563 6月   8 21:17 AgentDb2Service
                        -rw-r--r-- 1 root root 14563 6月   8 21:17 AgentDm6Service
                        -rw-r--r-- 1 root root 14563 6月   8 21:17 AgentDm7Service
                        -rw-r--r-- 1 root root 14514 6月   8 21:17 AgentDm8Service
                        -rw-r--r-- 1 root root 14573 6月   8 21:17 AgentKingbaseService
                        -rw-r--r-- 1 root root 14567 6月   8 21:17 AgentMysqlService
                        -rw-r--r-- 1 root root 14567 6月   8 21:17 AgentOraService
                        -rw-r--r-- 1 root root 14575 6月   8 21:17 AgentPgService
                        -rw-r--r-- 1 root root 14497 6月   8 21:17 DmhsAgentService
                        -rw-r--r-- 1 root root 14546 6月   8 21:17 DmhsGuardService
                        -rw-r--r-- 1 root root 14499 6月   8 21:17 DmhsService
                        -rw-r--r-- 1 root root 14495 6月   8 21:17 DmhsStatService
                        -rw-r--r-- 1 root root 23952 6月   8 21:17 DmhsWebService
                        -rw-r--r-- 1 root root 12446 6月   8 21:17 DmService
                        -rw-r--r-- 1 root root 12916 6月   8 21:17 TemplateDmhsAgentService
                        -rw-r--r-- 1 root root 14583 6月   8 21:17 TemplateDmhsService

                        注意：源端和目的端都上传此脚本到$DMHS_HOME/bin目录下

                        4.在源端和目的端分别上传dmoci到$DMHS_HOME/hs_agent目录下：

                        过程略

                        5.创建dmhs环境，以源端为例：

                          [root@yuanzjdm01 ~]# vim .bash_profile 


                          # .bash_profile


                          # Get the aliases and functions
                          if [ -f ~/.bashrc ]; then
                                  . ~/.bashrc
                          fi


                          # User specific environment and startup programs


                          PATH=$PATH:$HOME/bin


                          export PATH


                          PS1=[`whoami`@`hostname`:'$PWD]$ ';  export PS1


                          export DMHS_HOME=/opt/dmhs
                          export LD_LIBRARY_PATH=$DMHS_HOME/bin:$DMHS_HOME/hs_agent:$LD_LIBRARY_PATH
                          [root@yuanzjdm01 ~]# . .bash_profile 
                          [root@yuanzjdm01:/root]$ 

                          6.启动hs_agent服务

                          1.目的端新建dmhs_agent.xml文件

                            [root@yuanzjdm02:/opt/dmhs/hs_agent]$ vim dmhs_agent.xml 


                            <?xml version="1.0" encoding="GB2312"?>
                            <hs_agent>
                                <name>HsAgent</name>
                                <server_ip>192.168.3.93</server_ip>
                                    <lsn_port>5456</lsn_port>
                                <status_interval>3</status_interval>
                                <status_server>192.168.3.93</status_server>
                                <status_port>5236</status_port>
                                <status_user>SYSDBA</status_user>
                                <status_pwd>SYSDBA123</status_pwd>
                                <dmhs_support>1</dmhs_support>
                                <veri_support>1</veri_support>
                                <lang>ch</lang>
                            </hs_agent>

                            2.启动agent服务

                            编辑启动脚本，添加环境，数据库字符集环境


                            3.启动脚本

                              [root@yuanzjdm02:/opt/dmhs/hs_agent]$ ./DmhsAgentService  start
                              Starting DmhsAgentService:                                 [ OK ]

                              4.源端新建dmhs_agent.xml文件

                                [root@yuanzjdm01:/opt/dmhs/hs_agent]$ vim dmhs_agent.xml 


                                <?xml version="1.0" encoding="GB2312"?>
                                <hs_agent>
                                    <name>HsAgent</name>
                                    <server_ip>192.168.3.92</server_ip>
                                        <lsn_port>5456</lsn_port>
                                    <status_interval>3</status_interval>
                                    <status_server>192.168.3.93</status_server>
                                    <status_port>5236</status_port>
                                    <status_user>SYSDBA</status_user>
                                    <status_pwd>SYSDBA123</status_pwd>
                                    <dmhs_support>1</dmhs_support>
                                    <veri_support>1</veri_support>
                                    <lang>ch</lang>
                                </hs_agent>

                                5.启动agent服务

                                编辑启动脚本，添加环境，数据库字符集环境

                                6.启动脚本

                                  [root@yuanzjdm01:/opt/dmhs/hs_agent]$ ./DmhsAgentService  start
                                  Starting DmhsAgentService:                                 [ OK ]

                                  7.在hsem平台配置dmhs实例

                                  1.新建目的端dmhs实例，先点击HsAgent（192.168.3.93），右键添加HS实例，点击确定

                                  2.启动SH实例，右键HS-dm8_02(5345),启动hs实例

                                  过程略

                                  3.启动exec模块，右键exec，选择启动

                                  过程略

                                  4.新建源端dmhs实例，先点击HsAgent（192.168.3.92），右键添加HS实例，点击确定

                                  5.修改源端配置

                                  1.添加过滤规则

                                  2.添加映射规则

                                  6.启动HS实例，右键HS-dm8_01(5345),启动hs实例

                                  过程略

                                  7.源端加载数据字典：

                                  1.登录控制台：

                                    [root@yuanzjdm01:/opt/dmhs/INST_HS/dm8_01]$ ./dmhs_console 
                                    DMHS console tool: V4.1.1-Build(2021.05.27-99813_beta)_D64
                                    Copyright (c) 2020, DMHS. All rights reserved.
                                    Type ? or "help" for help, type "quit" to quit console.


                                    Connected to DMHS: 127.0.0.1:5345
                                    execute success
                                    Dameng HS Server V4.1.1-Build(2021.05.27-99813_beta)_D64


                                    DMHS> clear exec lsn
                                    execute success


                                    DMHS>  load 0 "sch.name='YUANZJ'" dict|create|insert|index
                                    copy mask is : |CREATE|INSERT|INDEX|TABLE|DICT|OBJID|REP
                                    execute finish, please look up log file of exec module to check data load result


                                    DMHS> start cpt
                                    execute success


                                    DMHS> 

                                    2.查看日志信息

                                      [root@yuanzjdm01:/opt/dmhs/INST_HS/dm8_01]$ tail -f log/dmhs_202106.log 
                                      2021-06-09 05:41:52 MGR[INFO]: DMHS start up, current version: V4.1.1-Build(2021.05.27-99813_beta)_D64 (The beta)(Enterprise Edition)
                                      2021-06-09 05:41:52 MGR[WARN]: License will expire on 2021-08-27
                                      2021-06-09 05:41:52 MGR[INFO]: load config file successful,site no:5, manager port :5345, poll interval:3
                                      2021-06-09 05:41:53 MGR[INFO]: manager listening  port:5345
                                      2021-06-09 05:41:58 MGR[INFO]: connection from 192.168.3.92 has broken!
                                      2021-06-09 05:42:04 MGR[INFO]: connection from 192.168.3.93 has broken!
                                      2021-06-09 05:42:23 MGR[INFO]: monitor  192.168.3.92 's login
                                      2021-06-09 05:42:23 MGR[INFO]: monitor  192.168.3.92 's login
                                      2021-06-09 05:42:23 MGR[INFO]: monitor  192.168.3.92 's login
                                      2021-06-09 05:44:08 MGR[INFO]: monitor  127.0.0.1 's login
                                      2021-06-09 05:44:35 PUB[INFO]: set enable_directio = 0
                                      2021-06-09 05:44:35 MGR[INFO]: loading DM8 log analysis...
                                      2021-06-09 05:44:35 CPT[INFO]: DM8_V3.1.2_D64
                                      2021-06-09 05:44:35 CPT[INFO]: send_lst is 3
                                      2021-06-09 05:44:35 CPT[WARN]: DM8 IS SUPPORT UNICODE: TRUE
                                      2021-06-09 05:44:35 CPT[INFO]: DM8 parameter LENGTH_IN_CHAR: 0
                                      2021-06-09 05:44:35 CPT[INFO]: DM8 RLOG_APPEND_SYSTAB_LOGIC = 0, then using DMHS auxiliary table and triggers for DDL sync.
                                      2021-06-09 05:44:35 CPT[INFO]: DM8 log format is RLOG_PKG, arch: dmarch/ARCHIVE_LOCAL1_0x75364BB8[0]_2021-06-08_23-31-54.log, db_magic: 1966492600 - 1966492600
                                      2021-06-09 05:44:35 CPT[INFO]: DM8 archive directory: dmarch archive file size:512 M
                                      2021-06-09 05:44:35 CPT[INFO]: dm8 log version flag is : 2, old: 0
                                      2021-06-09 05:44:35 CPT[INFO]: [0]Searched archived file number: 3, START_ARCH_LSN: 0, START_FILE: null, VER: 1
                                      2021-06-09 05:44:35 CPT[INFO]: DM8 CPT is created.
                                      2021-06-09 05:44:35 CPT[INFO]: DM8 CPT is free.
                                      2021-06-09 05:44:35 SND[INFO]: Loading filter info: 
                                      2021-06-09 05:44:35 SND[INFO]:   ENABLE: YUANZJ.*
                                      2021-06-09 05:44:35 SND[INFO]: Loading col map: 
                                      2021-06-09 05:44:35 SND[INFO]: Analysis module 192.168.3.93:5346 's log sending thread created successfully
                                      2021-06-09 05:44:35 SND[INFO]: Analysis module  5 are connecting to  site 192.168.3.93:5346...
                                      2021-06-09 05:44:35 SND[INFO]: the analysis module 5 are resetting  192.168.3.93:5346 site 's execute module...
                                      2021-06-09 05:44:35 SND[INFO]: Analysis module  5 are sending the map rules...
                                      2021-06-09 05:44:35 SND[INFO]:   YUANZJ.*==YUANZJ.*...
                                      2021-06-09 05:44:35 SND[INFO]: The analysis module 5 are getting the min LSN from site 192.168.3.93:5346...
                                      2021-06-09 05:44:35 SND[INFO]: analysis module 5 get LSN:27283 LFS:0 successfully
                                      2021-06-09 05:44:36 MGR[INFO]: setting destion 192.168.3.93:5345 net lock mode:DISABLE
                                      2021-06-09 05:44:36 MGR[INFO]: send commnd to site 192.168.3.93:5345 success
                                      2021-06-09 05:44:36 PUB[WARN]: use char_code:PG_UTF8
                                      2021-06-09 05:44:36 SND[INFO]: Analysis module are checking the execute module complete all transactions...
                                      2021-06-09 05:44:36 SND[INFO]: 192.168.3.93:5346 to site 5 's sending thread has quited
                                      2021-06-09 05:46:29 PUB[INFO]: set enable_directio = 0
                                      2021-06-09 05:46:29 MGR[INFO]: loading DM8 log analysis...
                                      2021-06-09 05:46:29 SND[INFO]: Loading filter info: 
                                      2021-06-09 05:46:29 SND[INFO]:   ENABLE: YUANZJ.*
                                      2021-06-09 05:46:29 SND[INFO]: Loading col map: 
                                      2021-06-09 05:46:29 SND[INFO]: Analysis module 192.168.3.93:5346 's log sending thread created successfully
                                      2021-06-09 05:46:29 SND[INFO]: Analysis module  5 are connecting to  site 192.168.3.93:5346...
                                      2021-06-09 05:46:29 SND[INFO]: the analysis module 5 are resetting  192.168.3.93:5346 site 's execute module...
                                      2021-06-09 05:46:29 SND[INFO]: Analysis module  5 are sending the map rules...
                                      2021-06-09 05:46:29 SND[INFO]:   YUANZJ.*==YUANZJ.*...
                                      2021-06-09 05:46:29 SND[INFO]: The analysis module 5 are getting the min LSN from site 192.168.3.93:5346...
                                      2021-06-09 05:46:29 SND[INFO]: analysis module 5 get LSN:29240 LFS:0 successfully
                                      2021-06-09 05:46:30 MGR[INFO]: setting destion 192.168.3.93:5345 net lock mode:DISABLE
                                      2021-06-09 05:46:30 MGR[INFO]: send commnd to site 192.168.3.93:5345 success
                                      2021-06-09 05:46:30 PUB[WARN]: use char_code:PG_UTF8
                                      2021-06-09 05:46:30 CPT[INFO]: DM8 RLOG_APPEND_SYSTAB_LOGIC = 0, then using DMHS auxiliary table and triggers for DDL sync.
                                      2021-06-09 05:46:30 CPT[INFO]: load table info...
                                      2021-06-09 05:46:30 CPT[INFO]: number of loaded user table dictionary: 4
                                      2021-06-09 05:46:30 CPT[INFO]: load col info...
                                      2021-06-09 05:46:30 CPT[INFO]: load col info...
                                      2021-06-09 05:46:30 CPT[INFO]: load part table info...
                                      2021-06-09 05:46:30 CPT[INFO]: save dict...
                                      2021-06-09 05:46:30 LD[INFO]: load DM8 instance name: DMSERVER
                                      2021-06-09 05:46:30 LD[INFO]: DM8 parameter LENGTH_IN_CHAR: 0
                                      2021-06-09 05:46:30 LD[INFO]: loading table YUANZJ.BONUS(1:4), operation:ALL
                                      2021-06-09 05:46:30 LD[INFO]: INSERT:.YUANZJ.BONUS
                                      2021-06-09 05:46:30 LD[INFO]: lock table:lock table "YUANZJ"."BONUS"  in share mode nowait
                                      2021-06-09 05:46:30 LD[INFO]: set table .YUANZJ.BONUS start LSN: 0
                                      2021-06-09 05:46:30 LD[WARN]: set table .YUANZJ.BONUS start LSN: 29244
                                      2021-06-09 05:46:30 LD[INFO]: table YUANZJ.BONUS insert complete ,total  0 rows
                                      2021-06-09 05:46:30 LD[INFO]: loading table YUANZJ.DEPT(2:4), operation:ALL
                                      2021-06-09 05:46:30 LD[INFO]: INSERT:.YUANZJ.DEPT
                                      2021-06-09 05:46:30 LD[INFO]: lock table:lock table "YUANZJ"."DEPT"  in share mode nowait
                                      2021-06-09 05:46:30 LD[INFO]: set table .YUANZJ.DEPT start LSN: 0
                                      2021-06-09 05:46:30 LD[WARN]: set table .YUANZJ.DEPT start LSN: 29244
                                      2021-06-09 05:46:30 LD[INFO]: table YUANZJ.DEPT insert complete ,total  4 rows
                                      2021-06-09 05:46:30 LD[INFO]: loading table YUANZJ.EMP(3:4), operation:ALL
                                      2021-06-09 05:46:30 LD[INFO]: INSERT:.YUANZJ.EMP
                                      2021-06-09 05:46:30 LD[INFO]: lock table:lock table "YUANZJ"."EMP"  in share mode nowait
                                      2021-06-09 05:46:30 LD[INFO]: set table .YUANZJ.EMP start LSN: 0
                                      2021-06-09 05:46:30 LD[WARN]: set table .YUANZJ.EMP start LSN: 29244
                                      2021-06-09 05:46:30 LD[INFO]: table YUANZJ.EMP insert complete ,total  14 rows
                                      2021-06-09 05:46:30 LD[INFO]: loading table YUANZJ.SALGRADE(4:4), operation:ALL
                                      2021-06-09 05:46:30 LD[INFO]: INSERT:.YUANZJ.SALGRADE
                                      2021-06-09 05:46:30 LD[INFO]: lock table:lock table "YUANZJ"."SALGRADE"  in share mode nowait
                                      2021-06-09 05:46:30 LD[INFO]: set table .YUANZJ.SALGRADE start LSN: 0
                                      2021-06-09 05:46:30 LD[WARN]: set table .YUANZJ.SALGRADE start LSN: 29244
                                      2021-06-09 05:46:30 LD[INFO]: table YUANZJ.SALGRADE insert complete ,total  5 rows
                                      2021-06-09 05:46:30 LD[INFO]: The loading operation was successful.A total of 4 tables were successfully loaded!
                                      2021-06-09 05:46:30 SND[INFO]: Analysis module are checking the execute module complete all transactions...
                                      2021-06-09 05:46:30 SND[INFO]: 192.168.3.93:5346 to site 5 's sending thread has quited
                                      2021-06-09 05:46:40 MGR[INFO]: init the analysis module...
                                      2021-06-09 05:46:40 PUB[INFO]: set enable_directio = 0
                                      2021-06-09 05:46:40 MGR[INFO]: loading DM8 log analysis...
                                      2021-06-09 05:46:40 CPT[INFO]: DM8_V3.1.2_D64
                                      2021-06-09 05:46:40 CPT[INFO]: send_lst is 3
                                      2021-06-09 05:46:40 CPT[WARN]: DM8 IS SUPPORT UNICODE: TRUE
                                      2021-06-09 05:46:40 CPT[INFO]: DM8 parameter LENGTH_IN_CHAR: 0
                                      2021-06-09 05:46:40 CPT[INFO]: DM8 RLOG_APPEND_SYSTAB_LOGIC = 0, then using DMHS auxiliary table and triggers for DDL sync.
                                      2021-06-09 05:46:40 CPT[INFO]: DM8 log format is RLOG_PKG, arch: /dmarch/ARCHIVE_LOCAL1_0x75364BB8[0]_2021-06-08_23-31-54.log, db_magic: 1966492600 - 1966492600
                                      2021-06-09 05:46:40 CPT[INFO]: DM8 archive directory: /dmarch archive file size:512 M
                                      2021-06-09 05:46:40 CPT[INFO]: [0]Searched archived file number: 3, START_ARCH_LSN: 0, START_FILE: null, VER: 1
                                      2021-06-09 05:46:40 CPT[INFO]: DM8 CPT is created.
                                      2021-06-09 05:46:40 MGR[INFO]: setting destion 192.168.3.93:5345 net lock mode:DISABLE
                                      2021-06-09 05:46:40 MGR[INFO]: send commnd to site 192.168.3.93:5345 success
                                      2021-06-09 05:46:40 MGR[INFO]: get the site 192.168.3.93:5345 min LSN...
                                      2021-06-09 05:46:40 MGR[INFO]: get site (192.168.3.93:5345) LSN: 29240 successful...
                                      2021-06-09 05:46:40 SND[INFO]: Loading filter info: 
                                      2021-06-09 05:46:40 SND[INFO]:   ENABLE: YUANZJ.*
                                      2021-06-09 05:46:40 SND[INFO]: Loading col map: 
                                      2021-06-09 05:46:40 CPT[INFO]: DM8 CPT is ready.
                                      2021-06-09 05:46:40 MGR[INFO]: log analysis start success
                                      2021-06-09 05:46:40 SND[INFO]: Analysis module 192.168.3.93:5346 's log sending thread created successfully
                                      2021-06-09 05:46:40 SND[INFO]: Analysis module  5 are connecting to  site 192.168.3.93:5346...
                                      2021-06-09 05:46:40 SND[INFO]: the analysis module 5 are resetting  192.168.3.93:5346 site 's execute module...
                                      2021-06-09 05:46:40 CPT[INFO]: start LSN :29240 located in log file: /dmarch/ARCHIVE_LOCAL1_0x75364BB8[0]_2021-06-09_04-40-44.log
                                      2021-06-09 05:46:40 SND[INFO]: Analysis module  5 are sending the map rules...
                                      2021-06-09 05:46:40 SND[INFO]:   YUANZJ.*==YUANZJ.*...
                                      2021-06-09 05:46:40 SND[INFO]: The analysis module 5 are getting the min LSN from site 192.168.3.93:5346...
                                      2021-06-09 05:46:40 SND[INFO]: analysis module 5 get LSN:29240 LFS:0 successfully

                                      三、测试ddl

                                      1.在源端创建emp_test表，并插入数据

                                      2.在目的端查看数据


                                      四、总结

                                      1.在创建dmhs实例时，一定要先创建目的端实例；

                                      2.修改启动脚本字符集时，一定要与数据库字符集保持一致；

                                      3.单向同步，只需要源端开启逻辑日志即可。


                                      数据库
                                      最后修改时间：2021-06-09 15:19:55
                                      文章转载自yuanzj，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

                                      评论