Re: reset the SCN for the database
- From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
- To: hrishys@xxxxxxxxxxx
- Date: Wed, 15 Jul 2009 12:05:20 -0500
Hrishy,
Resetlogs does not reset the SCN. It just resets the LSN (Log Sequence
Number), thats why it is RESET-LOGS. You can advance SCN by ADJUST_SCN event
(which goes only forward btw). You may consider FLASHBACKS to go back to
the past.
-Gopal
On Wed, Jul 15, 2009 at 4:44 AM, hrishy <hrishys@xxxxxxxxxxx> wrote:
> Hi
>
> One of my environment makes use of streams and if i do a incomplete
> recovery using resetlogs the SCN would be reset.How do change the SCN to
> make it go back to what it was earlier.
>
>
> regards
> Hrishy
>
>
>
>
>
>
Other related posts:
