Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!newshosting.com!nx01.iad01.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.wirehub.nl!news.tele.dk!news.tele.dk!small.news.tele.dk!news-fra1.dfn.de!newsfeed.pionier.net.pl!news.nask.pl!news.cyf-kr.edu.pl!agh.edu.pl!news.agh.edu.pl!news.onet.pl!not-for-mail From: "Mathnoid" Newsgroups: comp.databases.oracle.server Subject: Re: index datafile recovery help Date: Sun, 8 Aug 2004 20:28:24 +0200 Organization: news.onet.pl Lines: 34 Sender: mathnoid@poczta.onet.pl@beb185.neoplus.adsl.tpnet.pl Message-ID: References: <3_-dnaKEIM7bHIjcRVn-pA@comcast.com> NNTP-Posting-Host: beb185.neoplus.adsl.tpnet.pl X-Trace: news.onet.pl 1091989930 7601 83.28.13.185 (8 Aug 2004 18:32:10 GMT) X-Complaints-To: abuse@onet.pl NNTP-Posting-Date: 8 Aug 2004 18:32:10 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Xref: core-easynews comp.databases.oracle.server:227813 X-Received-Date: Sun, 08 Aug 2004 11:31:19 MST (news.easynews.com) look at http://republika.pl/mathnoid/index_EN.html Mathnoid.04 "Ste" wrote in message news:3_-dnaKEIM7bHIjcRVn-pA@comcast.com... > Hi, > > I have a disk failure and an index datafile associated with index tablespace > is lost. There is no backup of this datafile. > > I manage to have database started by removing entry of this datafile from > controlfile. But since there is no replacement of it, there is no way to > recover it. I get a missing file error on v$recovery_file after database > is open and the file is indicated on other directory ../dns/missing00006. > It can not be offline dropped. > > Though I can drop data tablespace along with index tablespace, or drop some > schema along with constraints, and imp back data and index after disk is > replaced, I wonder if there is another better way to get the index > tablespace drop without big action. > > Please comment. > > Thanks a lot, > > Ste > >