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

This article mainly explains "how to add disk to oracle rac". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to increase disk in oracle rac".

1. Storage partition disk to machine

two。 Find the disk name on the machine and bind it through udev-- pay attention to whether there is mutilpath

[root@rac1 ~] # ls / dev/mapper/

Arch control data data01 ocr1 ocr2 ocr3

Data01 is a newly added disk

3. Bind disk

Check the disk condition

SQL > set lines 175 pages 2000

SQL > col name for A30

SQL > col path for A40

SQL > select a.NAMErea.PATHrea.statereageb.NAMEreb .typerea.totalaccounmbmmb from v$asm_disk a.freewheeling mb where a.GROUP_NUMBER=b.GROUP_NUMBER order by b.namememera.name

NAME PATH STATE NAME TYPE TOTAL_MB FREE_MB

--

DATA_0000 / dev/mapper/data NORMAL DATA EXTERN 5120 1642

FRA_0000 / dev/mapper/arch NORMAL FRA EXTERN 2048 1075

OCR_0000 / dev/mapper/ocr1 NORMAL OCR EXTERN 2048 1819

OCR_0001 / dev/mapper/ocr2 NORMAL OCR EXTERN 2048 1847

OCR_0002 / dev/mapper/ocr3 NORMAL OCR EXTERN 2048 1849

Add disk

SQL > alter diskgroup DATA add disk'/ dev/mapper/data01' name DATA_0001

Diskgroup altered.

Check to see if the disk is finished.

SQL > select * from v$asm_operation

No rows selected

SQL > show parameter asm_power_limit

NAME TYPE VALUE

-

Asm_power_limit integer 1

Thank you for your reading, the above is the content of "how to increase the disk in oracle rac". After the study of this article, I believe you have a deeper understanding of how to increase the disk in oracle rac, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.