Re: Clear Rollback Segement

From: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 7 Nov 2000 17:41:34 +1100
Message-ID: <3a07a45e@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 - 00:41:34 CST