Resize Oracle ASM disk groups

Question

Hi, how can I resize Oracle ASM disk groups after increasing the size of EBS volumes using elastic volumes feature? I increased my EBS volumes from 50GB to 100GB but the ASM disk group still shows the old size.

rePost-User-2941322 · Accepted Answer

Here is a clear answer that might help:
To resize Oracle ASM disk groups after increasing EBS volume size, follow these steps:

1. First, verify that the EBS volume modification is complete using:

aws ec2 describe-volumes-modifications --region  --volume-id

Make sure the ModificationState is "optimizing" or "completed".
1. Resize the partition on the EBS volume using the growpart command:

growpart /dev/nvme1n1 1  # Adjust device name according to your setup

1. Verify the partition has been extended using the lsblk command. The partition size should now match the new volume size.
2. After growing all partitions, resize the ASM disk group to recognize the new size using the SQL command:

ALTER DISKGROUP DATA RESIZE ALL;

1. Verify the new size by querying the ASM views:

select substr(g.name,1,10) disk_group_name,
       round(g.total_mb/1024) total_dg_size_gb,
       round(d.total_mb/1024) asm_disk_size_gb
from v$asm_diskgroup g, v$asm_disk d
where g.group_number=d.group_number
and g.name='DATA';

Kindly note : If you're resizing disks to more than 2TB and encounter ORA-15099 error, ensure that the COMPATIBLE.ASM or COMPATIBLE.RDBMS disk group attribute is set to 12.1 or greater.

re:Post Agent · Answer

When you increase the size of EBS volumes using the Elastic Volumes feature, the change only happens at the block storage level. To reflect this increased size in your Oracle ASM disk groups, you need to follow a multi-step process:

1. First, verify that the EBS volume size increase is recognized at the operating system level by using the `lsblk` command. If the new size is not showing, you may need to run `sudo growpart /dev/volume_to_grow 1` to expand the partition.

2. For Oracle ASM disk groups, after the EBS volume has been resized at the block level, you need to use Oracle ASM commands to recognize the additional space:

- Connect to the ASM instance using SQL*Plus as SYSASM or a user with ASM administrator privileges
- Use the ASMCMD utility or SQL commands to resize the ASM disks
- For example, you can use the ALTER DISKGROUP command to resize all disks in a disk group:
```
ALTER DISKGROUP data_dg RESIZE ALL;
```
- Alternatively, you can resize specific disks:
```
ALTER DISKGROUP data_dg RESIZE DISK 'disk_path' SIZE 100G;
```

3. After resizing, verify the new size is recognized by checking the ASM disk group size using:
```
SELECT name, total_mb, free_mb FROM v$asm_diskgroup;
```

Remember that while the Elastic Volumes feature allows you to modify EBS volumes without detaching them or restarting your instance, you still need to perform these additional steps to make the Oracle ASM disk groups recognize and utilize the additional space.  
**Sources**  
[Increase EBS not reflecting on the ubuntu | AWS re:Post](https://repost.aws/questions/QUrU_bKSHCRBqw9Zzx8gTTOA/increase-ebs-not-reflecting-on-the-ubuntu)  
[EBS Storage size not increased after Instance Type upgrade (Linux) | AWS re:Post](https://repost.aws/questions/QU8aWDDzQZTFS5c80vlPsIBA/ebs-storage-size-not-increased-after-instance-type-upgrade-linux)  
[Request Amazon EBS volume modifications - Amazon EBS](https://docs.aws.amazon.com/ebs/latest/userguide/requesting-ebs-volume-modifications.html)

rePost-User-2941322 · Answer

useful links: https://aws.amazon.com/blogs/database/using-amazon-ebs-elastic-volumes-with-oracle-databases-part-3-databases-using-oracle-asm/

Resize Oracle ASM disk groups

Add your answer

Relevant content