Re: Urgent help needed. Datafile dropped from OS. Please help.
Date: Tue, 18 Nov 2008 15:29:41 +0100
Message-ID: <gfujgm$pal$1@news.motzarella.org>
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 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
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:
http://www.symantec.com/business/netbackup http://www.emc.com/products/detail/software/networker.htm http://www-01.ibm.com/software/tivoli/products/storage-mgr/ http://tinyurl.com/5caksw http://www.tandbergdata.com/us/en/products/search-result/?action=2&ref=169
This time you are, as Lewis Black would put it, red, white and messed up.
-- http://mgogala.freehostia.comReceived on Tue Nov 18 2008 - 08:29:41 CST