Re: reset the SCN for the database

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_at_yahoo.co.uk> 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
>
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l