oracle12c下rac如何扩容asm存储

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