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

Excellent! Glad to be of assistance and (a hint to other posters) it's so nice to hear that a proffered reply was of some use.

Happy backing up!

Regards
HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"Alvaro Fuentes" <alvarof2_at_hotmail.com> wrote in message
news:6F4E7.11711$6f.299929_at_typhoon.austin.rr.com...


>

> Thanks Howard,

>

> It works!!! Database fully operational again

>

> Sorry, a 100% newbie here

>

> Your online backup book was of great help.

>

>

> Regards,

>

> A. 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

> > >

> > >

> > >

> > >

> > >

> >

> >

>

>