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

During a recovery, if you do not restore and recover a copy of all tablespaces containing active rollback segments, then there will be no way to roll back uncommitted changes in the datafiles when the recovered database is opened.

How would you propose to roll back all the uncommitted data in the datafiles without rollback segments? Without the undo headers, you can't even tell what's committed and what's not.

--
Jeremiah

Dong Tang wrote:
>
> Let me make myself a little bit clear. I don't want to backup rollback
> segment tablespace and temperary tablesace because I think the data in those
> tablespace is useless during the recovery. Unless I recover the database
> right after I backup those tablespaces. If I don't backup them, even I loss
> all datafiles in those tablespaces, I can create those datafile according to
> information in Control file. And I think it would be much quicker than
> restore datafiles from tape.
>
> I read the manual, I am kinda agree that Frank said. What in the rollback
> segment is recovered from redo log. Otherwise, I have to backup rollback
> segment constantly, as the data in rollback segment is keeping changing.
Received on Mon Nov 01 1999 - 23:34:13 CST