Urgent help needed. Datafile dropped from OS. Please help.
Date: Tue, 18 Nov 2008 06:14:39 -0800 (PST)
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 10.2.0.4 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