Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Clear Rollback Segement

Re: Clear Rollback Segement

From: Syltrem <syltrem_at_videotron.ca>
Date: Tue, 7 Nov 2000 11:08:14 -0500
Message-ID: <VFVN5.7571$m31.201215@wagner.videotron.net>

Were we talking about rollback segments? If my phone would stop ringing I could concentrate on what I'm doing...

Sorry for this, and I agree that all that can be done is what you say (drop & recreate).

Syltrem

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3a07a45e_at_news.iprimus.com.au...
>
> "Syltrem" <syltrem_at_videotron.ca> wrote in message
> news:CkzN5.4614$m31.110759_at_wagner.videotron.net...
> > ALTER DATABASE CLEAR [UNARCHIVED] LOGFILE GROUP N [UNRECOVERABLE
 DATAFILE]
> >
> > Will even re-create the redo file if non existant.
> >
> > Syltrem
> >
>
>
>
> Perfectly true, but rather irrelevant for the purposes of sorting out
> corrupted rollback segments (for which the only cure I can think of is to
> take them offline, drop them, and re-create them). Rollback is not the
 same
> thing as redo!
>
> Regards
> HJR
>
>
> > "Rayfil Cheung" <rayfilcheung_at_hket.com> wrote in message
> > news:3A0398BF.24D825BC_at_hket.com...
> > > How to clear a Rollback Segment or recover a corrupted Rollback
> > > Segment. Thank you.
> > >
> >
> >
>
>
Received on Tue Nov 07 2000 - 10:08:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US