Re: Can I change the current log sequence number ?

From: <yew.poo.choon_at_mbf.com.my>
Date: Fri, 30 Apr 1999 08:19:34 GMT
Message-ID: <7gbp2j$7ng$1@nnrp1.dejanews.com>

In article <3728224C.96B77626_at_mail.com>, Andrew Babb <andrewb_at_mail.com> wrote: Can I recover a database from a hot backup with issueing a resetlogs? If yes how ?
TQ

> Hi,
>

> Once you issue a resetlogs, there is no way to apply logs created before the
> resetlogs to the database afterwards.
>
> Oracle resets a number of the internal workings with the resetlogs including
> the System Commit Number. This is the reason that Oracle tells us to backup
the
> database immediately after a resetlogs.
>
> Sorry
> Andrew
>
> yew.poo.choon_at_mbf.com.my wrote:
>
> > As what I understand, When I restore a database with the option of
> > Recover database using backup controlfile ....
> > I need to resetlogs .
> >
> > My questions is can I resetlogs to start with a particular number ?
> >
> > or is there a way for me to continue apply some backup archive redo logfile
> > after I have open my database with the resetlogs ?
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 30 1999 - 03:19:34 CDT