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>
Linux-x86_64 Error: 2: No such file or directory
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 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