Cloud Security, Observability and Administration

Hi,

If the asm disk group is full then the following statement will fail.

ALTER TABLESPACE "***_TS_01"
ADD DATAFILE '+DATA/***DATAFILE/***.dbf' SIZE 100M
AUTOEXTEND ON NEXT 512M MAXSIZE 30G;

In such a scenarion, execute the following sql statement to check how much storage is available in the asm diskgroup.

select NAME, TOTAL_MB/1024 "Total in GB",FREE_MB/1024 "FREE in GB" from v$asm_diskgroup;

Then, accordingly appropriate action can be taken.

Regards,