Re: Can I change the current log sequence number ?

From: Andrew Babb <andrewb_at_mail.com>
Date: Thu, 29 Apr 1999 17:11:41 +0800
Message-ID: <3728224C.96B77626@mail.com>

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
Received on Thu Apr 29 1999 - 04:11:41 CDT