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

From: dbagtcol <cx4gtcol_at_gmail.com>
Date: Tue, 18 Nov 2008 06:14:39 -0800 (PST)
Message-ID: <044b0c9a-6708-4782-9428-95e943d7ed90@s1g2000prg.googlegroups.com>

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

Please help. please help.

gtcol Received on Tue Nov 18 2008 - 08:14:39 CST

Original text of this message