**# 达梦数据库DSC架构下ASM及表空间扩容实施**

达梦DSC运行在麒麟10下，业务需求是扩容表空间； 由于表空间所在的ASM datadg空间偏小，因此需扩容ASM磁盘。

## 检查存储新增磁盘及当前ASM使用磁盘情况；
### SQL> select * from v$asmdisk;

*行号     GROUP_ID    DISK_ID     DISK_NAME  DISK_PATH                  SIZE        FREE_AUNO   CREATE_TIME         MODIFY_TIME        
---------- ----------- ----------- ---------- -------------------------- ----------- ----------- ------------------- -------------------
1          0           0           DMASMLOG0  /dev/iscsi/dm-archdg-asm01 102399      102396      2021-12-06 20:37:57 2021-12-06 20:37:57
2          1           0           DMASMDATA0 /dev/iscsi/dm-datadg-asm01 102399      102396      2021-12-06 20:38:09 2021-12-06 20:38:09
3          125         0           DMASMvote  /dev/iscsi/dm-votedg-asm01 36864       36864       2021-12-06 20:31:48 2021-12-06 20:31:48
4          126         0           DMASMdcr   /dev/iscsi/dm-dcrdg-asm01  30720       30720       2021-12-06 20:31:38 2021-12-06 20:31:38
*
#### 检查asm使用的磁盘路径；

### ASM使用率情况
SQL> select * from v$asmgroup;

行号     GROUP_ID    GROUP_NAME N_DISK      AU_SIZE     EXTENT_SIZE TOTAL_SIZE  FREE_SIZE   TOTAL_FILE_NUM
---------- ----------- ---------- ----------- ----------- ----------- ----------- ----------- --------------
1          0           archdg     1           1048576     4           102399      53232       50
2          1           datadg     1           1048576     4           102399      **41176**       28
3          125         VOTE       1           1048576     4           36864       36840       2
4          126         DCR        1           1048576     4           30720       30696       2
#### 检查DATADG剩余大小

## 新增存储磁盘检查
存储划分磁盘，并且通过多路径软件可以识别到新增的磁盘；
[root\@HOSTNAME rules.d]# `multipath -ll |grep -i dg-|sort `
archdg-asm01 (3600507670881888ac000000000000003) dm-12 INSPUR,MCS
datadg-asm01 (3600507670881888ac000000000000002) dm-11 INSPUR,MCS
**datadg-asm02 (3600507670881888ac0000000000000af) dm-13 INSPUR,MCS
**dcrdg-asm01 (3600507670881888ac000000000000000) dm-9 INSPUR,MCS
votedg-asm01 (3600507670881888ac000000000000001) dm-10 INSPUR,MCS

[root@HOSTNAME ~]# multipath -ll |grep -i dg-|sort 
archdg-asm01 (3600507670881888ac000000000000003) dm-12 INSPUR,MCS
datadg-asm01 (3600507670881888ac000000000000002) dm-11 INSPUR,MCS
**datadg-asm02 (3600507670881888ac0000000000000af) dm-13 INSPUR,MCS
**dcrdg-asm01 (3600507670881888ac000000000000000) dm-9 INSPUR,MCS
votedg-asm01 (3600507670881888ac000000000000001) dm-10 INSPUR,MCS
#### `两台机器均需认到该LUN；`
## 修改裸设备配置
#cd /etc/udev/rules.d/
[root@HOSTNAME rules.d]#` cat 88-dm-asmdevices.rules `
ENV{DM_NAME}=="votedg-asm01",  OWNER:="dmdba", GROUP:="dmdbagrp", MODE:="0660", SYMLINK+="iscsi/dm-$env{DM_NAME}"
ENV{DM_NAME}=="dcrdg-asm01",   OWNER:="dmdba", GROUP:="dmdbagrp", MODE:="0660", SYMLINK+="iscsi/dm-$env{DM_NAME}"
ENV{DM_NAME}=="datadg-asm01",  OWNER:="dmdba", GROUP:="dmdbagrp", MODE:="0660", SYMLINK+="iscsi/dm-$env{DM_NAME}"
**ENV{DM_NAME}=="datadg-asm02",  OWNER:="dmdba", GROUP:="dmdbagrp", MODE:="0660", SYMLINK+="iscsi/dm-$env{DM_NAME}"**
ENV{DM_NAME}=="archdg-asm01",  OWNER:="dmdba", GROUP:="dmdbagrp", MODE:="0660", SYMLINK+="iscsi/dm-$env{DM_NAME}"
两台机器均需修改；

## 重新加载磁盘信息
`#/sbin/udevadm control --reload-rules`
`#/sbin/udevadm trigger --type=devices --action=change`
### 查看扩容后的磁盘
[root@HOSTNAME rules.d]#` ls -lrt /dev/iscsi/dm- *` #dm-后面加上星号；
lrwxrwxrwx 1 root root 8  6鏈30 17:45 /dev/iscsi/dm-datadg-asm01 -> ../dm-11
lrwxrwxrwx 1 root root 8  6鏈30 17:45 /dev/iscsi/dm-votedg-asm01 -> ../dm-10
lrwxrwxrwx 1 root root 8  6鏈30 17:45 /dev/iscsi/dm-archdg-asm01 -> ../dm-12
lrwxrwxrwx 1 root root 7  6鏈30 17:45 /dev/iscsi/dm-dcrdg-asm01 -> ../dm-9
**lrwxrwxrwx 1 root root 8  6鏈30 17:45 /dev/iscsi/dm-datadg-asm02 -> ../dm-13**
dm-后面加上星号；

[dmdba@HOSTNAME ~]$`ls -lrt /dev/dm- *`   #dm-后面加上星号；
brw-rw---- 1 dmdba dmdbagrp 252,  9  6月 30 17:46 /dev/dm-9
brw-rw---- 1** dmdba dmdbagrp** 252, 13  6月 30 17:46 /dev/dm-13
brw-rw---- 1 dmdba dmdbagrp 252, 10  6月 30 17:51 /dev/dm-10
brw-rw---- 1 dmdba dmdbagrp 252, 11  6月 30 17:51 /dev/dm-11
brw-rw---- 1 dmdba dmdbagrp 252, 12  6月 30 17:51 /dev/dm-12
**两台机器均需查看，查看权限是否正确；**

## 扩容ASM磁盘组
### DMASMCMD初始化新的ASM磁盘
[dmdba@HOSTNAME bin]$
[dmdba@HOSTNAME bin]$./dmasmcmd 
ASM>create asmdisk '/dev/iscsi/dm-datadg-asm02' 'DATADG02'
[Trace]The ASM initialize asmdisk /dev/iscsi/dm-datadg-asm02 to name DMASMDATADG02
Used time: 4.454(ms).

### Dmasmtool扩展磁盘组，DSC0节点执行：
[dmdba@HOSTNAME bin]$ ./dmasmtool DCR_INI=/dmdba/config/dmdcr.ini
DMASMTOOL V8
ASM>alter diskgroup 'datadg' add asmdisk '/dev/iscsi/dm-datadg-asm02'
Used time: 59.211(ms).

### 查询ASM磁盘使用率；
SQL>  select * from v$asmgroup;
行号     GROUP_ID    GROUP_NAME N_DISK      AU_SIZE     EXTENT_SIZE TOTAL_SIZE  FREE_SIZE   TOTAL_FILE_NUM
---------- ----------- ---------- ----------- ----------- ----------- ----------- ----------- --------------
1          0           archdg     1           1048576     4           102399      53232       50
2          1           datadg     2           1048576     4           204798      **143564**      28
3          125         VOTE       1           1048576     4           36864       36840       2
4          126         DCR        1           1048576     4           30720       30696       2
已用时间: 6.026(毫秒). 执行号:291496600.

### 扩容表空间
按照需求增加数据文件
SQL>alter tablespace tb_name add datafile ‘+datadg/DAMENG/TBS02.dbf’ size 10240 autoextend on next 1024 maxsize 30720;

### 扩容后检查
SQL>
``` 
select file_name , TABLESPACE_NAME, USER_BYTES/1024/1024 USED_SIZE,BYTES/1024/1024 CURR_SIZE,
MAXBYTES/1024/1024 MAXSIZE,AUTOEXTENSIBLE  FROM  DBA_DATA_FILES;
```

已用时间: 63.690(毫秒). 执行号:1200.

### 计算可扩展的表空间使用率情况
```  
SELECT
        d.tablespace_name name            ,
        d.status status                   ,
        d.contents type                   ,
        a.MAXBYTES/1024/1024 MAX_SPACE    ,
        a.bytes   /1024/1024 ts_size      ,
        f.bytes   /1024/1024 free         ,
        (a.bytes  -f.bytes)/1024/1024 used,
        (a.bytes  -f.bytes) / a.MAXBYTES pct_used
FROM
        dba_tablespaces d,
        (
                select
                        tablespace_name ,
                        sum(bytes) bytes,
                        sum(case t.AUTOEXTENSIBLE when 'YES' THEN
                                                (
                                                        SELECT t.MAXBYTES FROM dba_data_files b where b.FILE_NAME=t.FILE_NAME
                                                ) ELSE
                                                (
                                                        SELECT t.BYTES FROM dba_data_files c where c.FILE_NAME=t.FILE_NAME
                                                ) end) MAXBYTES
                from
                        dba_data_files T
                group by
                        tablespace_name
        )
        a,
        (
                select
                        tablespace_name,
                        sum(bytes) bytes
                from
                        dba_free_space
                group by
                        tablespace_name
        )
        f
WHERE
        d.tablespace_name = a.tablespace_name
    AND d.tablespace_name = f.tablespace_name;
	```

ITPub博客

达梦数据库DSC架构下ASM扩容及表空间扩容实施