DM数据守护测试搭建步骤

卢朝栋

dwp  10.9.192.103

dws  10.9.192.102

dwm  10.9.192.101

数据库名       实例名               PORT_NUM      MAL_INST_DW_PORT    MAL_HOST    MAL_PORT    MAL_DW_PORT
DMDW     DMSVR01    5236       45101                                  10.9.192.103        55101                     65101
DMDW     DMSVR02                    5236      45121                    10.9.192.102       

55121                      65121

主库备份
systemctl stop DmServiceDMSVR01
./dmrman CTLSTMT="BACKUP DATABASE '/dm8/data/DMDW/dm.ini' FULL TO BACKUP_FILE1 BACKUPSET '/dm8/backup/BACKUP_FILE_01'"

从库恢复
systemctl stop DmServiceDMSVR02
./dmrman CTLSTMT="RESTORE DATABASE '/dm8/data/DMDW/dm.ini' FROM BACKUPSET '/dm8/backup'"
./dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/DMDW/dm.ini' FROM BACKUPSET '/dm8/backup'"
./dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/DMDW/dm.ini' UPDATE DB_MAGIC"

primary

dm.ini
----------
INSTANCE_NAME = DMSVR01
PORT_NUM = 5236
DW_INACTIVE_INTERVAL = 60
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1
RLOG_SEND_APPLY_MON = 64

dmmal.ini
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = DMSVR01
MAL_HOST = 10.9.192.103
MAL_PORT = 55101
MAL_INST_HOST = 10.9.192.103
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = DMSVR02
MAL_HOST = 10.9.192.102
MAL_PORT = 55121
MAL_INST_HOST = 10.9.192.102
MAL_INST_PORT = 5236
MAL_DW_PORT = 65121
MAL_INST_DW_PORT = 45121

dmarch.ini
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DMSVR02
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

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/DMDW/dm.ini  
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver
RLOG_SEND_THRESHOLD = 0  
RLOG_APPLY_THRESHOLD = 0

启动主库
./dmserver /dm8/data/DMDW/dm.ini  mount

SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
SQL>sp_set_oguid(453331);
SQL>alter database primary;
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

standby
dm.ini

INSTANCE_NAME = DMSVR02
PORT_NUM = 5236
DW_INACTIVE_INTERVAL = 60
ALTER_MODE_STATUS = 0  
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1  
RLOG_SEND_APPLY_MON = 64

dmmal.ini
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5  
[MAL_INST1]
MAL_INST_NAME = DMSVR01  
MAL_HOST = 10.9.192.103
MAL_PORT = 55101
MAL_INST_HOST = 10.9.192.103
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101  
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = DMSVR02
MAL_HOST = 10.9.192.102
MAL_PORT = 55121
MAL_INST_HOST = 10.9.192.102
MAL_INST_PORT = 5236
MAL_DW_PORT = 65121
MAL_INST_DW_PORT = 45121

dmarch.ini
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DMSVR01  
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch  
ARCH_FILE_SIZE = 128  
ARCH_SPACE_LIMIT = 0

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/DMDW/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver
RLOG_APPLY_THRESHOLD = 0

以 Mount 方式启动备库
./dmserver /dm8/data/DMDW/dm.ini mount
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
SQL>sp_set_oguid(453331);
SQL>alter database standby;
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

主备都启动watcher进程
./dmwatcher /dm8/data/DMDW/dmwatcher.ini

监视节点
dmmonitor.ini
MON_DW_CONFIRM = 1
MON_LOG_PATH = /dm8/data/log  
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 32
MON_LOG_SPACE_LIMIT = 0
[GRP1]
MON_INST_OGUID = 453331  
MON_DW_IP = 10.9.192.103:65101
MON_DW_IP = 10.9.192.102:65121

启动监视进程
./dmmonitor /dm8/dmmonitor.ini

将数据守护，监视服务注册到操作系统中。
./dm_service_installer.sh -t dmwatcher -p DMWATCHER
-watcher_ini /dm8/data/DAMENG/dmwatcher.ini
./dm_service_installer.sh -t dmmonitor -p DMMONITOR
-monitor_ini /dm8/data/DAMENG/dmmonitor.ini
实时主备集群重启有顺序要求：
1、关闭监视器
2、关闭主库守护进程
3、关闭备库守护进程
4、关闭主库实例
5、关闭备库实例
6、启动主库实例(mount)
7、启动备库实例(mount)
8、启动主库守护进程(open)
9、启动备库守护进程(open)
10、启动监视器