16 积分	0 好友	7 主题

发消息

[SQL调优] EXDATA，中ASM磁盘的问题

1^#

发表于 2013-3-13 17:27:35 | 查看: 3893| 回复: 4

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  NORMAL  N       512 4096  4194304  33996800 775016       4803404       -2014194             0          N  DATA/
MOUNTED  NORMAL  N       512 4096  4194304  10937408  10653104          994309       4829397             0          N  RECO/
MOUNTED  NORMAL  N       512 4096  4194304 2087680 2084312          189789       947261             0          N  SYSTEMDG/

出现负值了，是什么意思呀。我做的是NORMAL类型的呀

分享0

收藏0 回复只看该作者道具举报

wanglixue2012

2^#

发表于 2013-3-13 18:56:04

天哪？ Usable_file_MB 为负值，难道会经不起一个disk的损坏吗？

Goal
Checking the value of USABLE_FILE_MB in v$asm_diskgroup it is noticed that the value has a negative value. What could this mean and what could be done given the circumstances?
Fix
Checking the definition in the documentation:
USABLE_FILE_MB = Amount of free space that can be safely utilized taking mirroring into account, and yet be able to restore redundancy after a failgroup failure.

When this value is negative and there is only one disk in your failure group, a disk failure could be critical for the system because it means that there is not enough free space to tolerate a disk failure. If a disk fails, the subsequent rebalance would run out of space before full redundancy could be restored to all files.
As such, this negative value is just a signal that the diskgroup's failgroups need more space in order to tolerate a possible failure of the entire failure group.
Starting 10gR2 this column is used to determine the "Used % of Safely Usable" for a Disk group. This metric generates a warning alert if the Disk Group is using 90% of the Safely usable space and Critical warning for 100%. The threshold limit can be changed to generate alerts at different values.

NOTE: For customers using Oracle Exadata Storage Servers, by default a failure group is a complete cell. This value may be negative as we recommend having enough free space to cover the loss of one disk (quarter and half racks) and two disks for full racks. You do not need to keep the freespace for an entire cell (the value you will see in USABLE_FILE_MB).

回复只看该作者道具举报