RE:Hot backup and TEMP tablespace

ALWAYS BACKUP THE ROLLBACK TABLESPACE!!!!! or you will not be able to recover. How else will Oracle rollback a transaction in the works when the database went down.

I do not back up TEMP or my INDEX tables spaces. I have scripts that recreate all of these. (150GB of indices, not worth the tape.) And while I use RMAN for backups I do all my recoveries from the our scripted hot backups. I also practise recoveries every 6 months.

RMAN backups fine, it's recoveries it has trouble with :) Why?

There is limited flexibility with RMAN along with an added dependency. As most know I loathe unecessary dependencies.

An Example:

        power surge blows out Machine and hub/router power supply.

        Machine automagicaly fails over to alternate power, however, the hub/router needs servicing. Your RMAN catalog is on the other side of the hub/router. What are you going to do now?

And yes, as I keep saying, I am paranoid.

Dave

Tom wrote:
> steps just to save yourself some time during backups? Why stop at backing
> up the TEMP tablespace - why not the ROLLBACK tablespace - this could be
> dropped and re-created also. Why not INDEX tablespaces - heck, if you have
> the scripts, these could be re-created too!

-- 
Dave Morgan
DBA, Cybersurf
Office: 403 777 2000 ext 284
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dave Morgan
  INET: dave.morgan_at_cybersurf.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).