Message-ID: <11070.209.244.4.106.1197059176.squirrel@webmail.quasardb.com>
In-Reply-To: <30128.14258.qm@web27813.mail.ukl.yahoo.com>
References: <30128.14258.qm@web27813.mail.ukl.yahoo.com>
Date: Fri, 7 Dec 2007 12:26:16 -0800 (PST)
Subject: Re: Stupidity with ASM rebalancing
From: krish.hariharan@quasardb.com
To: hrishys@yahoo.co.uk
Cc: oracle-l@freelists.org
User-Agent: SquirrelMail/1.4.10a
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: krish.hariharan@quasardb.com

Here is one that annoyed me
1. ASM disk group was running out of space
2. Additional disks were added to disk group
3. Database continues get segment cannot extend (ORA-1652) or unable to
resize file (ORA-1237)
4. Manual rebalance (or automatic) fixes problem.

There is an easy enough work around for this with good storage management
practices but I did not agree with the implementation, in principle, of
not allocating space even when disk space was avaiable until the rebalance
was done.

-Krish

"Note that having free disk space is not sufficient to ensure that space
can be allocated. There must be free disk space on *ALL* disks in the disk
group since the allocated space is taken evenly from all disks."


--
http://www.freelists.org/webpage/oracle-l