国产化探索之路---达梦数据库安装（DM8）使用详细图文教程(二)

中标麒麟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

退出监视器。