中标麒麟7.0 + DM8 手动搭建数据守护(主备)集群4.0教程
目录
第一章 环境说明
操作系统:中标麒麟 NeoKylin Advanced Server V7.0.iso
数据库:达梦数据库 dm8_20201107_x86_rh7_64_ent_8.1.1.144.iso
1.1.试验环境
准备三台主机分别为:
主库:192.168.100.97
备库:192.168.100.205
监视器:192.168.100.114
1.2.环境说明
1.2.1.主库环境
主库环境需安装DM8数据库,并创建实例,实例参数如下:
1.2.2.备库环境
备库环境需安装DM8数据库,并创建实例,实例参数如下:
1.2.3.监视器环境
监视器环境需安装DM8数据库。
第二章 数据守护集群搭建
2.1.关闭主备库实例
通过达梦服务查看器,关闭主库及备库数据库实例。
2.1.1.关闭主库实例
2.1.2.关闭备库实例
2.2.备份还原
分别再主库和备库创建文件夹:
[dmdba@localhost ~]$ cd /dm8
[dmdba@localhost dm8]$ mkdir backup
2.2.1.备份主库
[dmdba@localhost ~]$ cd /dm8/bin
[dmdba@localhost bin]$ ./dmrman CTLSTMT=“BACKUP DATABASE ‘/dm8/data/DM01/dm.ini’ FULL TO DM01_BACKUP_01 BACKUPSET ‘/dm8/backup’”
2.2.2.拷贝主库备份至备库
[dmdba@localhost ~]$ cd /dm8/backup/
[dmdba@localhost backup]$ scp . dmdba@192.168.100.205:/dm8/backup
2.2.3.还原备库
[dmdba@localhost ~]$ cd /dm8
[dmdba@localhost dm8]$ mkdir backup
[dmdba@localhost ~]$ cd /dm8/bin
[dmdba@localhost bin]$ ./dmrman CTLSTMT=“RESTORE DATABASE ‘/dm8/data/DM01/dm.ini’ FROM BACKUPSET ‘/dm8/backup’”
[dmdba@localhost bin]$ ./dmrman CTLSTMT=“RECOVER DATABASE ‘/dm8/data/DM01/dm.ini’ FROM BACKUPSET ‘/dm8/backup’”
[dmdba@localhost bin]$ ./dmrman CTLSTMT=“RECOVER DATABASE ‘/dm8/data/DM01/dm.ini’ UPDATE DB_MAGIC”
2.3.主备库配置
分别再主库和备库创建文件夹:
[dmdba@localhost ~]$ cd /dm8
[dmdba@localhost dm8]$ mkdir arch
2.3.1.主库配置
[dmdba@localhost ~]$ cd /dm8/data/DM01
2.3.1.1.配置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.3.1.2.配置dmmal.ini
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = DMSVR01
MAL_HOST = 192.168.100.97
MAL_PORT = 55101
MAL_INST_HOST = 192.168.100.97
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = DMSVR02
MAL_HOST = 192.168.100.205
MAL_PORT = 55121
MAL_INST_HOST = 192.168.100.205
MAL_INST_PORT = 5236
MAL_DW_PORT = 65121
MAL_INST_DW_PORT = 45121
2.3.1.3.配置dmarch.ini
#DaMeng Database Archive Configuration file
#this is comments
ARCH_WAIT_APPLY = 0
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DMSVR02
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 64
ARCH_SPACE_LIMIT = 0
ARCH_FLUSH_BUF_SIZE = 0
2.3.1.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
2.3.2.拷贝主库备份至备库
[dmdba@localhost ~]$ cd /dm8/data/DM01
[dmdba@localhost backup]$ scp dm*.ini dmdba@192.168.100.205:/dm8/data/DM01
2.3.3.备库配置
[dmdba@localhost ~]$ cd /dm8/data/DM01
2.3.3.1.修改dm.ini
INSTANCE_NAME = DMSVR02
2.3.3.2.修改dmarch.ini
ARCH_DEST = DMSVR01
2.4.监视器配置
[dmdba@localhost ~]$ cd /dm8
2.4.1.配置dmmonitor.ini
MON_DW_CONFIRM = 1
MON_LOG_PATH = /dm8/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.100.97:65101
MON_DW_IP = 192.168.100.205:65121
2.5.主库启动及配置
2.5.1.Mount模式启动主库
[dmdba@localhost ~]$ cd /dm8/bin
[dmdba@localhost bin]$ ./dmserver /dm8/data/DM01/dm.ini mount
2.5.2.配置主库
[dmdba@localhost ~]$ disql sysdba/SYSDEA
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.6.备库启动及配置
2.6.1.Mount模式启动备库
[dmdba@localhost ~]$ cd /dm8/bin
[dmdba@localhost bin]$ ./dmserver /dm8/data/DM01/dm.ini mount
2.6.2.配置备库
[dmdba@localhost ~]$ disql sysdba/SYSDEA
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.7.启动数据守护
2.7.1.启动主库dmwatcher
[dmdba@localhost ~]$ cd /dm8/bin
[dmdba@localhost bin]$ ./dmwatcher /dm8/data/DM01/dmwatcher.ini
2.7.2.启动备库dmwatcher
[dmdba@localhost ~]$ cd /dm8/bin
[dmdba@localhost bin]$ ./dmwatcher /dm8/data/DM01/dmwatcher.ini
2.7.3.启动监视器dmmonitor
[dmdba@localhost ~]$ cd /dm8/bin
[dmdba@localhost bin]$ ./dmmonitor /dm8/dmmonitor.ini
第三章 监视器使用
此处只介绍入门常用命令。
3.1.login
登陆监视器:
3.2.show
查看监视器信息:
3.3.switchover
切换主备库:
3.4.exit
退出监视器。