Re: HELP HELP:Solaris:tablespace strip lost, can't open database

Thanks Howard,

It works!!! Database fully operational again

Sorry, a 100% newbie here

Your online backup book was of great help.

Regards,

1. Fuentes afuentes_at_goodpremises.com (512)297-9937

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3bdfc8da$0$9820$afc38c87_at_news.optusnet.com.au...
> I'm sure this was only asked two days ago. Did you check google.com?
>
> Anyway: in the mount state, you can do an 'alter database datafile 5 [or
> whatever is the appropriate number] offline; Then the database should
open
> without hassle (alter database open). Then you can drop tablespace TEMP;
> and create a brand new one (there are other options at this point, but
> that's probably the easiest).
>
> Don't take this the wrong way, either: but this is fairely basic backup
and
> recovery technique, so you might want to check out the subject more fully
> ...see the "books" link at my site (link below). There's a Backup and
> Recovery guide there.
>
> Regards
> HJR
> --
>
> Oracle Resources : http://www.geocities.com/howardjr2000
> ========================================
>
>
> "Alvaro Fuentes" <alvarof2_at_hotmail.com> wrote in message
> news:ZNMD7.8893$Wv.173657_at_typhoon.austin.rr.com...
> >
> >
> > Fellow Oracler's:
> >
> > I am running Oracle Enterprise Server 8.1.7 in a Solaris8 environment.
> >
> > One of my hardrives in my SCSI array died and it contained
> > one of the datafiles (raw device /dev/rdsk/c1t2d0s6) of my
> > tablespace "temp".
> >
> > The issue is: Is there a way to remove/delete this datafile of the
> > tablespace WITHOUT opening the database?
> > (remember the database can only be mounted at this point).
> >
> >
> > I looked for the opposite of :
> >
> > SQL> alter tablespace temp add datafile '/dev/rdsk/c1t2d0s6' ....
> >
> > but there is not "remove or delete" in this syntax.
> >
> > Is there another way to remove the lost strip?
> >
> > Any clue about this problem will be greatly appreciated
> >
> > A. Fuentes
> > afuentes_at_goodpremises.com
> > (512)297-9937
> >
> >
> >
> >
> >
>
>
Received on Wed Oct 31 2001 - 22:59:46 CST