oracle12c下rac如何扩容asm存储

本篇文章为免费主机域名大家展示了oracle12c下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
-llgrid用户create
diskgroup data_dg25t external redundancy disk’/dev/data-disk05-2.5t’;[root@inmdb04
~]# multipath -llmpathp
(3600000e00d100000001007f4004f0000) dm-4 FUJITSU,ETERNUS_DX400size=1000G
features=’0′ hwhandler=’0′ wp=rw`-+-
policy=’round-robin 0′ prio=1 status=active `- 3:0:0:14 sdp 8:240 active ready runningmpatho
(3600000e00d100000001007f4004d0000) dm-2 FUJITSU,ETERNUS_DX400size=1000G
features=’0′ hwhandler=’0′ wp=rw`-+-
policy=’round-robin 0′ prio=1 status=active `- 3:0:0:12 sdn 8:208 active ready running3600000e00d100000001007f400100000
dm-6 FUJITSU,ETERNUS_DX400size=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 runningmpathn
(3600000e00d100000001007f4004e0000) dm-3 FUJITSU,ETERNUS_DX400size=1000G
features=’0′ hwhandler=’0′ wp=rw`-+-
policy=’round-robin 0′ prio=1 status=active `- 3:0:0:13 sdo 8:224 active ready runningmpatha
(3600605b0073a96901c63704a1a11425f) dm-5 IBM,ServeRAID M5015size=557G
features=’0′ hwhandler=’0′ wp=rw`-+-
policy=’round-robin 0′ prio=1 status=active `- 0:2:0:0
sda 8:0 active ready runningmpathm
(3600000e00d100000001007f4000e0000) dm-0 FUJITSU,ETERNUS_DX400size=1000G
features=’0′ hwhandler=’0′ wp=rw`-+-
policy=’round-robin 0′ prio=1 status=active `- 3:0:0:10 sdl 8:176 active ready running3600000e00d100000001007f400110000
dm-7 FUJITSU,ETERNUS_DX400size=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 runningmpathl
(3600000e00d100000001007f4000f0000) dm-1 FUJITSU,ETERNUS_DX400size=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 -llmpathp
(3600000e00d100000001007f4004f0000) dm-4 FUJITSU,ETERNUS_DX400size=1000G
features=’0′ hwhandler=’0′ wp=rwmpatho
(3600000e00d100000001007f4004d0000) dm-2 FUJITSU,ETERNUS_DX400size=1000G
features=’0′ hwhandler=’0′ wp=rwmpathn
(3600000e00d100000001007f4004e0000) dm-3 FUJITSU,ETERNUS_DX400size=1000G
features=’0′ hwhandler=’0′ wp=rwmpathm
(3600000e00d100000001007f4000e0000) dm-0 FUJITSU,ETERNUS_DX400size=1000G
features=’0′ hwhandler=’0′ wp=rwmpathl
(3600000e0免费主机域名0d100000001007f4000f0000) dm-1 FUJITSU,ETERNUS_DX400size=1000G
features=’0′ hwhandler=’0′ wp=rw
要添加的是五个盘：mpathp
(3600000e00d100000001007f4004f0000)mpatho
(3600000e00d100000001007f4004d0000)mpathn
(3600000e00d100000001007f4004e0000)mpathm
(3600000e00d100000001007f4000e0000)mpathl
(3600000e00d100000001007f4000f0000)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 2016Copyright
(c) 1982, 2014, Oracle. All rights reserved.Connected
to:Oracle
Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit ProductionWith the
Real Application Clusters and Automatic Storage Management optionsSQL>
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.64DATA_DG 6242304
2395221 61.63FRA_DG 1048576
583997 44.31SQL>
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.64FRA_DG 1048576
583997 44.31DATA_DG 9314304
5467164 41.3SQL>
create
diskgroup data_dg25t external redundancy disk’/dev/data-disk05’;
这个操作后，没有显示有内容
可以看到成功挂载的新盘已在磁盘组中。Select *
from v$asm_disk;上述内容就是oracle12c下rac如何扩容asm存储，你们学到知识或技能了吗？如果还想学到更多技能或者丰富自己的知识储备，欢迎关注云技术行业资讯频道。

相关推荐: Oracle RAC如何搭建

这篇文章将为大家详细讲解有关Oracle RAC如何搭建，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。RAC搭建一、准备工作. 11.规划. 12.网络配适器准备（rac1& rac2）. 23.关闭防火墙和SEli…