RE: reset the SCN for the database
Date: Wed, 15 Jul 2009 13:12:43 -0500
The time space continuum ends. We all become single cell life forms and we start again. It's the universal reset.
Ric Van Dyke
March 7 - 11, 2010
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of TESTAJ3_at_nationwide.com
Sent: Wednesday, July 15, 2009 1:14 PM
Cc: hrishys_at_yahoo.co.uk; oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org
Subject: Re: reset the SCN for the database
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
Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.
K Gopalakrishnan <kaygopal_at_gmail.com>
07/15/2009 01:08 PM
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.
On Wed, Jul 15, 2009 at 4:44 AM, hrishy <hrishys_at_yahoo.co.uk> wrote:
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.