RE: reset the SCN for the database

From: Ric Van Dyke <ric.van.dyke_at_hotsos.com>
Date: Wed, 15 Jul 2009 13:12:43 -0500
Message-ID: <C970F08BBE1E164AA8063E01502A71CF014E0F5F_at_WIN02.hotsos.com>

The time space continuum ends. We all become single cell life forms and we start again. It's the universal reset.  

---

Ric Van Dyke

Hotsos Enterprises

---

 

Hotsos Symposium

March 7 - 11, 2010

Be there.    

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of TESTAJ3_at_nationwide.com
Sent: Wednesday, July 15, 2009 1:14 PM
To: kaygopal_at_gmail.com
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

---

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 - 13:12:43 CDT