Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Hotbackup of Rollback segment and temporary tablespace/datafiles

Re: Hotbackup of Rollback segment and temporary tablespace/datafiles

From: Wayne Taylor <wtaylor1_at_visteon.com>
Date: Fri, 5 Nov 1999 09:37:09 -0500
Message-ID: <7vuq7s$mnm3@eccws12.dearborn.ford.com>


Only assuming that you perform a log switch to force archiver to copy the online redo logs. This should be done as part of your hot backup script with :-

ALTER SYSTEM SWITCH LOGFILE Neil Cudd wrote in message
<941795642.25572.0.nnrp-14.c2de6f3d_at_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 - 08:37:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US