dmhs单向部署

dmhs搭建部署
开启归档和逻辑日志
vim dm.ini
ARCH_INI = 1
RLOG_APPEND_LOGIC = 1
重启数据库，使配置文件生效

检查归档日志
select arch_mode from v$database;

检查逻辑追加日志
select para_value from v$dm_ini where para_name='RLOG_APPEND_LOGIC';
![image.png](https://download.dameng.com/eco-file-
server/file/eco/preview/2023122501261880AVIWG9JIL35RBYBZ)

安装dmhs的安装

源端：
如果需要配置文件中配置DDL同步，那么需要创建DDL触发器和辅助表。创建时需要使用SYSDBA操作。具体操作步骤如下：
通过管理工具连接数据库
进入到dmhs如下目录中，找到ddl_sql_dm8.sql
到manager里面执行

检查创建的触发器和辅助表是否有效，检查辅助表的语句。
select owner, table_name from dba_tables where owner = 'SYSDBA' and table_name like 'DMHS%' and status = 'VALID';

如果存在以上的查询结果，表示DMHS辅助表创建有效。
检查触发器的语句：
select owner, trigger_name from dba_triggers where owner = 'SYSDBA' and trigger_name like 'DMHS%' and status = 'Y';

捕获端的dmhs
<?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>193.1.1.170</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>
<disable>
<item>HISDB.</item>
<item>ALARM.</item>
<item>FHYC.</item>
<item>DDJH.</item>
<item>THSCADA.HISPOINT1MIN*</item>
<item>D5000.SYS_DATABASE_INFO</item>
<item>D5000.SYS_PROC_NETINFO</item>
<item>D5000.MNG_NODE_INFO</item>
<item>D5000.MNG_MODE_APP</item>
<item>D5000.MNG_SYS_DISTRIBUTING_INFO</item>
<item>D5000.MNG_PROCESS_INFO</item>
<item>D5000.MNG_CPU_MEM_INFO</item>
<item>D5000.MNG_NET_STATUS_INFO</item>
<item>D5000.MNG_APP_DUTY_INFO</item>
<item>D5000.MNG_REGION_INFO</item>
<item>D5000.MNG_DISK_NETINFO</item>
<item>D5000.TOKEN_INFO</item>
<item>D5000.OP_INFO</item>
</disable>
</filter>
<map>
</map>
</send>
</cpt>
</dmhs>

执行端的dmhs
<?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>

两端启动服务
cp service_template/DmhsS
cp service_template/DmhsService ./dmhs_serverd

./dmhs_server dmhs.hs

登录dmhs的管理器
./dmhs_console

执行端启动exec模块
DMHS> start exec

捕获端进行数据装载，执行成功后启动cpt模块
DMHS> copy 0 "sch.name='EMS'" truncate|insert|dict|lsn
// trancate清空执行端表数据然后重新insert插入数据
// copy参数可根据具体需求按照DMHS参考手册进行设置
DMHS> start cpt

作者