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

Pete Sharman wrote:
>
> Theoretically no, but rebuilding the rollback segment tablespace might be too
> much of a pain for the gain you get anyway.

The poster stated that a hot backup is the the backup method. It seems to me there is no way to have a valid backup of the database withouut rollback segments. If a recovery were to be attempted without all the rollback segments available, there would be no way to get the database open at the end of recovery. Open transactions at the point in time to which incomplete recovery has been performed would be unavailable for application to the uncomitted data blocks in the datafiles. The "emergency" underscore parameters that technically allow a database to be forced open in these circumstances leave uncommitted data in the data blocks, which is a semantically and technically undesirable situation.

As for temporary tablespaces, if they are really of type TEMPORARY, then they contain no permanent segments and therefore can be easily re-created after a recovery, so they are not essential elements of a backup.

--
Jeremiah

> Dong Tang wrote:
> >
> > I have a 250Gb database which is required to be up 24 by 7. So I have to do
> > online backup. And this database is extremely volatile. So it have a very
> > big temporary tablespace and a very big rollback segment tablespace ( I have
> > a tablepspace contains and only contains all rollback segments except
> > system rollback segment). It also generates about 5 to 10 Gb archived redo
> > logs per day, which I have to backup to tape. As our backup device is very
> > slow, I want to backup as less as possible.
> >
> > Here is my question: do I have to backup the temporary table and rollback
> > segment tablespace?
> >
> > Since I back up each tablespace at different time, it seems to me, what is
> > the rollback segment is useless when we do recover, and same reason to
> > temporary tablespace?
Received on Thu Oct 28 1999 - 22:04:27 CDT