搭建dmhs dm8-dm8

1 准备两台虚拟机，分别安装dm8，dmhs安装在/dmhs目录下.

2.分别修改两台机的达梦dm.ini

ARCH_INI = 1 
RLOG_APPEND_LOGIC = 1

3.新建归档文件 dmarch.ini

[ARCHIVE_LOCAL1] 
ARCH_TYPE = LOCAL 
ARCH_DEST = /opt/dmdbms/arch 
ARCH_SPACE_LIMIT = 0 

4.查看配置是否正确。

SELECt ARCH_DEST, ARCH_FILE_SIZE FROM SYS.V$DM_ARCH_INI WHERe ARCH_TYPE='LOCAL' AND ARCH_IS_VALID='Y;

SELECt PARA_VALUE FROM SYS.V$DM_INI WHERe PARA_NAME = ‘RLOG_APPEND_LOGIC’;

SELECt PATH FROM SYS.V$RLOGFILE;

select para_value from v$dm_ini where para_name = ‘FAST_COMMIT’;

5.配置目的端的 dmhs.hs:

     
    en    
    5345    
    60    
    2    
    2.0

    
  
    5346    
  
  dm8    
  192.168.239.3    
  SYSDBA    
  SYSDBA    
  5236    
      
  PG_GB18030
  4    
  1024    
   5000     
  1000    
 

6.启动目的端dmhs
./dmhs_server dmhs.hs
start exec

若报这个错误：

复制一份 libdmoci.so 到bin目录下

7 . 源端配置：
7.1. 配置DDL：
启动disql
执行 start /dmhs_dm8/scripts/ddl_sql_dm8.sql（可能是脚本注释有问题，disql运行脚本会报错，用manager运行脚本）
7.2. 验证ddl：

select owner, table_name from dba_tables where owner = 'SYSDBA' and table_name like 'DMHS%' and status = 'VALID';

select owner, trigger_name from dba_triggers where owner = 'SYSDBA' and trigger_name like 'DMHS%' and status = 'Y';

8.7. 配置源端dmhs.hs:

 

 
en
 5345
 60
 1
2.0
 
 
 dm8
 127.0.0.1
 SYSDBA
 SYSDBA
 5236
 
 
 1
 op:obj 
 
 600
 0
 
 
 192.168.239.3
 5345
 5346
 1
 1
 1
 0
 
 
SYSDBA.*
 
 
 
 
 

9.启动源端，开始同步（bin目录下）：

./dmhs_server dmhs.hs 
clear exec lsn #为了初始化日志的起始位置。
COPY 0 “ SCH.NAME=’SYSDBA’ ” CREATE|INSERT|DICT #装载数据，配置同步掩码
start cpt

社区地址：https://eco.dameng.com