I am new to the DBA role and also in a process of learning. I need your help in adding space to ASM disk group. My VMware admin will be adding disk space to the VM's, and then the Linux admin is going to add space to the Linux servers.Finally I think I need to rebalance the database disk group to see the added space. I am not sure what all steps involved in this process. I am reading Oracle Documentation but I am little unclear and hesitating. Please let me know the steps involved in adding the space to ASM disk group.
We are using
Oracle DB version 126.96.36.199.0
Linux version: 2.6.18-238.12.1.el5
Thanks for your help
The command at DB level is "Alter diskgroup <DG name> add disk 'disk_name';
Check this links as well:
I guess it would be better if you ask your doubts directly here.
an example command is below
ALTER DISKGROUP disk_group_1 ADD DISK '/devices/disk3' REBALANCE POWER 5
when you add a new disk to a diskgroup, rebalance process starts automatically. You can determine a power limit value for rebalancing. The default rebalance power value is determined by ASM_POWER_LIMIT parameter. The value can be up to 1024 in 11g
Thank You ALL for the reply.
1. How can I check whether the LUNs within the dik group have the same sizes?
2. I am thinking I need to do the following, please let me know if I am incorrect
A). +ASM> /etc/init.d/oracleasm listdisks to make sure the disk is available from all the nodes
B). As a rootscan for the new disk
C). alter diskgroup DATA01 add disk ‘NEW DISK';
D). alter diskgroup data01 rebalance power 1; -- ASM_POWER_LIMIT parameter value is is set to 1
You can also use asmcmd program from grid home, but you can just see disk sizes you have already added a diskgroup.
1. set oracle_home to grid home
3. lsdsk -k
Furthermore, you can use lsdg command for diskgroups.
you can use v$asm_disk_stat on your asm instance.
I think you should do this one command.
This overrides ASM_POWER_LIMIT, but if your diskgroup is big, it takes long time.
alter diskgroup DATA01 add disk ‘NEW DISK' rebalance power 1;
you can monitor rebalance operation
Thank You ALL. Much appriciated for the detailed explaination.
One more question, after the rebalance do I need to restart each instance. I have forgot to mention that we have 2 node RAC cluster, so I am assuming that I need to
1. Add and rebalance the diskgroup on node1 first
2. Shutdown and instance and restart the instance
3. Do the steps 1 & 2 on Node2
Am I correct?