一、机器规划

数据库主机名：dm01
实例：mpp01，端口：7236（一节点主库）、mpp02bak，端口：7336（二节点备库）
数据库主机名：dm02
实例：mpp02，端口：7236（二节点主库）、mpp01bak，端口：7336（一节点备库）
监视器主机名：dm03

二、初始化主备库

安装好数据库软件后，在两台数据库主机分别初始化两个主库和两个备库

[dmdba@dm01 ~]$ /dm8/dmdbms/bin/dminit PATH=/dm8/mpp/mpp01 INSTANCE_NAME=MPP01 PORT_NUM=7236
[dmdba@dm01 ~]$ /dm8/dmdbms/bin/dminit PATH=/dm8/mpp/mpp02bak INSTANCE_NAME=MPP02BAK PORT_NUM=7336

[dmdba@dm02 ~]$ /dm8/dmdbms/bin/dminit PATH=/dm8/mpp/mpp02 INSTANCE_NAME=MPP02 PORT_NUM=7236
[dmdba@dm02 ~]$ /dm8/dmdbms/bin/dminit PATH=/dm8/mpp/mpp01bak INSTANCE_NAME=MPP01BAK PORT_NUM=7336

三、准备主库

修改主库两节点 dm.ini

ARCH_INI = 1 #打开归档配置
DW_INACTIVE_INTERVAL = 60 #接收守护进程消息超时时间 
ALTER_MODE_STATUS = 0 #不允许手工方式修改实例模式/状态/OGUID 
ENABLE_OFFLINE_TS = 2 #不允许备库 OFFLINE 表空间 
MAL_INI = 1 #打开 MAL 系统 
ARCH_INI = 1 #打开归档配置 
MPP_INI = 1 #启用 MPP 配置 
RLOG_SEND_APPLY_MON = 64 #统计最近 64 次的日志发送信息

修改主库两节点dmmal.ini

MAL_CHECK_INTERVAL = 5 #MAL 链路检测时间间隔 
MAL_CONN_FAIL_INTERVAL = 5 #判定 MAL 链路断开的时间 

[MAL_INST1] 
MAL_INST_NAME = mpp01 #实例名，和 dm.ini 中的INSTANCE_NAME一致 
MAL_HOST = 1.1.1.1 #MAL 系统监听 TCP 连接的 IP 地址 
MAL_PORT = 7237 #MAL 系统监听 TCP 连接的端口 
MAL_INST_HOST = 1.1.1.1 #实例的对外服务 IP 地址 
MAL_INST_PORT = 7236 #实例的对外服务端口，和 dm.ini 中的 PORT_NUM 一致 
MAL_DW_PORT = 7238 #实例对应的守护进程监听 TCP 连接的端口 
MAL_INST_DW_PORT = 7239 #实例监听守护进程 TCP 连接的端口 

[MAL_INST2] 
MAL_INST_NAME = mpp02 
MAL_HOST = 1.1.1.2 
MAL_PORT = 7237 
MAL_INST_HOST = 1.1.1.2 
MAL_INST_PORT = 7236
MAL_DW_PORT = 7238
MAL_INST_DW_PORT = 7239

[MAL_INST3] 
MAL_INST_NAME = mpp01bak 
MAL_HOST = 1.1.1.2 
MAL_PORT = 7337 
MAL_INST_HOST = 1.1.1.2 
MAL_INST_PORT = 7336 
MAL_DW_PORT = 7338 
MAL_INST_DW_PORT = 7339

[MAL_INST4] 
MAL_INST_NAME = mpp02bak 
MAL_HOST = 1.1.1.1 
MAL_PORT = 7337
MAL_INST_HOST = 1.1.1.1 
MAL_INST_PORT = 7336
MAL_DW_PORT = 7338
MAL_INST_DW_PORT = 7339

修改一节点dmarch.ini，增加本地归档配置和实时归档配置

[ARCHIVE_LOCAL1] 
ARCH_TYPE = LOCAL #本地归档类型 
ARCH_DEST = /dm8/mpp/mpp01/arch #本地归档文件存放路径 
ARCH_FILE_SIZE = 128 #单位 Mb，本地单个归档文件最大值 
ARCH_SPACE_LIMIT = 0 #单位 Mb，0 表示无限制，范围 1024~2147483647M

[ARCHIVE_REALTIME1] 
ARCH_TYPE = REALTIME #实时归档类型 
ARCH_DEST = mpp01bak #实时归档目标实例名

修改二节点dmarch.ini，增加本地归档配置

[ARCHIVE_LOCAL2] 
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/mpp/mpp02/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

[ARCHIVE_REALTIME2] 
ARCH_TYPE = REALTIME
ARCH_DEST = mpp02bak

分别备份两个主库，并传输到对应备库，准备进行备库恢复

[dmdba@dm01 ~]$ /dm8/dmdbms/bin/dmrman CTLSTMT="BACKUP DATABASE '/dm8/mpp/mpp01/DAMENG/dm.ini' FULL TO BACKUP_FILE1 BACKUPSET '/dm8/mpp/mpp01/backup/BACKUP_1'"
[dmdba@dm01 ~]$ scp -r /dm8/mpp/mpp01/backup/BACKUP_1 dmdba@dm02:/dm8/mpp/mpp01bak/backup/BACKUP_1

[dmdba@dm02 ~]$ /dm8/dmdbms/bin/dmrman CTLSTMT="BACKUP DATABASE '/dm8/mpp/mpp02/DAMENG/dm.ini' FULL TO BACKUP_FILE1 BACKUPSET '/dm8/mpp/mpp02/backup/BACKUP_2'"
[dmdba@dm02 ~]$ scp -r /dm8/mpp/mpp02/backup/BACKUP_2 dmdba@dm01:/dm8/mpp/mpp02bak/backup/BACKUP_2

在主库一节点配置dmmpp.ini

[SERVICE_NAME1]
MPP_SEQ_NO = 0
MPP_INST_NAME = mpp01

[SERVICE_NAME2]
MPP_SEQ_NO = 1
MPP_INST_NAME = mpp02

在主库一节点生成dmmpp.ctl，并传输到其他所有主备节点

[dmdba@dm01 ~]$ /dm8/dmdbms/bin/dmctlcvt TYPE=2 SRC=/dm8/mpp/mpp01/DAMENG/dmmpp.ini DEST=/dm8/mpp/mpp01/DAMENG/dmmpp.ctl

四、准备备库

1.还原备库

[dmdba@dm01 ~]$ /dm8/dmdbms/bin/dmrman CTLSTMT="RESTORE DATABASE '/dm8/mpp/mpp02bak/DAMENG/dm.ini' FROM BACKUPSET '/dm8/mpp/mpp02bak/backup/BACKUP_2'"
[dmdba@dm01 ~]$ /dm8/dmdbms/bin/dmrman CTLSTMT="RECOVER DATABASE '/dm8/mpp/mpp02bak/DAMENG/dm.ini' UPDATE DB_MAGIC"

[dmdba@dm02 ~]$ /dm8/dmdbms/bin/dmrman CTLSTMT="RESTORE DATABASE '/dm8/mpp/mpp01bak/DAMENG/dm.ini' FROM BACKUPSET '/dm8/mpp/mpp01bak/backup/BACKUP_1'"
[dmdba@dm02 ~]$ /dm8/dmdbms/bin/dmrman CTLSTMT="RECOVER DATABASE '/dm8/mpp/mpp01bak/DAMENG/dm.ini' UPDATE DB_MAGIC"

修改备库两节点dm.ini

DW_INACTIVE_INTERVAL = 60 #接收守护进程消息超时时间 
ALTER_MODE_STATUS = 0 #不允许手工方式修改实例模式/状态/OGUID 
ENABLE_OFFLINE_TS = 2 #不允许备库 OFFLINE 表空间 
MAL_INI = 1 #打开 MAL 系统 
ARCH_INI = 1 #打开归档配置 
MPP_INI = 1 #打开 MPP 配置 
RLOG_SEND_APPLY_MON = 64 #统计最近 64 次的日志重演信息

修改备库两节点dmmal.ini（与主库一致）

MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5

[MAL_INST1] 
MAL_INST_NAME = mpp01 
MAL_HOST = 1.1.1.1
MAL_PORT = 7237
MAL_INST_HOST = 1.1.1.1
MAL_INST_PORT = 7236
MAL_DW_PORT = 7238
MAL_INST_DW_PORT = 7239

[MAL_INST2] 
MAL_INST_NAME = mpp02 
MAL_HOST = 1.1.1.2 
MAL_PORT = 7237 
MAL_INST_HOST = 1.1.1.2 
MAL_INST_PORT = 7236
MAL_DW_PORT = 7238
MAL_INST_DW_PORT = 7239

[MAL_INST3] 
MAL_INST_NAME = mpp01bak 
MAL_HOST = 1.1.1.2 
MAL_PORT = 7337 
MAL_INST_HOST = 1.1.1.2 
MAL_INST_PORT = 7336 
MAL_DW_PORT = 7338 
MAL_INST_DW_PORT = 7339

[MAL_INST4] 
MAL_INST_NAME = mpp02bak 
MAL_HOST = 1.1.1.1 
MAL_PORT = 7337
MAL_INST_HOST = 1.1.1.1 
MAL_INST_PORT = 7336
MAL_DW_PORT = 7338
MAL_INST_DW_PORT = 7339

配置一节点dmarch.ini

[ARCHIVE_REALTIME1] 
ARCH_TYPE = REALTIME
ARCH_DEST = mpp01

[ARCHIVE_LOCAL1] 
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/mpp/mpp01bak/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

配置二节点dmarch.ini

[ARCHIVE_REALTIME2] 
ARCH_TYPE = REALTIME
ARCH_DEST = mpp02

[ARCHIVE_LOCAL2] 
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/mpp/mpp02bak/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

五、启动主备库

mount启动主库，修改参数

[dmdba@dm01 ~]$ /dm8/dmdbms/bin/dmserver /dm8/mpp/mpp01/DAMENG/dm.ini mount
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
SQL>sp_set_oguid(1111111);   #不同主库不一致，主备之间一致
SQL>alter database primary;  
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

[dmdba@dm02 ~]$ /dm8/dmdbms/bin/dmserver /dm8/mpp/mpp02/DAMENG/dm.ini mount
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
SQL>sp_set_oguid(1111112); 
SQL>alter database primary;  
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

mount启动备库，修改参数

[dmdba@dm02 ~]$ /dm8/dmdbms/bin/dmserver /dm8/mpp/mpp01bak/DAMENG/dm.ini mount
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1); 
SQL>sp_set_oguid(1111111); 
SQL>ALTER DATABASE STANDBY; 
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

[dmdba@dm01 ~]$ /dm8/dmdbms/bin/dmserver /dm8/mpp/mpp02bak/DAMENG/dm.ini mount
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1); 
SQL>sp_set_oguid(1111112); 
SQL>ALTER DATABASE STANDBY; 
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

六、配置dmwatcher

主机dm01配置dmwatcher.ini

[GRP1]
DW_TYPE = GLOBAL #全局守护类型
DW_MODE = AUTO #自动切换模式
DW_ERROR_TIME = 10 #远程守护进程故障认定时间
INST_RECOVER_TIME = 60 #主库守护进程启动恢复的间隔时间
INST_ERROR_TIME = 10 #本地实例故障认定时间
INST_OGUID = 1111111 #守护系统唯一 OGUID 值
INST_INI = /dm8/mpp/mpp01/DAMENG/dm.ini #dm.ini 配置文件路径
INST_AUTO_RESTART = 1 #打开实例的自动启动功能
INST_STARTUP_CMD = /dm8/dmdbms/bin/dmserver #命令行方式启动
RLOG_SEND_THRESHOLD = 0 #指定主库发送日志到备库的时间阈值，默认关闭
RLOG_APPLY_THRESHOLD = 0 #指定备库重演日志的时间阈值，默认关闭

[GRP2]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 1111112
INST_INI = /dm8/mpp/mpp02bak/DAMENG/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/dmdbms/bin/dmserver
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0

主机dm02配置dmwatcher.ini

DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 1111111
INST_INI = /dm8/mpp/mpp01bak/DAMENG/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/dmdbms/bin/dmserver
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0 

[GRP2]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 1111112
INST_INI = /dm8/mpp/mpp02/DAMENG/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/dmdbms/bin/dmserver
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0

主机dm03配置dmmonitor.ini

MON_DW_CONFIRM = 1 #确认监视器模式
MON_LOG_PATH = /dm8/dmdbms/log #监视器日志文件存放路径
MON_LOG_INTERVAL = 60 #每隔 60s 定时记录系统信息到日志文件
MON_LOG_FILE_SIZE = 32 #每个日志文件最大 32M
MON_LOG_SPACE_LIMIT = 0 #不限定日志文件总占用空间
[GRP1]
MON_INST_OGUID = 1111111 #组 GRP1 的唯一 OGUID 值
#以下配置为监视器到组 GRP1 的守护进程的连接信息，以―IP:PORT‖的形式配置
#IP 对应 dmmal.ini 中的 MAL_HOST，PORT 对应 dmmal.ini 中的 MAL_DW_PORT
MON_DW_IP = 1.1.1.1:7238
MON_DW_IP = 1.1.1.2:7338
[GRP2]
MON_INST_OGUID = 1111112
MON_DW_IP = 1.1.1.1:7338
MON_DW_IP = 1.1.1.2:7238

七、配置完成

注册完成dmserver、dmwatcher、dmmonitor服务后，启动服务，在主机dm03启动监视器/dm8/dmdbms/bin/dmmonitor /dm8/dmdbms/dmmonitor.ini查看数据库状态