ASM的在线扩容

最新推荐文章于 2025-04-18 09:27:47 发布

bigclouder

最新推荐文章于 2025-04-18 09:27:47 发布

阅读量1.6k

点赞数

分类专栏： oracle 体系

本文链接：https://blog.youkuaiyun.com/kiwi_kid/article/details/40401627

版权

oracle 体系专栏收录该内容

38 篇文章

订阅专栏

本文介绍了Oracle自动存储管理(ASM)中磁盘的创建、列出、状态查询及删除操作过程。涉及具体命令如oracleasmcreatedisk、oracleasmlistdisks等，并展示了如何通过SQL查询获取ASM磁盘组和磁盘的状态。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

 1016 fdisk /dev/sddlmap
 1018 fdisk /dev/sddlmba
 1019 fdisk /dev/sddlmbb

oracleasm createdisk ASMDISK16 /dev/sddlmap1
oracleasm createdisk ASMDISK17 /dev/sddlmba1
oracleasm createdisk ASMDISK18 /dev/sddlmbb1


[17:48:41 root@storedg disks]# oracleasm listdisks 
ASMDISK01 
ASMDISK02 
ASMDISK03 
ASMDISK04 
ASMDISK05 
ASMDISK06 
ASMDISK07 
ASMDISK08 
ASMDISK09 
ASMDISK10 
ASMDISK11 
ASMDISK12 
ASMDISK13 
ASMDISK14 
ASMDISK15 
ASMDISK16 
ASMDISK17 
ASMDISK18
col path for a35
col failgroup for a30
select name, path, mode_status, state, disk_number,failgroup from v$asm_disk;

NAME PATH MODE_STATUS STATE DISK_NUMBER FAILGROUP
-------------------- -------------------- --------------------- ------------------------ ------------- --------------------
                     ORCL:ASMDISK16 ONLINE NORMAL 0
                     ORCL:ASMDISK17 ONLINE NORMAL 1
                     ORCL:ASMDISK18 ONLINE NORMAL 2
ASMDISK01 ORCL:ASMDISK01 ONLINE NORMAL 0 ASMDISK01
ASMDISK02 ORCL:ASMDISK02 ONLINE NORMAL 1 ASMDISK02
ASMDISK03 ORCL:ASMDISK03 ONLINE NORMAL 2 ASMDISK03
ASMDISK04 ORCL:ASMDISK04 ONLINE NORMAL 3 ASMDISK04
ASMDISK05 ORCL:ASMDISK05 ONLINE NORMAL 4 ASMDISK05
ASMDISK06 ORCL:ASMDISK06 ONLINE NORMAL 5 ASMDISK06
ASMDISK07 ORCL:ASMDISK07 ONLINE NORMAL 6 ASMDISK07
ASMDISK08 ORCL:ASMDISK08 ONLINE NORMAL 7 ASMDISK08
ASMDISK09 ORCL:ASMDISK09 ONLINE NORMAL 8 ASMDISK09
ASMDISK10 ORCL:ASMDISK10 ONLINE NORMAL 9 ASMDISK10
ASMDISK11 ORCL:ASMDISK11 ONLINE NORMAL 10 ASMDISK11
ASMDISK12 ORCL:ASMDISK12 ONLINE NORMAL 11 ASMDISK12
ASMDISK13 ORCL:ASMDISK13 ONLINE NORMAL 12 ASMDISK13
ASMDISK14 ORCL:ASMDISK14 ONLINE NORMAL 13 ASMDISK14
ASMDISK15 ORCL:ASMDISK15 ONLINE NORMAL 14 ASMDISK15

select name,state from v$asm_diskgroup;

show parameter asm_power_limit;

ORCL:ASMDISK16


alter diskgroup DATA drop disk 'ASMDISK06';
alter diskgroup DATA drop disk 'ASMDISK07';
alter diskgroup DATA drop disk 'ASMDISK08';

alter diskgroup DATA rebalance power 5;

select * from v$asm_operation;
        1. /u01/app/oraInventory/orainstRoot.sh
        2. /u01/app/oracle/product/11.2.0/db/root.sh



echo "scsi add-single-device 0 0 0 15" > /proc/scsi/scsi
echo "scsi add-single-device 0 0 1 15" > /proc/scsi/scsi
echo "scsi add-single-device 1 0 0 15" > /proc/scsi/scsi 
echo "scsi add-single-device 1 0 1 15" > /proc/scsi/scsi

echo "scsi remove-single-device 1 0 0 17" > /proc/scsi/scsi
echo "scsi remove-single-device 1 0 1 17" > /proc/scsi/scsi
echo "scsi remove-single-device 0 0 1 17" > /proc/scsi/scsi
echo "scsi remove-single-device 0 0 0 17" > /proc/scsi/scsi

/dev/sddlmbb configured /dev/sdbr 0 0 0 17
                                /dev/sdbs 0 0 1 17
                                /dev/sdbt 1 0 0 17
                                /dev/sdbu 1 0 1 17
/dev/sddlmbc configured /dev/sdbv 0 0 0 18
                                /dev/sdbw 0 0 1 18
                                /dev/sdbx 1 0 0 18
                                /dev/sdby 1 0 1 18
/dev/sddlmbd configured /dev/sdbz 0 0 0 19
                                /dev/sdca 0 0 1 19
                                /dev/sdcb 1 0 0 19
                                /dev/sdcc 1 0 1 19