oracle的ASM扩容
#查看服务器上总共有多少个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';
做一个决定,并不难,难的是付诸行动,并且坚持到底。