RE: case of MISSINGnnn datafile

correct....cannot take the tbs offline/drop without opening the db....must restore the old-cold backup..

thanks

> ----------
> From: Winnie_Liu_at_infonet.com[SMTP:Winnie_Liu_at_infonet.com ]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Saturday, September 30, 2000 2:31 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: case of MISSINGnnn datafile
>
>
> If you cannot open the database, there is NO WAY you can take the
> tablespace offline.
>
> As he is running in noarchive mode. There is no way to recover that
> tablespace alone. THe only thing that he can do is to recover it from the
> old cold backup. (if he need that tablespace badly).
>
> If he does not need that tablespace, he can bring all the datafiles
> associating to that tablespace offline drop, open the database and then
> drop the whole tablespace.
>
> Winnie
>
>
>
>
>
> > -----Original Message-----
> > From: Jain, Akshay [SMTP:Akshay.Jain_at_cit.com]
> > Sent: Friday, September 29, 2000 12:20 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: case of MISSINGnnn datafile
> >
> > I am not an expert on this, but how about taking the *tablespace*
> offline.
> > Then the rest of the database should come up ok.
> >
> > To recover the tablespace, you would have to restore the datafiles
> > from a backup, or reimport from a previous export.
> >
> > Just a thought.
> >
> >
> > Akshay Jain
> > _______________________
> > Newcourt-CIT
> > Tel. (416) 507-5385
> > mailto:Akshay.Jain_at_cit.com
> > _______________________
> >
> >
> > -----Original Message-----
> > Sent: Thursday, September 28, 2000 10:01 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > List,
> >
> > when alter database open, it gives
> > file '/sdfsdf/' need media recovery....so i offline the file using
> > alter database datafle .... offline drop;
> >
> > but i cannot still open the db !! it returns the same erorr !!
> > so i re-created the controlfile WITHOUT this file.. but the oracle
> > returned file MISSINGnnnn please rename to correct name etc...error..
> >
> > what to do ?
> >
> > Help
> >
> > 7.3.4, noarchivelog
> >
> >
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rahul
> > INET: rahul_at_ratelindo.co.id
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jain, Akshay
> > INET: Akshay.Jain_at_cit.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cale, Rick T (Richard)
> INET: RICHARD.T.CALE_at_saic.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Winnie_Liu_at_infonet.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Sun Oct 01 2000 - 22:50:02 CDT