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

This article introduces the relevant knowledge of "how to expand the capacity of Oracle ASM disk groups". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

One: check the amount of free space in the disk group:

1.

[grid @ rac1 ~] $sqlplus / as sysasm / / enter the ASM instance

SQL > select name,allocation_unit_size,free_mb,total_mb from v$asm_diskgroup

NAME ALLOCATION_UNIT_SIZE FREE_MB TOTAL_MB

OCR 1048576 29796 30722

DATA 1048576 58142 60256

two。

[grid @ rac1 ~] $asmcmd lsdg

State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED EXTERN N 512 4096 1048576 60256 58142 0 58142 0 N DATA/

MOUNTED NORMAL N 512 4096 1048576 30722 29796 10241 9777 0 Y OCR/

Second: ASM disk group expansion (DATA expansion)

Be prepared in advance / dev/asm-disk5

Add a disk:

SQL > alter diskgroup DATA add disk'/ dev/asm-disk5'

Diskgroup altered.

View size:

SQL > select name,allocation_unit_size,free_mb,total_mb from v$asm_diskgroup

NAME ALLOCATION_UNIT_SIZE FREE_MB TOTAL_MB

OCR 1048576 29796 30722

DATA 1048576 69052 71168

Delete disk: / / requires the name of the disk to be mapped in ASM

SQL > alter diskgroup DATA drop disk'/ dev/asm-disk5'

Alter diskgroup DATA drop disk'/ dev/asm-disk5'

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15054: disk "/ DEV/ASM-DISK5" does not exist in diskgroup "DATA"

SQL > select name,path from v$asm_disk_stat

NAME PATH

OCR_0000 / dev/asm-disk2

OCR_0002 / dev/asm-disk4

OCR_0001 / dev/asm-disk3

DATA_0000 / dev/asm-disk1

DATA_0001 / dev/asm-disk5

SQL > alter diskgroup data drop disk DATA_0001

Diskgroup altered.

SQL > select name,allocation_unit_size,free_mb,total_mb from v$asm_diskgroup

NAME ALLOCATION_UNIT_SIZE FREE_MB TOTAL_MB

OCR 1048576 29796 30722

DATA 1048576 58142 60256

Because of the ASM striping feature, adding and deleting disks is actually the process of data redistribution Rebalance. "how to expand the capacity of the Oracle ASM disk group" is introduced here, thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.