正德厚生,臻于至善

Oracle ASM磁盘组不均衡

ASM External Redundancy Diskgroups Present Large Imbalance (V$ASM_DISK.FREE_MB) In 11.2 or 12.1 Releases (Doc ID 1980292.1)
Top Issues : Space Imbalance in ASM Diskgroup (Doc ID 2247747.1)
Space Imbalance in ASM Normal Redundancy Diskgroup Having a Quorum Failgroup (Doc ID 1379665.1)

问题 #1 ASM 外部冗余磁盘组存在严重的不平衡 (V$ASM_DISK.FREE_MB)
问题 #2 具有仲裁故障组的 ASM 正常冗余磁盘组中的空间不平衡
问题 #3 不平衡的 ASM 磁盘组,它不是均匀平衡(自动或手动)

set lines 200 pages 50000
col file_name for a80
col TABLESPACE_NAME for a30
select file_id,file_name,tablespace_name,autoextensible,BYTES/1024/1024,MAXBYTES/1024/1024,status from dba_data_files order by 1;
select file_id,file_name,tablespace_name,autoextensible,BYTES/1024/1024,MAXBYTES/1024/1024,status from dba_temp_files order by 1;

set lines 200 pages 50000
col name for a25
col path for a55
select group_number,disk_number,name,path,total_mb/1024 total_G,mode_status,repair_timer from v$asm_disk order by group_number,disk_number;

alter diskgroup DATA check all repair;
alter diskgroup DATA rebalance power 11;

select * from v$asm_operation;
赞(0) 打赏
未经允许不得转载:徐万新之路 » Oracle ASM磁盘组不均衡

评论 抢沙发

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫

微信扫一扫

登录

找回密码

注册