Re: reset the SCN for the database

Going by the standard answer, it will take around 500 yeras for you to run out of SCN with 16K commits/sec. So there is no way you will run of SCNs in (y)our life. Also the SCN structure has an internal limitation of increment values. It can not be incremented to arbirarily high values. So you can not use the ADJUST_SCN or _minimum_giga_scn to reach the limit :)

So technically speaking the first error you may get with currnet versions of will be ORA-1513, but you will get umpteenl ORA-1558s as all the rollback segments would have dead by that time.

Best Regards,
K Gopalakrishnan

Oracle Database 10g Real Application Clusters Handbook http://www.amazon.com/gp/product/007146509X/

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

On Wed, Jul 15, 2009 at 12:13 PM, <TESTAJ3_at_nationwide.com> wrote:

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