oracle的ASM扩容
阅读原文时间:2023年07月08日阅读:3

#查看服务器上总共有多少个asmdisk
[grid@rkdb1]$ asmcmd lsdsk --discovery
Path
/dev/oracleasm/disks/OCPDATA1
/dev/oracleasm/disks/OCPDATA2

#查看已经在asmdiskgroup中的asmdisk
[grid@rkdb1]$ asmcmd lsdsk
Path
/dev/oracleasm/disks/OCPDATA1

#查看没有在asmdiskgroup的asmdisk(即没有被使用的asmdisk)
[grid@rkdb1]$ asmcmd lsdsk --candidate
Path
/dev/oracleasm/disks/OCPDATA2

#查看asmdiskgroup的信息(磁盘组的可用空间等)
[grid@rkdb1]$ asmcmd lsdg

#将未用磁盘添加到磁盘组(扩容asm)
su - grid
[grid@rkdb1]$ sqlplus / as sysasm
set linesize 300
set pagesize 100
col name format a20
col path format a40
col state format a10

select group_number,name,path,state from v$asm_disk;
alter diskgroup RES_DATA add disk '/dev/oracleasm/disks/OCPDATA2';