We have faced below ASM errors while adding disks and we have 2 node RAC database with NORMAL redundancy at ASM level.
We were trying to add 500 GB ASM disk on ASM instance and at the end of ASM operation we got below error.
DBT-30007 Addition of disks to disk group DATA01 failed.
ORA-15032: not all alterations performed
ORA-15041: diskgroup "DATA01" space exhausted
SOLUTION
-- To implement the solution, please execute the following steps::
1) Review diskgroup configuration, check how many disks within each failure group.
2) Add the remaining disks appropriately so that each failgroup has equally numbered disks.
We can see from ASM alert log below
2023-08-17T05:21:10.203829+02:00
NOTE: Disk _DROPPED_0008_DATA01 in mode 0x0 marked for de-assignment
SUCCESS: refreshed membership for 2/0xe06c1f5c (DATA01)
2023-08-17T05:21:11.997291+02:00
NOTE: Attempting voting file refresh on diskgroup DATA01
NOTE: Refresh completed on diskgroup DATA01. No voting file found.
2023-08-17T05:22:19.072663+02:00
WARNING: Negative disk usage {0, -42698) found for disk 8
WARNING: Negative used space found in at least one disk for grp DATA01 (2/0xe06c1f5c)
V$ASM_DISK View Shows Some Disk Header Status as IGNORED and Group Number as "0". ( Doc ID 1299866.1 )
Run the below command for adding disk
SQL> alter diskgroup DATA add failgroup FG1 disk '/dev/oracleasm/disks/DATA09' force ;
After that we could successfully see that issue was resolved .
=================================================
Adding disk in ASM :-
SQL> alter diskgroup DATA01 rebalance power 10;
SQL> alter diskgroup DATA01 add failgroup FG1 disk '/dev/oracleasm/disks/DATA43' name DATA43 failgroup FG2 disk '/dev/oracleasm/disks/DATA44' name DATA44;
