Home » RDBMS Server » Server Administration » ASM DISKGROUP RESIZE (Oracle 11.1.0.7.0, RHEL)
ASM DISKGROUP RESIZE [message #566815] Wed, 19 September 2012 14:30 Go to next message
AviatoR
Messages: 43
Registered: February 2009
Member
Hi guyz,

I've been ASM quite a while, recently i had a time to explore it further. Maybe you guyz are more familiar with this situation. I've two diskgroups extdg and nordg which are of external and normal redundancy respectively. Total diskgroup size is 9G, usuable space came down to 3mb when i tried to resize it to itz maximum. the value under usable column shows the same.

FYI... i've totally three disks in nordg, two in one failgroup and one in another.
The disk sized equally 3g each.

Quote:

NAME TOTAL_MB FREE_MB USABLE_FILE_MB
------------------------------ ---------- ---------- --------------
EXTDG 2047 1995 1995
NORDG 9201 3073 3



The command i used to resize all disk to their max is
Quote:
SQL> alter diskgroup nordg resize all size 3067M;

Diskgroup altered.


Kindly enlighten me with your ideas. thanx in advance.
Re: ASM DISKGROUP RESIZE [message #566831 is a reply to message #566815] Thu, 20 September 2012 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Have you available space on the disks of the diskgroup so that the resize can be done?
Note that Oracle does not enlarge your uderlying OS "disks"; it is just able to use more already available space in these disks.

Regards
Michel
Re: ASM DISKGROUP RESIZE [message #566893 is a reply to message #566831] Thu, 20 September 2012 12:30 Go to previous messageGo to next message
AviatoR
Messages: 43
Registered: February 2009
Member
Yes, os disk has space in it... wondering how it'd show freespace 3G ... whereas the usable is still 3m...
Re: ASM DISKGROUP RESIZE [message #566895 is a reply to message #566893] Thu, 20 September 2012 12:41 Go to previous message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
Look at the v$asm_diskgroup.required_mirror_free column as well, and think about what ASM must do in order to guarantee that the group can survive loss of a disc.
Previous Topic: Delete stats gather stats
Next Topic: howto Change default XML Storage
Goto Forum:
  


Current Time: Sun Dec 01 14:34:43 CST 2024