v$asm_diskgroup和v$asm_disk中對於 disk 大小的不同含義,vasmdiskgroup

來源:互聯網
上載者:User

v$asm_diskgroup和v$asm_disk中對於 disk 大小的不同含義,vasmdiskgroup
v$asm_diskgroup 中看到的大小是各個物理磁碟(raw or sdh3)大小的sum值。v$asm_disk 中顯示的大小是 ASM disk(DGDATA_0003)分配時(將該asm disk 加入asm disk group時)指定的大小

從 ASM alert log中可以看到SQL> CREATE DISKGROUP dgdata External REDUNDANCY DISK '/dev/raw/raw7' SIZE 4568M , '/dev/raw/raw8' SIZE 4587M , '/dev/raw/raw9' SIZE 6578M , '/dev/raw/raw10' SIZE 6710M <<<<<=========分配給DG的只有6710M 而該/dev/raw/raw10 對應的disk(or partition)其實有10240M


 

可以在業務低峰時間,通過以下命令,把剩餘空間給ASM 使用

SQL>ALTER DISKGROUP dgdata  RESIZE DISK DGDATA_0003 SIZE 10240M REBALANCE POWER 5 


 注意:

這裡ASM DISKGROUP採用的是External REDUNDANCY,磁碟大小可以不一致。

 

 

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.