Re: reset the SCN for the database
- From: TESTAJ3@xxxxxxxxxxxxxx
- To: kaygopal@xxxxxxxxx
- Date: Wed, 15 Jul 2009 13:13:41 -0400
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
_______________________________________
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.
From:
K Gopalakrishnan <kaygopal@xxxxxxxxx>
To:
hrishys@xxxxxxxxxxx
Cc:
oracle-l@xxxxxxxxxxxxx
Date:
07/15/2009 01:08 PM
Subject:
Re: reset the SCN for the database
Sent by:
oracle-l-bounce@xxxxxxxxxxxxx
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:
