Re: Resetting Archive Log Sequence Numbers

Susan is right about the cold backup part, but doing an alter database open resetlogs is a safer alternative than recreating your control files.

Susan Wilson wrote:

> Make sure you don't need any of the old logs to recover, because the
> CREATE CONTROLFILE ... RESET LOGS will make them unusable. In other
> words, get a good solid cold backup immediately after the reset logs.
> - sooz
>
> CG_at_His.PC wrote:
> >
> > does anyone know how to reset the offline archive log sequence
> > numbers? I have set up a new machine, and for some reason it started
> > the offline archive logs sequence at 66 or something like that. Then,
> > after I did some testing, I'm in the 70's. When I turn this over to
> > the users, I'd like to start at the beginning.
> >
> > Just a petty little quirk...............
> >
> > Thanks
> > ++++++++++++++++++++++++++++++++++++++++++++++
> > mp3 files posted for evaluation purposes only.
> > If you like it, support the artist and buy it!
>
> --
> Thanks.
> - Susan
>
> Engineering System Administration
> Motorola Computer Group
> 602-438-3765
> mailto:susan_wilson_at_phx.mcd.mot.com
> http://www.eng.mcd.mot.com/
Received on Wed Sep 30 1998 - 12:46:42 CDT