RE: reset the SCN for the database

I believe to reset the scn one needs to change the incarnation of the
database.  Which I believe is done through RMAN.
 

Dick Goulet 
Senior Oracle DBA 
PAREXEL International 

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
TESTAJ3@xxxxxxxxxxxxxx
Sent: Wednesday, July 15, 2009 1:14 PM
To: kaygopal@xxxxxxxxx
Cc: hrishys@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx;
oracle-l-bounce@xxxxxxxxxxxxx
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 

_______________________________________
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
<mailto: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: