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: Resetting Archive Log Sequence Numbers

Re: Resetting Archive Log Sequence Numbers

From: Susan Wilson <susanw_at_phx.mcd.mot.com>
Date: Wed, 30 Sep 1998 10:32:32 -0700
Message-ID: <36126B30.1CE3E340@phx.mcd.mot.com>


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.

    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:32:32 CDT

Original text of this message

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