增加磁盘之前的asm状态
ASMCMD> lsdg State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED NORMAL N 512 512 4096 4194304 8388592 4669376 2097148 1286114 0 Y DATA/ ASMCMD> lsdsk Path /dev/asm-disk1 /dev/asm-disk2 /dev/asm-disk3 /dev/asm-disk4 Col path form a20; set linesize 200 SQL> select name,STATE,FAILGROUP,PATH,MOUNT_STATUS from v$asm_disk; NAME STATE FAILGROUP PATH MOUNT_S ------------------------------ -------- ------------------------------ -------------------- ------- NORMAL /dev/asm-disk7 CLOSED NORMAL /dev/asm-disk6 CLOSED NORMAL /dev/asm-disk8 CLOSED NORMAL /dev/asm-disk5 CLOSED DATA_0003 NORMAL DATA_0003 /dev/asm-disk4 CACHED DATA_0002 NORMAL DATA_0002 /dev/asm-disk3 CACHED DATA_0001 NORMAL DATA_0001 /dev/asm-disk2 CACHED DATA_0000 NORMAL DATA_0000 /dev/asm-disk1 CACHED SQL> show parameter power NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ asm_power_limit integer 1
把ASM_POWER_LIMIT 这个参数改到最大
SQL> Alter SYSTEM set ASM_POWER_LIMIT =11; System altered.
增加4块磁盘
SQL> alter diskgroup data add disk '/dev/asm-disk5' name DATA_0004, '/dev/asm-disk6' name DATA_0005, '/dev/asm-disk7' name DATA_0006, '/dev/asm-disk8' name DATA_0007;
增加之后的磁盘空间，可以看到增加了一倍。
ASMCMD> lsdg State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED NORMAL Y 512 512 4096 4194304 16777184 13057720 2097148 5480286 0 Y DATA/ ASMCMD>
查看操作需要的时间
SQL> select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION; INST_ID OPERA STAT POWER SOFAR EST_WORK EST_RATE EST_MINUTES ---------- ----- ---- ---------- ---------- ---------- ---------- ----------- 1 REBAL WAIT 11 0 0 0 0 1 REBAL RUN 11 12447 498551 5419 89 1 REBAL DONE 11 0 0 0 0 1 REBAL DONE 11 0 0 0 0 2 REBAL WAIT 11 2 REBAL WAIT 11 2 REBAL WAIT 11 2 REBAL WAIT 11 8 rows selected. SQL> !date; Mon Nov 23 20:04:42 CST 2020 SQL> select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION; INST_ID OPERA STAT POWER SOFAR EST_WORK EST_RATE EST_MINUTES ---------- ----- ---- ---------- ---------- ---------- ---------- ----------- 1 REBAL WAIT 11 0 0 0 0 1 REBAL RUN 11 48285 498551 4983 90 1 REBAL DONE 11 0 0 0 0 1 REBAL DONE 11 0 0 0 0 2 REBAL WAIT 11 2 REBAL WAIT 11 2 REBAL WAIT 11 2 REBAL WAIT 11 8 rows selected. SQL> !date; Mon Nov 23 20:11:44 CST 2020
