测试环境双向HS安装部署

一、源端数据库配置：

开启归档
SELECT ARCH_DEST, ARCH_FILE_SIZE FROM SYS.V$DM_ARCH_INI WHERE ARCH_TYPE='LOCAL' AND ARCH_IS_VALID='Y';

检查在线日志
select path from sys.v$rlogfile;

检查FAST_COMMIT参数，FAST_COMMIT参数要为0：
select para_value from v$dm_ini where para_name = 'FAST_COMMIT';

开启逻辑日志（一般未开启）
SELECT PARA_VALUE FROM SYS.V$DM_INI WHERE PARA_NAME = 'RLOG_APPEND_LOGIC';
未开启需要开启：
alter system set 'RLOG_APPEND_LOGIC' = 1 both;
#或修改配置文件（将RLOG_APPEND_LOGIC修改为1）后重启服务：
#vi /home/dmdba/dm/dmdbms/bin/dm.ini
#将RLOG_APPEND_LOGIC修改为1
#cd /home/dmdba/dm/dmdbms/bin
#./dmserverd restart

二、源端、目标端安装DMHS
上传至/opt/dm
chmod +x /opt/dm/*
chown dmdba:dinstall /opt/dm/*

su - dmdba
cd /opt/dm
./dmhs_V4.3.06_dm7_rev125464_rh6_64_veri_20230306_sp6.bin -i

/home/dmdba/dm/dmhs/db/bin:/usr/local/lib

cp /home/dmdba/dm/dmhs/bin/service_template/DmhsService /home/dmdba/dm/dmhs/bin/dmhs_serverd
vi /home/dmdba/dm/dmhs/bin/dmhs_serverd
DMHS_HOME=/home/dmdba/dm/dmhs
PROG_DIR=/home/dmdba/dm/dmhs/bin
CONF_PATH=/home/dmdba/dm/dmhs/bin/dmhs.hs

使用manager执行DDL脚本(disql 字符集可能会有问题)

`/home/dmdba/dm/dmhs/scripts/ddl_sql_dm7.sql;

检查，会出现DMHS表DDL表
SQL> select owner, table_name from dba_tables where owner = 'SYSDBA' and table_name like 'DMHS%' and status = 'VALID';

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

修改源端dmhs.sh

vi /home/dmdba/dm/dmhs/bin/dmhs.hs
<?xml version="1.0" encoding="GB2312"?>
<dmhs>
<base>
<lang>ch</lang>
<mgr_port>5345</mgr_port>
<chk_interval>3</chk_interval>
<ckpt_interval>60</ckpt_interval>
<siteid>1</siteid>
</base>
<cpt>
<db_type>dm7</db_type>
<db_server>127.0.0.1</db_server>
<db_user>SYSDBA</db_user>
<db_pwd>SYSDBA</db_pwd>
<db_port>5236</db_port>
<idle_time>300</idle_time>
<dict_dir>/dbbak/dmhs_dict</dict_dir>
<ddl_mask>obj:op</ddl_mask>
<parse_thr>1</parse_thr>
<parse_policy>8</parse_policy>
<arch>
<clear_interval>600</clear_interval>
<clear_flag>0</clear_flag>
<bak_dir></bak_dir>
</arch>
<send>
<ip>192.168.124.129</ip>
<mgr_port>5345</mgr_port>
<data_port>5346</data_port>
<trigger>1</trigger>
<constraint>0</constraint>
<identity>0</identity>
<net_turns>0</net_turns>
<filter>
<enable>
<item>.</item>
</enable>
<disable>
<item></item>
</disable>
</filter>
<map>
<item></item>
</map>
</send>
</cpt>
<recv>
<data_port>5346</data_port>
<exec>
<db_type>DM7</db_type>
<db_server>127.0.0.1</db_server>
<db_user>SYSDBA</db_user>
<db_pwd>SYSDBA</db_pwd>
<db_port>5236</db_port>
<exec_mode>1</exec_mode>
<exec_thr>16</exec_thr>
<exec_sql>512</exec_sql>
<exec_trx>5000</exec_trx>
<exec_rows>250</exec_rows>
<case_sensitive>1</case_sensitive>
<toggle_case>0</toggle_case>
<exec_policy>2</exec_policy>
<COMMIT_policy>1</COMMIT_policy>
<enable_merge>1</enable_merge>
<level>0</level>
</exec>
</recv>
</dmhs>

目标端DMHS
注意:同一进程的双向同步，目的端和源里既要配置cpt模块，还要配置exec模块，配完请核对参数的正确性。新建字典存目录，如果数据库是HA架构的话，需将字典目录创建在存储分区上。

vi /home/dmdba/dm/dmhs/bin/dmhs.hs
<?xml version="1.0" encoding="GB2312"?>
<dmhs>
<base>
<lang>ch</lang>
<mgr_port>5345</mgr_port>
<chk_interval>3</chk_interval>
<ckpt_interval>60</ckpt_interval>
<siteid>2</siteid>
</base>
<cpt>
<db_type>dm7</db_type>
<db_server>127.0.0.1</db_server>
<db_user>SYSDBA</db_user>
<db_pwd>SYSDBA</db_pwd>
<db_port>5236</db_port>
<idle_time>300</idle_time>
<dict_dir>/dbbak/dmhs_dict</dict_dir>
<ddl_mask>obj:op</ddl_mask>
<parse_thr>1</parse_thr>
<parse_policy>8</parse_policy>
<arch>
<clear_interval>600</clear_interval>
<clear_flag>0</clear_flag>
<bak_dir></bak_dir>
</arch>
<send>
<ip>192.168.124.100</ip>
<mgr_port>5345</mgr_port>
<data_port>5346</data_port>
<trigger>1</trigger>
<constraint>0</constraint>
<identity>0</identity>
<net_turns>0</net_turns>
<filter>
<enable>
<item>.</item>
</enable>
<disable>
<item></item>
</disable>
</filter>
<map>
<item></item>
</map>
</send>
</cpt>
<recv>
<data_port>5346</data_port>
<exec>
<db_type>DM7</db_type>
<db_server>127.0.0.1</db_server>
<db_user>SYSDBA</db_user>
<db_pwd>SYSDBA</db_pwd>
<db_port>5236</db_port>
<exec_mode>1</exec_mode>
<exec_thr>16</exec_thr>
<exec_sql>512</exec_sql>
<exec_trx>5000</exec_trx>
<exec_rows>250</exec_rows>
<case_sensitive>1</case_sensitive>
<toggle_case>0</toggle_case>
<exec_policy>2</exec_policy>
<COMMIT_policy>1</COMMIT_policy>
<enable_merge>1</enable_merge>
<level>0</level>
</exec>
</recv>
</dmhs>

cd /home/dmdba/dm/dmhs/bin
chmod +x dmhs_serverd
./dmhs_serverd start

主
./dmhs_console
DMHS> connect 192.168.124.129:5345
DMHS> start exec

备
./dmhs_console
DMHS> connect 192.168.124.100:5345
DMHS> start exec

达梦社区地址 https://eco.dameng.com

测试环境双向HS安装部署

作者