Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why Backup Temp and Rollback segs?
A couple of points to add to all the useful and generally correct replies
you got:
And in Oracle8 with RMAN, you *don't* backup TEMP tablespaces, and you don't use the 'hot' backup commands (BEGIN BACKUP and END BACKUP).
MotoX.
Graham Thornton wrote in message <362B376C.68E8_at_ln.ssw.abbott.com.nospam>...
>Hello,
>
>Reading through the Oracle DBA handbook, I noticed that the section on
>on-line backups includes examples of backing up the TEMPORARY and
>ROLLBACK datafiles.
>
>Why would you want to do this? - If you need to recover from a crash you
>can only recover committed transactions so why would you need the
>TEMPORARY and ROLLBACK datafiles? - Wouldn't it be easier to just
>recreate them?
>
>Maybe I'm missing something here.
>
>Thanks
>
>Graham.
Received on Tue Oct 20 1998 - 02:30:17 CDT