ORA-00604 ORA-00376 Unable to Drop a tablespace in GoldenGate (Document ID 1930964.1), goldengate

ORA-00604 ORA-00376 Unable to Drop a tablespace in GoldenGate (Document ID 1930964.1), goldengate

ORA-00604 ORA-00376 Unable to Drop a tablespace in GoldenGate (Document ID 1930964.1)

Source:
ORA-00604 ORA-00376 Unable to Drop a tablespace in GoldenGate (Document ID 1930964.1)

Applicable:
Oracle GoldenGate-Version 11.1.1.0.0 and later
Oracle Database-Enterprise Edition-Version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms:
Below errors while dropping tablespace, datafile offline drop and even creation.

ORA-00604: error occurred at recursive SQL level 1ORA-00376: file 42 cannot be read at this timeORA-01110: data file 42: '+DATA01/tst/datafile/ogg_ts02.dbf'ORA-06512: at line 1169ORA-00376: file 42 cannot be read at this timeORA-01110: data file 42: '+DATA01/tst/datafile/ogg_ts02.dbf'

Cause:
The datafile is deleted from the asm level by mistake. The ddl trigger of ogg tries to read this nonexistent file.

Solution:

I tried both 1149946.1 and 786567.1. No.

Disable the ddl trigger of ogg, drop tablespace, and enable the ddl trigger.

cd /u02/ggssqlplus / as sysdbaSQL> @ddl_disable;SQL> drop tablespace tbs including contents ;SQL> @ddl_enable