共計 4376 個字符，預計需要花費 11 分鐘才能閱讀完成。
本篇文章為大家展示了 oracle12c 下 rac 如何擴容 asm 存儲，內容簡明扼要并且容易理解，絕對能使你眼前一亮，通過這篇文章的詳細介紹希望你能有所收獲。
1 rac 擴容 asm 存儲
基本思路：
第一步：通過 multipath -ll 命令找到 要加載的共享磁盤
第二步：將找到的共享盤，添加到綁定文件中（/etc/udev/rules.d/99-oracle.rules）
第三部：su – grid sqlplus “/as sysasm” 添加到數據庫磁盤組中。
create
diskgroup data_dg25t external redundancy disk /dev/data-disk05-2.5t
multipath
-ll
grid 用戶
create
diskgroup data_dg25t external redundancy disk /dev/data-disk05-2.5t
1.1 具體添加過程 1.1.1 第一步：查找系統要添加的共享盤 [root@inmdb04
~]# multipath -ll
mpathp
(3600000e00d100000001007f4004f0000) dm-4 FUJITSU,ETERNUS_DX400
size=1000G
features= 0 hwhandler= 0 wp=rw
`-+-
policy= round-robin 0 prio=1 status=active
`- 3:0:0:14 sdp 8:240 active ready running
mpatho
(3600000e00d100000001007f4004d0000) dm-2 FUJITSU,ETERNUS_DX400
size=1000G
features= 0 hwhandler= 0 wp=rw
`-+-
policy= round-robin 0 prio=1 status=active
`- 3:0:0:12 sdn 8:208 active ready running
3600000e00d100000001007f400100000
dm-6 FUJITSU,ETERNUS_DX400
size=2.4T
features= 0 hwhandler= 0 wp=rw
`-+-
policy= round-robin 0 prio=1 status=enabled
`- 3:0:0:9
sdk 8:160 failed ready running
mpathn
(3600000e00d100000001007f4004e0000) dm-3 FUJITSU,ETERNUS_DX400
size=1000G
features= 0 hwhandler= 0 wp=rw
`-+-
policy= round-robin 0 prio=1 status=active
`- 3:0:0:13 sdo 8:224 active ready running
mpatha
(3600605b0073a96901c63704a1a11425f) dm-5 IBM,ServeRAID M5015
size=557G
features= 0 hwhandler= 0 wp=rw
`-+-
policy= round-robin 0 prio=1 status=active
`- 0:2:0:0
sda 8:0 active ready running
mpathm
(3600000e00d100000001007f4000e0000) dm-0 FUJITSU,ETERNUS_DX400
size=1000G
features= 0 hwhandler= 0 wp=rw
`-+-
policy= round-robin 0 prio=1 status=active
`- 3:0:0:10 sdl 8:176 active ready running
3600000e00d100000001007f400110000
dm-7 FUJITSU,ETERNUS_DX400
size=2.4T
features= 0 hwhandler= 0 wp=rw
`-+-
policy= round-robin 0 prio=1 status=enabled
`- 3:0:0:8
sdj 8:144 failed ready running
mpathl
(3600000e00d100000001007f4000f0000) dm-1 FUJITSU,ETERNUS_DX400
size=1000G
features= 0 hwhandler= 0 wp=rw
`-+-
policy= round-robin 0 prio=1 status=active
`- 3:0:0:11 sdm 8:192 active ready running
[root@inmdb04
~]#
簡化為：
[root@inmdb04
~]# multipath -ll
mpathp
(3600000e00d100000001007f4004f0000) dm-4 FUJITSU,ETERNUS_DX400
size=1000G
features= 0 hwhandler= 0 wp=rw
mpatho
(3600000e00d100000001007f4004d0000) dm-2 FUJITSU,ETERNUS_DX400
size=1000G
features= 0 hwhandler= 0 wp=rw
mpathn
(3600000e00d100000001007f4004e0000) dm-3 FUJITSU,ETERNUS_DX400
size=1000G
features= 0 hwhandler= 0 wp=rw
mpathm
(3600000e00d100000001007f4000e0000) dm-0 FUJITSU,ETERNUS_DX400
size=1000G
features= 0 hwhandler= 0 wp=rw
mpathl
(3600000e00d100000001007f4000f0000) dm-1 FUJITSU,ETERNUS_DX400
size=1000G
features= 0 hwhandler= 0 wp=rw
要添加的是五個盤：
mpathp
(3600000e00d100000001007f4004f0000)
mpatho
(3600000e00d100000001007f4004d0000)
mpathn
(3600000e00d100000001007f4004e0000)
mpathm
(3600000e00d100000001007f4000e0000)
mpathl
(3600000e00d100000001007f4000f0000)
1.1.4 添加到系統數據盤組中
alter
diskgroup data_dg add disk /dev/data-disk05
alter
diskgroup data_dg add disk /dev/data-disk06
alter
diskgroup data_dg add disk /dev/data-disk07
alter
diskgroup data_dg add disk /dev/data-disk08
alter
diskgroup data_dg add disk /dev/data-disk09
具體操作過程：
[grid@inmdb03
~]$ sqlplus /as sysasm
SQL*Plus:
Release 12.1.0.2.0 Production on Tue Nov 1 18:28:06 2016
Copyright
(c) 1982, 2014, Oracle. All rights reserved.
Connected
to:
Oracle
Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the
Real Application Clusters and Automatic Storage Management options
SQL
alter diskgroup data_dg add disk /dev/data-disk05
Diskgroup
altered.
SQL
alter diskgroup data_dg add disk /dev/data-disk06
Diskgroup
altered.
SQL
select name,TOTAL_MB ,FREE_MB ,round((TOTAL_MB-FREE_MB)/TOTAL_MB*100,2)
used_percent from v$asm_diskgroup order by used_percent desc ;
NAME TOTAL_MB FREE_MB USED_PERCENT
——————————
———- ———- ————
OCR_DG 15360 5432
64.64
DATA_DG 6242304
2395221 61.63
FRA_DG 1048576
583997 44.31
SQL
alter diskgroup data_dg add disk /dev/data-disk07
Diskgroup
altered.
SQL
SQL alter diskgroup data_dg add disk /dev/data-disk08
Diskgroup
altered.
SQL
alter diskgroup data_dg add disk /dev/data-disk09
Diskgroup
altered.
SQL
select name,TOTAL_MB ,FREE_MB ,round((TOTAL_MB-FREE_MB)/TOTAL_MB*100,2)
used_percent from v$asm_diskgroup order by used_percent desc ;
NAME TOTAL_MB FREE_MB USED_PERCENT
——————————
———- ———- ————
OCR_DG 15360 5432
64.64
FRA_DG 1048576
583997 44.31
DATA_DG 9314304
5467164 41.3
SQL
1.1.4.1 如果是創建新的磁盤組那就是如下命令：
create
diskgroup data_dg25t external redundancy disk /dev/data-disk05
1.1.5 監控數據重新條帶化操作視圖。
select * from v$asm_operation
這個操作后，沒有顯示有內容
1.1.6 添加成功后
可以看到成功掛載的新盤已在磁盤組中。
Select *
from v$asm_disk;
上述內容就是 oracle12c 下 rac 如何擴容 asm 存儲，你們學到知識或技能了嗎？如果還想學到更多技能或者豐富自己的知識儲備，歡迎關注丸趣 TV 行業資訊頻道。
