修改源端、目的端实例的服务器配置文件
- dm.ini,主要修改参数如下:
[dmdba@localhost bin]# cat /opt/dmdata/DAMENG/dm.ini
ARCH_INI = 1
RLOG_APPEND_LOGIC = 1
FAST_COMMIT = 0(若不为0,则可能导致逻辑日志不全,而影响同步效果,DM8默认为0)
- 配置源端数据库归档模式
[dmdba@localhost bin]# cat /opt/dmdata/DAMENG/dmarch.ini
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /home/dmdba/dmarch #归档目录
ARCH_FILE_SIZE = 128 #归档文件大小,单位 MB
ARCH_SPACE_LIMIT = 0 #空间大小限制,0 表示不限制
- 使用disql工具执行dmhs安装目录下的脚本
start /opt/dmhs/scripts/ddl_sql_dm8.sql
-
执行安装命令
-
源端配置dmhs.hs文件
<?xml version="1.0" encoding="utf-8"?>
<dmhs>
<base>
<lang>ch</lang>
<mgr_port>5345</mgr_port>
<chk_interval>2</chk_interval>
<siteid>1</siteid>
</base>
<recv>
<data_port>5346</data_port>
<exec>
<db_type>DM8</db_type>
<db_server>源端IP</db_server>
<db_user>SYSDBA</db_user>
<db_pwd>SYSDBA</db_pwd>
<db_port>5236</db_port>
<db_name/>
<exec_thr>4</exec_thr>
<exec_sql>512</exec_sql>
<exec_trx>5000</exec_trx>
<exec_rows>250</exec_rows>
<msg_col_size>3000</msg_col_size>
<exec_policy>0</exec_policy>
</exec>
</recv>
<cpt>
<db_type>DM8</db_type>
<db_server>源端IP</db_server>
<db_user>SYSDBA</db_user>
<db_pwd>SYSDBA</db_pwd>
<db_port/>
<idle_time>300</idle_time>
<ddl_mask>TABLE:INDEX:TRUNCATE:CREATE:DROP:ALTER</ddl_mask>
<parse_thr>1</parse_thr>
<arch>
<clear_interval>600</clear_interval>
<clear_flag>1</clear_flag>
<bak_dir/>
</arch>
<send>
<ip>目标端IP</ip>
<mgr_port>5345</mgr_port>
<data_port>5346</data_port>
<level>0</level>
<trigger>0</trigger>
<constraint>0</constraint>
<identity>0</identity>
<net_turns>0</net_turns>
<filter>
<enable>
<item>SYSDBA.*</item>
</enable>
<disable>
<item/>
</disable>
</filter>
<map>
<item>SYSDBA.*==SYSDBA.*</item>
</map>
</send>
</cpt>
</dmhs>
- 目的端配置dmhs.hs文件
<?xml version="1.0" encoding="utf-8"?>
<dmhs>
<base>
<lang>ch</lang>
<mgr_port>5345</mgr_port>
<chk_interval>2</chk_interval>
<siteid>2</siteid>
</base>
<recv>
<data_port>5346</data_port>
<exec>
<db_type>DM8</db_type>
<db_server>目标端IP</db_server>
<db_user>SYSDBA</db_user>
<db_pwd>SYSDBA</db_pwd>
<db_port>5236</db_port>
<db_name/>
<exec_thr>4</exec_thr>
<exec_sql>512</exec_sql>
<exec_trx>5000</exec_trx>
<exec_rows>250</exec_rows>
<msg_col_size>3000</msg_col_size>
<exec_policy>1</exec_policy>
</exec>
</recv>
<cpt>
<db_type>DM8</db_type>
<db_server>目标端IP</db_server>
<db_user>SYSDBA</db_user>
<db_pwd>SYSDBA</db_pwd>
<db_port/>
<idle_time>300</idle_time>
<ddl_mask/>
<parse_thr>1</parse_thr>
<arch>
<clear_interval>600</clear_interval>
<clear_flag>1</clear_flag>
<bak_dir/>
</arch>
<send>
<ip>源端IP</ip>
<mgr_port>5345</mgr_port>
<data_port>5346</data_port>
<level>0</level>
<trigger>0</trigger>
<constraint>0</constraint>
<identity>0</identity>
<net_turns>0</net_turns>
<filter>
<enable>
<item>SYSDBA.*</item>
</enable>
<disable>
<item/>
</disable>
</filter>
<map>
<item>SYSDBA.*==SYSDBA.*</item>
</map>
</send>
</cpt>
</dmhs>
- 调起监控窗口
[dmdba@localhost bin]$ ./dmhs_server dmhs.hs
- 目的端启动dmhs服务
[dmdba@localhost bin]$ ./dmhs_console
DMHS> connect
DMHS> start exec
- 源端启动dmhs服务
[dmdba@localhost bin]$ ./dmhs_console
DMHS> connect
DMHS> copy 0 “sch.name=’xxx’” dict
-
下图以‘DMHR’为例
-
同步表结构和数据
DMHS> copy 0 “sch.name=’xxx’” create|insert