ASM磁盘在线扩容

磁盘扩容

以下的查询是做对比用
disql V8
SQL> SELECT
GROUP_ID,
GROUP_NAME,
N_DISK,
AU_SIZE,
ROUND(TOTAL_SIZE / 1024, 2) AS total_gb, – MB转GB
ROUND(FREE_SIZE / 1024, 2) AS free_gb, – MB转GB
ROUND((TOTAL_SIZE - FREE_SIZE) / 1024, 2) AS used_gb, – MB转GB
ROUND((TOTAL_SIZE - FREE_SIZE) / NULLIF(TOTAL_SIZE, 0) * 100, 2) AS used_percent
FROM SYS.V$ASMGROUP;2 3 4 5 6 7 8 9 10

行号 GROUP_ID GROUP_NAME N_DISK AU_SIZE TOTAL_GB FREE_GB USED_GB USED_PERCENT

1 0 DMDATA 1 1048576 29 26 3 0 —扩容该盘
2 1 DMLOG 1 1048576 14 12 2 0
3 2 DMARCH 1 1048576 9 8 1 0
4 125 VOTE 1 1048576 1 0 0 0
5 126 DCR 1 1048576 1 0 0 0

SQL> select DISK_NAME,DISK_PATH,SIZE,status from v$asmdisk;

行号 DISK_NAME DISK_PATH SIZE STATUS

1 DMASMDATA0 /dev/raw/raw4 30687 NORMAL —扩容该盘
2 DMASMLOG0 /dev/raw/raw3 15327 NORMAL
3 DMASMARCH0 /dev/raw/raw5 10207 NORMAL
4 DMASMvote /dev/raw/raw2 1024 NORMAL
5 DMASMdcr /dev/raw/raw1 1024 NORMAL
6 UNKNOWN /dev/raw/raw6 0 NULL

6 rows got

SQL> select GROUP_NAME,TOTAL_MB,FREE_MB,TYPE from v$asmgroup;

行号 GROUP_NAME TOTAL_MB FREE_MB TYPE

1 DMDATA 30687 27448 EXTERN —扩容该盘
2 DMLOG 15327 13268 EXTERN
3 DMARCH 10207 9148 EXTERN
4 VOTE 1024 1000 EXTERN
5 DCR 1024 1000 EXTERN

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

lsblk
sdb 8:16 0 1G 0 disk
sdc 8:32 0 1G 0 disk
sdd 8:48 0 15G 0 disk
sde 8:64 0 30G 0 disk
sdf 8:80 0 10G 0 disk
sdg 8:96 0 8G 0 disk
sr0 11:0 1 4.4G 0 rom

在两个节点执行，挂载改盘

raw /dev/raw/raw6 /dev/sdg
ls -l /dev/raw/*

查看是否生效

[root@dsc0 ~]# ls -l /dev/raw/*
crw-rw---- 1 dmdba dinstall 162, 1 8月 20 15:04 /dev/raw/raw1
crw-rw---- 1 dmdba dinstall 162, 2 8月 20 15:22 /dev/raw/raw2
crw-rw---- 1 dmdba dinstall 162, 3 8月 20 15:21 /dev/raw/raw3
crw-rw---- 1 dmdba dinstall 162, 4 8月 20 15:12 /dev/raw/raw4
crw-rw---- 1 dmdba dinstall 162, 5 8月 20 15:21 /dev/raw/raw5
crw-rw---- 1 dmdba dinstall 162, 6 8月 20 15:04 /dev/raw/raw6 --新的 --有新的磁盘
crw-rw---- 1 root disk 162, 0 8月 20 15:04 /dev/raw/rawctl

扩容ASM磁盘组

cd /home/dmdba/dm/dmdbms/bin
./dmasmcmd
create asmdisk ‘/dev/raw/raw6’ ‘DMDATA02’

扩展磁盘组

这一步在控制节点dsc1操作
cd /home/dmdba/dm/dmdbms/bin
./dmasmtool dcr_ini=/home/dmdba/dm/dmdbms/dsc_config/TXDB_DSC0/dmdcr0.ini
alter diskgroup ‘DMDATA’ add asmdisk ‘/dev/raw/raw6’

查询ASM磁盘使用率