ASM free and usable space in case of Imbalanced Diskgroup

bdt's oracle blog

In case of “normal” situation (I mean no Imbalanced Disks) you should be able to easily know how much space is available into the ASM Diskgroup.

Harald van Breederode already explained it in detail into this blog post.

But now suppose the Diskgroup has imbalanced Disks: It can occurs for several reasons:

  • A rebalance operation has been aborted/halted.
  • A rebalance operation is waiting.
  • Disks are not of the same size.

Let’s simulate an Imbalanced situation and compute the usable free space:

First I created a “balanced” diskgroup with normal redundancy.

SQL> !kfod -------------------------------------------------------------------------------- Disk Size Path User Group ================================================================================ 1: 225280 Mb /dev/san/JMO7C43D06 oracle dba 2: 56320 Mb /dev/san/JMO7C52D06 oracle dba 3: 56320 Mb /dev/san/JMO7C61D06 oracle dba 4: 225280 Mb /dev/san/WIN7C43D06 oracle dba 5: 56320 Mb /dev/san/WIN7C52D06 oracle dba 6: 56320 Mb /dev/san/WIN7C61D06 oracle dba -------------------------------------------------------------------------------- SQL> create diskgroup BDT normal redundancy failgroup F1 disk '/dev/san/JMO7C52D06' failgroup F2 disk…

View original post 1,224 more words

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s