Re: Do I need backup rollback segement tablespace and temporary table ?

Important point on temporary tablespaces: Pre-8.1, if you don't back them up, you have to drop them as part of the recovery (which adds to the hassle) and recreate them - which for a 40Gb temporary tablespace can add a surprising amount of time to your recovery time

8.1 on, you can have TEMPORARY TABLESPACES (as in 'create temporary tablespace') whose files are not supposed to be backed up - which don't need to be dropped, and whose files will recreate in just a few seconds.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Pete Sharman wrote in message <3819BD47.3F08BC4_at_us.oracle.com>...
>Jeremiah
>
>The situation you're describing is what I meant by "rebuilding the rollback
segment
>tablespace might be too much of a pain for the gain you get anyway." It's
similar to
>losing a datafile with online rollback segments. Can you recover from
this? Yes.
>Is it easy? No. That's why I left it at a relatively bland statement
rather than
>putting in all the details, because it really does need some solid
expertise to do
>this.
>
>I agree with your comment on temporary tablespaces, though again it may be
simpler
>to just backup everything rather than to have an extra step to remember
(determining
>what everyone's temporary tablespace is defined as and then creating those
>tablespaces from scratch). Remember that when most people are doing a
recovery,
>it's a panic situation and those extra steps are easily left out.
>
>Pete
>
Received on Sat Oct 30 1999 - 08:57:47 CDT