oracle12c下rac如何擴容asm存儲

本篇文章為大家展示了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存儲，你們學到知識或技能了嗎？如果還想學到更多技能或者豐富自己的知識儲備，歡迎關注億速云行業資訊頻道。