Re: Urgent help needed. Datafile dropped from OS. Please help.

From: Mladen Gogala <>
Date: Tue, 18 Nov 2008 15:29:41 +0100
Message-ID: <gfujgm$pal$>

dbagtcol wrote:

> Hi all
> Somebody just dropped an Oracle datafile from OS commands in our
> development RAC. The tablespace isn't that important but i am afraid
> RAC may be down. Please suggest how can I get rid of this tablespace.
> I am on RAC environment with two nodes, in noarchivelog mode.
> When I to drop the tablespace, it gives me this error:
> ORA-01116: error in opening database file 24
> ORA-01110: data file 24: '/oracle/undo01/S0031001_X.dbf'
> ORA-27041: unable to open file
> Linux-x86_64 Error: 2: No such file or directory

Oh boy! That's the undo tablespace! You say that "tablespace isn't that important"? You have never done DB recovery, have you? Here are some products that may come handy in the future:

This time you are, as Lewis Black would put it, red, white and messed up.

Received on Tue Nov 18 2008 - 08:29:41 CST

Original text of this message