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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
