Shulou(Shulou.com)05/31 Report--

This article shows you how to expand the asm storage capacity of rac under oracle12c. The content is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

1 rac expansion of asm storage

Basic ideas:

Step 1: find the shared disk to load through the multipath-ll command

Step 2: add the shared disk found to the binding file (/ etc/udev/rules.d/99-oracle.rules)

Part III: su-grid sqlplus "/ as sysasm" is added to the database disk group.

Create diskgroup data_dg25t external redundancy disk'/dev/data-disk05-2.5t'

Multipath-ll

Grid user

Create diskgroup data_dg25t external redundancy disk'/dev/data-disk05-2.5t'

1.1 specific add process 1.1.1 step 1: find the shared disk to be added by the system

[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

`- 3VOV 0RU 0RU 14 sdp 8Rd 240active 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 sdn 0VOV 0RU 12 sdn 8Rd 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

`- 3VOV 0RU 0RU 9 sdk 8Rd 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

`- 3VOV 0VOUR 13 sdo 8Rd 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 sda 2VOUR 0RO 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

`- 3VOV 0RU 0RU 10 sdl 8Rd 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

`- 3VOV 0VOUR 0RU 8 sdj 8RU 144failed 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

`- 3VOVUR 0UR 0UR 11 sdm 8UR 192 active ready running

[root@inmdb04 ~] #

Simplified to:

[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

Five disks are to be added:

Mpathp (3600000e00d100000001007f4004f0000)

Mpatho (3600000e00d100000001007f4004d0000)

Mpathn (3600000e00d100000001007f4004e0000)

Mpathm (3600000e00d100000001007f4000e0000)

Mpathl (3600000e00d100000001007f4000f0000)

1.1.4 add to the system disk group

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'

Specific operation process:

[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 if you are creating a new disk group, it is the following command:

Create diskgroup data_dg25t external redundancy disk'/dev/data-disk05'

1.1.5 Monitoring data re-striping operation view.

Select * from v$asm_operation

After this operation, no content is displayed.

1.1.6 after a successful addition

You can see that the new disk that was successfully mounted is already in the disk group.

Select * from v$asm_disk

The above is how rac expands the capacity of asm storage under oracle12c. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.