Re: Values in sequence field during failover

>Oracle DBA's:
>
>In a high-availability Unix environment, do the values in an Oracle sequence
>field go crazy when one node fails, and another takes over from it? For
>example, are duplicate sequence values possible after a failure?
>
>Although I am a novice, I have heard that they do, because they are stored in
>memory until they are written to disk. I heard about one designer who
had to
>re-write his application to manually increment the one-up identifiers (keys)
>for his tables instead of using "sequence."
>
>Thank you for your attention.
>
>Tom McCready
>Library of Congress developer
>

I don't know if this exactly answers the question, but it has been my observation that when the database is shutdown, the cached values are 'used up'. For example, you have sequence that starts at 1, with a cache of 20. If you shut down, the next value available will be 21, not 2.

Dan Hekimian-Williams Received on Mon Sep 21 1998 - 21:52:27 CDT