Re: reset the SCN for the database

From: <>
Date: Wed, 15 Jul 2009 13:13:41 -0400
Message-ID: <>

A discussion many years ago asked "what happens if you run out of SCNs?" Curious minds still want to know or has this already been answered.


Joe Testa, Oracle Certified Professional
(Work) 614-677-1668
(Cell) 614-312-6715

Interested in helping out your marriage? Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.

K Gopalakrishnan <> To:
07/15/2009 01:08 PM
Re: reset the SCN for the database
Sent by:


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.  


On Wed, Jul 15, 2009 at 4:44 AM, hrishy <> 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.    


Received on Wed Jul 15 2009 - 12:13:41 CDT

Original text of this message