**# 達夢資料庫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;
	```

達夢資料庫DSC架構下ASM擴容及表空間擴容實施

相關文章