ORA-00604 ORA-00376 Unable to Drop a tablespace in GoldenGate (文檔 ID 1930964.1)，goldengate

ORA-00604 ORA-00376 Unable to Drop a tablespace in GoldenGate (文檔 ID 1930964.1)，goldengate

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

來源於：
ORA-00604 ORA-00376 Unable to Drop a tablespace in GoldenGate (文檔 ID 1930964.1)

適用於：
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.

癥狀：
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'

原因：
該datafile 被錯誤的從asm層級刪除掉了。ogg的ddl觸發器嘗試讀這個不存在的檔案。

解決方案：

1149946.1 and 786567.1都試過了，不行。

禁用掉ogg的ddl觸發器，再drop tablespace，再啟用ddl觸發器即可。

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