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

Hi:

Thank you all for responsing my questions.

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.

Am I right, or having something miss?

Thanks

Dong Tang

Frank van Bortel wrote in message <3819E9B5.B22CF3D5_at_vnl.nl>...
>Jeremiah Wilton wrote:
>
>> 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.
>>
Received on Mon Nov 01 1999 - 18:50:13 CST