达梦主备守护集群搭建及切换整理

达梦数据库守护集群搭建

目录
达梦数据库守护集群搭建 1
1 基本信息 2
1.1主机信息： 2
1.2 数据库信息 3
2配置步骤 3
2.1关闭主库实列 3
2.2备份主库实列 3
2.3恢复备库实列 3
2.4修改主库配置文件 3
2.5修改主库同步配置文件 4
2.6修改主库归档配置文件 4
2.7修改主库监视器配置文件 5
2.8启动主库 5
2.9修改备库配置文件 5
2.10修改备库同步配置文件 5
2.11修改备库归档配置文件 6
2.12修改备库监视器配置文件 6
2.13启动备库 7
2.14启动主备守护进程 7
2.15配置监视器 7
2.16在监视器查看同步状态 7

1 基本信息
1.1主机信息：

主库 192.168.30
备库 192.168.20
监视器 192.168.10

数据库名实例名 PORT_NUM MAL_INST_DW_PORT MAL_HOST MAL_PORT MAL_DW_PORT
DM01 DMSVR01 5236 45101 192.168.1.30 55101 65101
DM02 DMSVR02 5236 45121 192.168.1.20 55121 65121
1.2 数据库信息

2配置步骤
2.1关闭主库实列
cd /dm8/data/bin
DMserviceDMSVR01 stop

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

disql sysdba/DM01SYSDBA
alter database mount;
alter database archivelog;
alter database add archivelog 'type=local,dest=/dm8/arch,file_size=64,space_limit=10240';
alter database open;
backup database to FULLBAK backupset '/dm8/backup/FULLBAK';

2.3恢复备库实列
./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"

2.4修改主库配置文件
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
2.5修改主库同步配置文件
dmmal.ini
MAL_CHECK_INTERVAL = 60
MAL_CONN_FAIL_INTERVAL = 60
[MAL_INST1]
MAL_INST_NAME = DMSVR01
MAL_HOST = 192.168.1.30
MAL_PORT = 55101
MAL_INST_HOST = 192.168.1.30
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = DMSVR02
MAL_HOST = 192.168.1.20
MAL_PORT = 55121
MAL_INST_HOST = 192.168.1.20
MAL_INST_PORT = 5236
MAL_DW_PORT = 65121
MAL_INST_DW_PORT = 45121
2.6修改主库归档配置文件
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
2.7修改主库监视器配置文件
dmwatcher.ini
[GRP1]
DW_TYPE = GLOBAL
DW_MODE = MANUAL
DW_ERROR_TIME = 60
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 60
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
2.8启动主库
./dmserver /dm8/data/DM01/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);
2.9修改备库配置文件
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
2.10修改备库同步配置文件
dmmal.ini
MAL_CHECK_INTERVAL = 60
MAL_CONN_FAIL_INTERVAL = 60
[MAL_INST1]
MAL_INST_NAME = DMSVR01
MAL_HOST = 192.168.1.30
MAL_PORT = 55101
MAL_INST_HOST = 192.168.1.30
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = DMSVR02
MAL_HOST = 192.168.1.20
MAL_PORT = 55121
MAL_INST_HOST = 192.168.1.20
MAL_INST_PORT = 5236
MAL_DW_PORT = 65121
MAL_INST_DW_PORT = 45121
2.11修改备库归档配置文件
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
2.12修改备库监视器配置文件
dmwatcher.ini
[GRP1]
DW_TYPE = GLOBAL
DW_MODE = MANUAL
DW_ERROR_TIME = 60
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 60
INST_OGUID = 453331
INST_INI = /dm8/data/DM02/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver
#RLOG_SEND_THRESHOLD = 0
#RLOG_APPLY_THRESHOLD = 0
2.13启动备库
./dmserver /dm8/data/DM02/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);
2.14启动主备守护进程
先起主库守护进程，再起备库守护进程
./dmwatcher /dm8/data/DM01/dmwatcher.ini
2.15配置监视器
dmmonitor.ini
MON_DW_CONFIRM = 1 #1表示自动切换主备，0表示不自动切换，一般用0
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 = 192.168.1.30:65101
MON_DW_IP = 192.168.1.20:65121
2.16启动监视器
su - dmdba
cd /dm8/bin/
./dmmonitor /dm8/data/dmmonitor.ini
2.17在监视器查看同步状态
监视器
show 查看同步状况
login 登录后才能切换sysdba/dameng123
switch over
2.18注册服务
备库
root用户
cd /dm8/script/root/
./dm_service_installer.sh -t dmserver -p DMSVR02 -dm_ini /dm8/data/DM01/dm.ini

./dm_service_installer.sh -t dmwatcher -p DMSVR02 -watcher_ini /dm8/data/DM02/dmwatcher.ini

主库
root用户
cd /app/dm8/script/root/
./dm_service_installer.sh -t dmserver -p DMSVR01 -dm_ini /dm8/data/DM01/dm.ini

./dm_service_installer.sh -t dmwatcher -p DMSVR01 -watcher_ini /dm8/data/DM01/dmwatcher.ini
2.19切换数据库
切换
choose switchover
login
用户名:SYSDBA
密码:
switchover
启动过程：开主机实例——开主机守护进程——开备机实例——开备机守护进程——打开确认监视器
关闭过程：关闭确认监视器——关闭备机守护进程——关闭主机守护进程——关闭主机实例服务——关闭备机实例服务