一、源端数据库配置：

开启归档
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）后重启服务：
将RLOG_APPEND_LOGIC修改为1
#vi /home/dmdba/dm/dmdbms/bin/dm.ini
#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

##拷贝DM7数据库bin目录下对应的.so文件到DMHS下的bin目录下，从没执行过这一步

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

三、配置目标端DMHS

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>2</chk_interval>
<ckpt_interval>45</ckpt_interval>
<siteid>2</siteid>
</base>
<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>
<db_name></db_name>
<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>
<exec_policy>2</exec_policy>
<msg_col_size>8000</msg_col_size>
<level>0</level>
<affect_row>0</affect_row>
<tag>
<schema>D5000</schema>
<sql>update D5000.DY_DOWNLOAD_SIGNAL set DOWNLOAD_FLAG=0,MODIFY_TIME=sysdate where table_name_eng=lcase('%s');</sql>
<before_commit>0</before_commit>
</tag>
</exec>
</recv>

</dmhs>

cd /home/dmdba/dm/dmhs/bin
chmod 775 dmhs_serverd
./dmhs_serverd start

连自己
./dmhs_console
DMHS> connect 192.168.124.129:5345
DMHS> start exec

四、配置源端DMHS

使用manager执行脚本

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

检查
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';

vi /home/dmdba/dm/dmhs/bin/dmhs.hs

<?xml version="1.0" encoding="GB2312" standalone="no"?>
<dmhs>
<base>
<lang>ch</lang>
<mgr_port>5345</mgr_port>
<chk_interval>3</chk_interval>
<ckpt_interval>60</ckpt_interval>
<siteid>1</siteid>
<version>2.0</version>
</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>
<dict_dir>/dbbak/dmhs_dict</dict_dir>
<char_code>PG_GB18030</char_code>
<ddl_mask>OBJ:OP</ddl_mask>
<arch>
<clear_interval>600</clear_interval>
<clear_flag>1</clear_flag>
</arch>
<send>
<ip>192.168.124.129</ip>
<mgr_port>5345</mgr_port>
<data_port>5346</data_port>
<net_pack_size>256</net_pack_size>
<net_turns>0</net_turns>
<crc_check>0</crc_check>
<trigger>1</trigger>
<constraint>0</constraint>
<identity>0</identity>
<filter>
<enable>
<item>.</item>
</enable>

</filter>
<map>
</map>
</send>
</cpt>
</dmhs>

cd /home/dmdba/dm/dmhs/bin
chmod 775 dmhs_serverd
./dmhs_serverd start

./dmhs_console
DMHS> connect 192.168.124.100:5345
DMHS> clear exec lsn
DMHS> copy 0 "sch.name='SYSDBA'" DICT|LSN|CREATE|INSERT|INDEX
DMHS> start cpt
##state

测试：
SQL> create table test (a varchar2(10));
SQL>insert into test a values (1);
SQL>commit;

达梦数据库hs单向安装步骤

./dmserverd restart

作者