Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reusing name of rollback segment
In our last gripping episode ashish25_at_my-deja.com wrote:
> Hi Steve,
> Read your article on Rollback segments.Why will it cause recovery
> problems??Please explain.
> Thanks and Regards,
> Ashish
>
> In article <3a3f0179.356018477_at_nsw.nnrp.telstra.net>,
> steve.adams_at_ixora.com.au (Steve Adams) wrote:
> > Hi Jonathan,
> >
> > The only other routine time when UNDO$ is updated is when rollback
segments are
> > brought online or taken offline.
> >
> > @ Regards,
> > @ Steve Adams
> > @ http://www.ixora.com.au/
> > @ http://www.christianity.net.au/
> >
> > -----Original Message-----
> > From: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk>
> >
> > Steve,
> >
> > Quite right - I stand guilty of the commonest Oracle
> > error: assuming something that was true in 1986 is
> > still true. Thanks for pointing out the error.
> >
> > By the way, do you happen to know if UNDO$ is
> > updated at anytime other than shutdown ?
> >
> > --
> > Jonathan Lewis
> > Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
> >
> > Practical Oracle 8i: Building Efficient Databases
> >
> > Publishers: Addison-Wesley
> > See a first review at:
> > http://www.ixora.com.au/resources/index.htm#practical_8i
> > More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
> >
> > Steve Adams wrote in message
<3a399726.1119509_at_nsw.nnrp.telstra.net>...
> > >Hi Jonathan,
> > >
> > >No, that explanation does not do it, because the undo segment
number
is
normally
> > >reused for the new rollback segment regardless of its name.
See "Reusing
> > >rollback segment names" at
http://www.ixora.com.au/q+a/0011/10143326.htm
for
> > >more.
> > >
> > >@ Regards,
> > >@ Steve Adams
> > >@ http://www.ixora.com.au/
> > >@ http://www.christianity.net.au/
> >
> >
>
> Sent via Deja.com
> http://www.deja.com/
>
Steve Adams never stated that reusing rollback segment names will cause recovery problems. That was part of the original question which was listed at the bottom of the response. A bit backward, to list the question last, but it is clearly separated from the response and marked with a '?'.
-- David Fitzjarrell Oracle Certified DBA Sent via Deja.com http://www.deja.com/Received on Tue Dec 19 2000 - 09:46:05 CST