Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reusing name of rollback segment
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/
Received on Tue Dec 19 2000 - 08:21:58 CST