[TOC]

# 您需要知道的

- 您可登陆 [达梦数据库](http://www.dameng.com/) 官网进行数据库下载试用
- 您可登陆 [中标麒麟](http://www.cs2c.com.cn/) 官网进行操作系统下载试用
- 您可参考 [G001-OS-INS-01](http://blog.itpub.net/69986162/viewspace-2730059/) 一文完成操作系统安装
- DM 8 图形化安装您可参考 [G002-DM-INS-01](http://blog.itpub.net/69986162/viewspace-2730251/) 一文完成相关操作
- 环境：中标麒麟 7 / DM 8 开发版

# 1 环境规划

|主机名|用途|IP|DB_NAME|INSTANCE_NAME|安装路径|备注|
|:-:|:-:|:-:|:-:|:-:|:-:|:-:|
|HOST01|主库|192.168.159.129|DMDB|DMSVR01|/dm8/dmdba/dmdbms|数据库软件安装及数据库创建|
|HOST02|备库|192.168.159.130|DMDB|DMSVR02|/dm8/dmdba/dmdbms|数据库软件安装及数据库创建|
|HOST03|监控|192.168.159.131|/|/|/dm8/dmdba/dmdbms|仅安装数据库软件|

- 主库备库按照规划创建好（软件和数据库），监控机仅安装数据库软件

# 2 主库备份并还原至备库
## 2.1 主库停止实例服务

```sql
[root@host01 ~]# systemctl stop DmServiceDMSVR01.service 
```

## 2.2 备库停止实例服务

```sql
[root@host02 ~]# systemctl stop DmServiceDMSVR02.service
```

## 2.3 主库进行备份

```sql
[dmdba@host01 bin]$ mkdir /dm8/backup
[dmdba@host01 bin]$ cd /dm8/dmdba/dmdbms/bin
[dmdba@host01 bin]$ ./dmrman CTLSTMT="backup database '/dm8/dmdba/dmdbms/data/DMDB/dm.ini' full to backup_file01 backupset '/dm8/backup/backup_file_01'"

dmrman V8
backup database '/dm8/dmdba/dmdbms/data/DMDB/dm.ini' full to backup_file01 backupset '/dm8/backup/backup_file_01'
file dm.key not found, use default license!
Database mode = 0, oguid = 0
EP[0]'s cur_lsn[38154]
Processing backupset /dm8/backup/backup_file_01
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:00][Remaining:00:00:00]
backup successfully!
time used: 00:00:01.023
```

## 2.4 备库远程拷贝

```sql
[dmdba@host02 ~]$ mkdir /dm8/backup
[dmdba@host02 ~]$ cd /dm8/backup/
[dmdba@host02 backup]$ scp dmdba@192.168.159.129:/dm8/backup/backup_file_01/* .

The authenticity of host '192.168.159.129 (192.168.159.129)' can't be established.
ECDSA key fingerprint is SHA256:xTWqZkgDrdmAX5zFx+74/vlg9Iwg8c/XOgC7jZSWniA.
ECDSA key fingerprint is MD5:fd:6b:3b:11:11:a7:da:41:dd:40:9f:cb:12:9b:9c:e8.
Are you sure you want to continue connecting (yes/no)? yes
dmdba@192.168.159.129's password: 
backup_file_01.bak                            100% 6302KB  96.2MB/s   00:00    
backup_file_01.meta                           100%   73KB  16.6MB/s   00:00  
```

## 2.5 备库进行还原

- 还原

```sql
[dmdba@host02 ~]$ cd /dm8/dmdba/dmdbms/bin
[dmdba@host02 bin]$ ./dmrman CTLSTMT="RESTORE DATABASE '/dm8/dmdba/dmdbms/data/DMDB/dm.ini' FROM BACKUPSET '/dm8/backup'"

dmrman V8
RESTORE DATABASE '/dm8/dmdba/dmdbms/data/DMDB/dm.ini' FROM BACKUPSET '/dm8/backup'
file dm.key not found, use default license!
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:00][Remaining:00:00:00]
restore successfully.
time used: 291.014(ms)
```

- 恢复

```sql
[dmdba@host02 bin]$ ./dmrman CTLSTMT="RECOVER DATABASE '/dm8/dmdba/dmdbms/data/DMDB/dm.ini' FROM BACKUPSET '/dm8/backup'"

dmrman V8
RECOVER DATABASE '/dm8/dmdba/dmdbms/data/DMDB/dm.ini' FROM BACKUPSET '/dm8/backup'
file dm.key not found, use default license!
Database mode = 0, oguid = 0
EP[0]'s cur_lsn[38154]
备份集[/dm8/backup]备份过程中未产生日志
recover successfully!
time used: 231.756(ms)
```

- 更新魔数

```sql
[dmdba@host02 bin]$ ./dmrman CTLSTMT="RECOVER DATABASE '/dm8/dmdba/dmdbms/data/DMDB/dm.ini' UPDATE DB_MAGIC"

dmrman V8
RECOVER DATABASE '/dm8/dmdba/dmdbms/data/DMDB/dm.ini' UPDATE DB_MAGIC
file dm.key not found, use default license!
Database mode = 0, oguid = 0
EP[0]'s cur_lsn[38154]
recover successfully!
time used: 00:00:01.006
```

# 3 主库参数文件配置
## 3.1 修改 dm.ini

```sql
[dmdba@host01 ~]$ cd /dm8/dmdba/dmdbms/data/DMDB/
[dmdba@host01 DMDB]$ vim dm.ini

# 修改以下对应参数值

ALTER_MODE_STATUS  = 0
ENABLE_OFFLINE_TS  = 2
MAL_INI = 1
ARCH_INI = 1
```

## 3.2 创建 dmmal.ini

```sql
[dmdba@host01 DMDB]$ vim dmmal.ini
[dmdba@host01 DMDB]$ cat dmmal.ini

MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1] 
MAL_INST_NAME = DMSVR01 
MAL_HOST = 192.168.159.129
MAL_PORT = 55101
MAL_INST_HOST = 192.168.159.129
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2] 
MAL_INST_NAME = DMSVR02 
MAL_HOST = 192.168.159.130 
MAL_PORT = 55121 
MAL_INST_HOST = 192.168.159.130
MAL_INST_PORT = 5236 
MAL_DW_PORT = 65121 
MAL_INST_DW_PORT = 45121
```

## 3.3 创建 dmarch.ini

```sql
[dmdba@host01 DMDB]$ mkdir /dm8/arch
[dmdba@host01 DMDB]$ vim dmarch.ini
[dmdba@host01 DMDB]$ cat 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
```

## 3.4 创建 dmwatcher.ini

```sql
[dmdba@host01 DMDB]$ vim dmwatcher.ini
[dmdba@host01 DMDB]$ cat 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/dmdba/dmdbms/data/DMDB/dm.ini 
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/dmdba/dmdbms/bin/dmserver 
RLOG_APPLY_THRESHOLD = 0
```

## 3.5 进行主库配置

- 启动至 MOUNT 状态

```sql
[dmdba@host01 DMDB]$ cd /dm8/dmdba/dmdbms/bin
[dmdba@host01 bin]$ ./dmserver /dm8/dmdba/dmdbms/data/DMDB/dm.ini mount

file dm.key not found, use default license!
version info: develop
Use normal os_malloc instead of HugeTLB
Use normal os_malloc instead of HugeTLB
DM Database Server x64 V8 1-1-144-20.11.06-129436-ENT  startup...
Database mode = 0, oguid = 0
License will expire on 2021-11-06
file lsn: 38154
ndct db load finished
ndct fill fast pool finished
nsvr_startup end.
aud sys init success.
aud rt sys init success.
systables desc init success.
ndct_db_load_info success.
SYSTEM IS READY.
```

- 将数据库配置为主库模式

```sql
[dmdba@host01 bin]$ ./disql sysdba/Dameng123

服务器[LOCALHOST:5236]:处于普通配置状态
登录使用时间 : 4.627(ms)
disql V8

SQL> sp_set_para_value(1,'ALTER_MODE_STATUS',1);
DMSQL 过程已成功完成
已用时间: 10.858(毫秒). 执行号:0.

SQL> sp_set_oguid(453331);
DMSQL 过程已成功完成
已用时间: 1.825(毫秒). 执行号:1.

SQL> alter database primary;
操作已执行
已用时间: 2.145(毫秒). 执行号:0.

SQL> sp_set_para_value(1,'ALTER_MODE_STATUS',0);
DMSQL 过程已成功完成
已用时间: 3.377(毫秒). 执行号:2.

SQL> exit
[dmdba@host01 bin]$ ./disql sysdba/Dameng123

服务器[LOCALHOST:5236]:处于主库配置状态
登录使用时间 : 4.207(ms)
disql V8
SQL> 
```

# 4 备库参数文件配置
## 4.1 修改 dm.ini

```sql
[dmdba@host02 ~]$ cd /dm8/dmdba/dmdbms/data/DMDB/
[dmdba@host02 DMDB]$ vim dm.ini

# 修改以下对应参数值

ALTER_MODE_STATUS  = 0
ENABLE_OFFLINE_TS  = 2
MAL_INI = 1
ARCH_INI = 1
```

## 4.2 创建 dmmal.ini

```sql
[dmdba@host02 DMDB]$ vim dmmal.ini
[dmdba@host02 DMDB]$ cat dmmal.ini

MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1] 
MAL_INST_NAME = DMSVR01 
MAL_HOST = 192.168.159.129
MAL_PORT = 55101
MAL_INST_HOST = 192.168.159.129
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2] 
MAL_INST_NAME = DMSVR02 
MAL_HOST = 192.168.159.130 
MAL_PORT = 55121 
MAL_INST_HOST = 192.168.159.130
MAL_INST_PORT = 5236 
MAL_DW_PORT = 65121 
MAL_INST_DW_PORT = 45121
```

## 4.3 创建 dmarch.ini

```sql
[dmdba@host02 DMDB]$ mkdir /dm8/arch
[dmdba@host02 DMDB]$ vim dmarch.ini
[dmdba@host02 DMDB]$ cat dmarch.ini

[ARCHIVE_REALTIME] 
ARCH_TYPE = REALTIME
ARCH_DEST = DMSVR01  # 主库上要配置备库的实例名
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 128
```

## 4.4 创建 dmwatcher.ini

```sql
[dmdba@host02 DMDB]$ vim dmwatcher.ini
[dmdba@host02 DMDB]$ cat 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/dmdba/dmdbms/data/DMDB/dm.ini 
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/dmdba/dmdbms/bin/dmserver 
RLOG_APPLY_THRESHOLD = 0
```

## 4.5 进行备库配置

- 启动至 MOUNT 状态

```sql
[dmdba@host02 DMDB]$ cd /dm8/dmdba/dmdbms/bin
[dmdba@host02 bin]$ ./dmserver /dm8/dmdba/dmdbms/data/DMDB/dm.ini mount
file dm.key not found, use default license!
version info: develop
Use normal os_malloc instead of HugeTLB
Use normal os_malloc instead of HugeTLB
DM Database Server x64 V8 1-1-144-20.11.06-129436-ENT  startup...
Database mode = 0, oguid = 0
License will expire on 2021-11-06
file lsn: 38154
ndct db load finished
ndct fill fast pool finished
nsvr_startup end.
aud sys init success.
aud rt sys init success.
systables desc init success.
ndct_db_load_info success.
SYSTEM IS READY.
```

- 将数据库配置为备库模式

```sql
[dmdba@host02 bin]$ ./disql sysdba/Dameng123

服务器[LOCALHOST:5236]:处于普通配置状态
登录使用时间 : 5.727(ms)
disql V8

SQL> sp_set_para_value(1,'ALTER_MODE_STATUS',1);
DMSQL 过程已成功完成
已用时间: 11.163(毫秒). 执行号:0.

SQL> sp_set_oguid(453331);
DMSQL 过程已成功完成
已用时间: 2.401(毫秒). 执行号:1.

SQL> alter database standby;
操作已执行
已用时间: 3.295(毫秒). 执行号:0.

SQL> sp_set_para_value(1,'ALTER_MODE_STATUS',0);
DMSQL 过程已成功完成
已用时间: 3.353(毫秒). 执行号:2.
SQL> exit

[dmdba@host02 bin]$ ./disql sysdba/Dameng123

服务器[LOCALHOST:5236]:处于备库配置状态
登录使用时间 : 4.670(ms)
disql V8
SQL> 
```

# 5 启动守护进程
## 5.1 主库启动守护进程

```sql
[dmdba@host01 bin]$ ./dmwatcher /dm8/dmdba/dmdbms/data/DMDB/dmwatcher.ini 
DMWATCHER[4.0] V8
DMWATCHER[4.0] IS READY
```

## 5.2 备库启动守护进程

```sql
[dmdba@host02 bin]$ ./dmwatcher /dm8/dmdba/dmdbms/data/DMDB/dmwatcher.ini 
DMWATCHER[4.0] V8
DMWATCHER[4.0] IS READY
```

# 6 配置监视器
## 6.1 创建 dmmonitor.ini

```sql
[dmdba@host03 dm8]$ mkdir -p /dm8/data/log
[dmdba@host03 dm8]$ vim dmmonitor.ini
[dmdba@host03 dm8]$ cat 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 = 192.168.159.129:65101
MON_DW_IP = 192.168.159.130:65121
```

## 6.2 启动监视

```sql
[dmdba@host03 bin]$ ./dmmonitor /dm8/dmmonitor.ini

show
2021-01-07 15:07:51 
#================================================================================#
GROUP            OGUID       MON_CONFIRM     MODE            MPP_FLAG  
GRP1             453331      TRUE            AUTO            FALSE

<<DATABASE GLOBAL INFO:>>
IP              MAL_DW_PORT  WTIME                WTYPE     WCTLSTAT  WSTATUS        INAME            INST_OK   N_EP  N_OK  ISTATUS     IMODE     DSC_STATUS     RTYPE     RSTAT    
192.168.159.129 65101        2021-01-07 15:07:51  GLOBAL    VALID     OPEN           DMSVR01          OK        1     1     OPEN        PRIMARY   DSC_OPEN       REALTIME  VALID

EP INFO:
INST_PORT  INST_OK   INAME            ISTATUS     IMODE     DSC_SEQNO  DSC_CTL_NODE RTYPE     RSTAT    FSEQ            FLSN            CSEQ            CLSN            DW_STAT_FLAG          
5236       OK        DMSVR01          OPEN        PRIMARY   0          0            REALTIME  VALID    3967            39410           3967            39410           NONE

<<DATABASE GLOBAL INFO:>>
IP              MAL_DW_PORT  WTIME                WTYPE     WCTLSTAT  WSTATUS        INAME            INST_OK   N_EP  N_OK  ISTATUS     IMODE     DSC_STATUS     RTYPE     RSTAT    
192.168.159.130 65121        2021-01-07 15:07:51  GLOBAL    VALID     OPEN           DMSVR02          OK        1     1     OPEN        STANDBY   DSC_OPEN       REALTIME  VALID

EP INFO:
INST_PORT  INST_OK   INAME            ISTATUS     IMODE     DSC_SEQNO  DSC_CTL_NODE RTYPE     RSTAT    FSEQ            FLSN            CSEQ            CLSN            DW_STAT_FLAG          
5236       OK        DMSVR02          OPEN        STANDBY   0          0            REALTIME  VALID    3965            39410           3965            39410           NONE

DATABASE(DMSVR02) APPLY INFO FROM (DMSVR01):
DSC_SEQNO[0], (ASEQ, SSEQ, KSEQ)[3967, 3967, 3967], (ALSN, SLSN, KLSN)[39410, 39410, 39410], N_TSK[0], TSK_MEM_USE[0]

#================================================================================#
```

# 7 数据测试

- 主库插入数据

```sql
[dmdba@host01 bin]$ ./disql sysdba/Dameng123

服务器[LOCALHOST:5236]:处于主库打开状态
登录使用时间 : 5.677(ms)
disql V8

SQL> create table henry(id int);
操作已执行
已用时间: 9.331(毫秒). 执行号:500.

SQL> insert into henry values(1);
影响行数 1

已用时间: 0.772(毫秒). 执行号:501.

SQL> commit;
操作已执行
已用时间: 0.869(毫秒). 执行号:502.

SQL> select * from henry;

行号     ID         
---------- -----------
1          1

已用时间: 0.845(毫秒). 执行号:503.
```

- 备库查询

```sql
[dmdba@host02 bin]$ ./disql sysdba/Dameng123

服务器[LOCALHOST:5236]:处于备库打开状态
登录使用时间 : 5.629(ms)
disql V8

SQL> select * from henry;

行号     ID         
---------- -----------
1          1

已用时间: 5.251(毫秒). 执行号:100.
```
[End]

ITPub博客

G015-DM-INS-03 达梦数据库 DM 8 实时主备搭建

最新文章