Re: NOARCHIVELOG and rollback segments

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 6 Nov 2003 10:57:08 +1100
Message-ID: <3fa98e58$0$3788$afc38c87@news.optusnet.com.au>

"Jack Wang" <nospam_at_nospam.com> wrote in message news:01gqb.136482$EO3.28509_at_clgrps13...
> Howard, does UNDO tablespace need to backup?

Absolutely. Rollback segments are needed to perform a transaction in the first place, therefore they are needed to re-do a transaction during recovery. So yes, back 'em up. TEMP is the only tablespace you shouldn't back up (in fact, a proper tempfile temporary tablespace can't be backed up).

To no-one in particular, when questions arise as to what *you* should backup and what to leave alone, always have a look at what *RMAN* backs up and what it chooses to ignore. You'll find, for example, that RMAN never backs up online redo logs (there's a hint in there somewhere) and it never backs up TEMP, either (another hint). But (specifically answering your question) it always backs up UNDO.

Regards
HJR Received on Wed Nov 05 2003 - 17:57:08 CST