alert.log同样也有日志记录:
Thu Apr 13 16:59:54 2017 SUCCESS: disk DATADG_0004 (4.2744176966) added to diskgroup DATADG 4.等待同步完成等待同步完成:
select * from v$asm_operation; GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE ------------ ----- ---- ---------- ---------- ---------- ---------- ---------- ----------- -------------------------------------------- 1 REBAL RUN 7 7 10833 492997 7195 67 Elapsed: 00:00:00.46 17:00:49 SQL>可以在同步的期间根据实际业务需求调整rebalance的级别:
17:04:59 SQL> alter diskgroup datadg rebalance power 5; Diskgroup altered. 17:06:34 SQL> select * from v$asm_operation; GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE ------------ ----- ---- ---------- ---------- ---------- ---------- ---------- ----------- -------------------------------------------- 1 REBAL RUN 5 5 11106 240895 6817 33 Elapsed: 00:00:00.46最后同步完成,上述查询将不会有结果输出。
最后可以查看下DG磁盘组空间情况:
--查看DG磁盘组空间情况 ASMCMD> lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN Y 512 4096 1048576 10240000 531040 0 531040 0 N DATADG/ MOUNTED EXTERN N 512 4096 1048576 3072000 713616 0 713616 0 N RECOVERYDG/ ASMCMD>至此,整个ASM磁盘组的删盘加盘实施操作已经完成。