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: why need to backup undo tablespace?

Re: why need to backup undo tablespace?

From: niy38 <niy38_at_yahoo.com>
Date: Mon, 13 Dec 2004 21:00:42 -0700
Message-ID: <cplohh$4bq$1@hisatsinom.cs.arizona.edu>


suppose we don't use undo tablespace, and the all rollback segments are in system tablespace, if system datafiles are corrupted, how does Oracle do recovery? somehow it needs to find some rollback segments to use.

"Denis Do" <nospam.denisdo_at_yahoo.com> wrote in message news:slrncrg7lj.2ps.nospam.denisdo_at_denisdo.news.google.com...
> On 2004-12-09, niy38_at_hotmail.com <niy38_at_hotmail.com> wrote:
>> as subject.
>>
>
> As you know, in Oracle recovery process there are 2 stages:
> - rolling database forward
> - rolling uncommited transactions back
>
> Second step is impossible without RBS, and they are in UNDO
> tablespace.
Received on Mon Dec 13 2004 - 22:00:42 CST

Original text of this message

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