一、集群规划
| 数据库名 | 实例名 | PORT_NUM | MAL_INST_DW_PORT | MAL_HOST | MAL_PORT | MAL_DW_PORT |
| DM01 | DMSVR01 | 5236 | 45101 | 192.168.218.25 | 55101 | 65101 |
| DM02 | DMSVR02 | 5236 | 45121 | 192.168.218.26 | 55121 | 65121 |
二、主备库实例初始化（DM8已安装）
1、创建主库
2、创建备库
./dminit path=/dm8/data/ db_name=DM02 instance_name=DMSVR02
三、备份主库，还原备库
1、备份主库（冷备）
2、执行备份语句
./dmrman CTLSTMT="BACKUP DATABASE '/dm8/data/DAMENG/dm.ini' FULL TO BACKUP_FILE1 BACKUPSET '/dm8/backup/BACKUP_FILE_01'"
3、检查备份
4、主库备份数据拷贝到备库
5、还原数据到备库，恢复备库
四、配置主、备库参数
1、配置主库参数dm.ini
INSTANCE_NAME = GRP1_RT_01
PORT_NUM = 35101
DW_INACTIVE_INTERVAL = 60
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1
RLOG_SEND_APPLY_MON = 64
2、配置主库参数dmmal.ini
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = DMSVR01
MAL_HOST = 192.168.218.25
MAL_PORT = 55101
MAL_INST_HOST = 192.168.218.25
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = DMSVR02
MAL_HOST = 192.168.218.26
MAL_PORT = 55121
MAL_INST_HOST = 192.168.218.26
MAL_INST_PORT = 5236
MAL_DW_PORT = 65121
MAL_INST_DW_PORT = 45121
3、配置主库参数dmarch.ini
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DMSVR02
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/data/DM01/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0
4、配置主库参数dmwatcher.ini
[GRP1]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 453331
INST_INI = /dm8/data/DM01/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0
5、 配置备库参数dm.ini同主库一致
6、 配置备库参数dmarch.ini
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DMSVR01
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/data/DM02/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0
7、配置备库参数dmmal.ini同主库一致
8、配置备库参数dmwatcher.ini
[GRP1]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 453331
INST_INI = /dm8/data/DM02/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver
RLOG_APPLY_THRESHOLD = 0
五、启动集群
1、启动主库mount状态
2、启动备库mount状态
3、启动主备库数据守护
主 ./dmwatcher /dm8/data/DM01/dmwatcher.ini
备./dmwatcher /dm8/data/DM02/dmwatcher.ini
4、主库上添加监听，启动监测（显示OPEN说明集群搭建成功）
5、主备切换
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/69983998/viewspace-2740292/ ，如需转载，请注明出处，否则将追究法律责任。
