Re: Hotbackup of Rollback segment and temporary tablespace/datafiles

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Fri, 5 Nov 1999 09:51:25 -0000
Message-ID: <941795642.25572.0.nnrp-14.c2de6f3d@news.demon.co.uk>

Online redo-logs *never* need to be backed up (in archive log mode).

neil.

George Dau wrote in message <38240b85.244094909_at_158.54.6.109>...
>Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:
>
>]jive wrote:
>]>
>]> We are performing hotbackups of our databases, and I am curious as to
>]> whether it is necessary to backup rollback segment and temporary
>]> tablespaces/datafiles?
>]>
>]> Thanks for any views on this.
>]
>]Before 8i, yes to both
>]
>]8i and after, probably yes to both - could probably skip the temporary
>]ones.
>
>What about online redo logs?
>--
> ,-,_|\ George Dau - Unix (Solaris, DEC Unix, Linux), Oracle, Internet.
__
>/ * \ Home: gedau_at_pobox.com ! Any views or opinions expressed
(OO)
>\_,--\_/ Work: gedau_at_isa.mim.com.au ! above may be mine, but are NOT
\/ )
> v WWW: http://pobox.com/~gedau ! necessarily those of M.I.M.
W--W Received on Fri Nov 05 1999 - 03:51:25 CST