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 -> Why Backup Temp and Rollback segs?

Why Backup Temp and Rollback segs?

From: Graham Thornton <graham.thornton_at_ln.ssw.abbott.com.nospam>
Date: Mon, 19 Oct 1998 07:58:20 -0500
Message-ID: <362B376C.68E8@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 Mon Oct 19 1998 - 07:58:20 CDT












Original text of this message













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