[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]</database></database>

G015-DM-INS-03 達夢資料庫 DM 8 實時主備搭建

相關文章