Re: Can I change the current log sequence number ?

Not sure of the question, but once the resetlogs has been issued you must backup the database again (Hot or Cold) and only when this backup is complete will you be able to recover the database again.

Any logs generated before the RESETLOGS being issued can only be recovered against a backup taken BEFORE the RESETLOGS

Hope this helps,
Andrew

yew.poo.choon_at_mbf.com.my wrote:

> 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 - 20:42:27 CDT