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)

来源于：
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 1
ORA-00376: file 42 cannot be read at this time
ORA-01110: data file 42: '+DATA01/tst/datafile/ogg_ts02.dbf'
ORA-06512: at line 1169
ORA-00376: file 42 cannot be read at this time
ORA-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/ggs
sqlplus / as sysdba

SQL> @ddl_disable;

SQL> drop tablespace tbs including contents ;

SQL> @ddl_enable