oracle12c下rac如何扩容asm存储
本篇文章为大家展示了oracle12c下rac如何扩容asm存储,内容简明扼要并且容易理解,绝对能使你眼前一亮,通过这篇文章的详细介绍希望你能有所收获。
创新互联公司主要从事成都网站设计、网站建设、网页设计、企业做网站、公司建网站等业务。立足成都服务襄垣,10年网站建设经验,价格优惠、服务专业,欢迎来电咨询建站服务:028-86922220
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存储,你们学到知识或技能了吗?如果还想学到更多技能或者丰富自己的知识储备,欢迎关注创新互联行业资讯频道。
网站题目:oracle12c下rac如何扩容asm存储
本文网址:http://myzitong.com/article/ggjgpd.html