共计 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 行业资讯频道。
