oracle的asm下扩容表空间,oracle12c 下rac 扩容asm存储

1rac扩容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;