Re: reset the SCN for the database

From: <TESTAJ3_at_nationwide.com>
Date: Wed, 15 Jul 2009 13:13:41 -0400
Message-ID: <OFF68B3544.1D3FDE0B-ON852575F4.005E8ADD-852575F4.005EA318_at_lnotes-gw.ent.nwie.net>

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_at_gmail.com> To:
hrishys_at_yahoo.co.uk
Cc:
oracle-l_at_freelists.org
Date:
07/15/2009 01:08 PM
Subject:
Re: reset the SCN for the database
Sent by:
oracle-l-bounce_at_freelists.org

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_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

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