Hello Tom,

A week back we faced a issue on our production database.
We ran out of space in a goldengate tablespace and when I tried to add a datafile It gave below error.

SQL> alter tablespace GG_TBS add datafile '+disk_group/gg_tbs02.dbf' size 2G autoextend on;

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table GGATE.GGS_MARKER by 8192 in tablespace GG_TBS
ORA-06512: at line 1153
ORA-01653: unable to extend table GGATE.GGS_MARKER by 8192 in tablespace GG_TBS

Users where not able to connect to the database and I tried creating datafile in other tablespaces but got the same error. There is 500G space available on disk.
Here the replication was not up and running due to other reasons. So I stopped the ddl trigger and dropped the objects in that tablespace to release some space. and everything started working fine. I need to find the reason why this had happened.

Can you please help me out.
Database - 11.2.0.4
Architecture - 2-node RAC
OS - windows server 2008 R2 SP1

Regards,
Suchitra

select name, state, total_mb, free_mb from v$asm_diskgroup;