Re: Clear Rollback Segement
Date: Tue, 7 Nov 2000 17:41:34 +1100
Message-ID: <3a07a45e_at_news.iprimus.com.au>
[Quoted] "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 - 07:41:34 CET