1.搭建DM7单机版DMHS
1.1环境准备
操作系统:Red Hat Enterprise Linux Server release 7.6 (Maipo) x86_64
数据库版本:DM Database Server x64 V7.6.1.112-Build(2021.10.28-149686-10036)ENT
DMHS版本:V3.1.3-Build(2020.09.30-94249trunc)_D64
源端IP:192.168.1.92
目标端IP:192.168.1.93
1.2源端数据库配置
1.2.1开启归档
SQL> SELECT ARCH_DEST, ARCH_FILE_SIZE FROM SYS.V$DM_ARCH_INI WHERE ARCH_TYPE='LOCAL' AND ARCH_IS_VALID='Y';
ALTER DATABASE MOUNT;
ALTER DATABASE ADD ARCHIVELOG 'DEST=/dm7/dmarch,TYPE=local,FILE_SIZE=256,SPACE_LIMIT=0';
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
1.2.2开启逻辑日志
SQL> SELECT PARA_VALUE FROM SYS.V$DM_INI WHERE PARA_NAME = 'RLOG_APPEND_LOGIC';
[dmdba@DM7 ~]$ vim /dm7/data/DAMENG/dm.ini
[dmdba@DM7 bin]$ ./DmServiceDMSERVER restart
1.2.3检查在线日志
SQL> SELECT PATH FROM SYS.V$RLOGFILE;
1.2.4检查FAST_COMMIT参数
FAST_COMMIT参数要为0
SQL> select para_value from v$dm_ini where para_name = 'FAST_COMMIT';