Re: Hot backup and TEMP tablespace

> TEMPFILEs and TEMPORARY tablespace

Saving time during backup is nice. But when your database goes down, all of a sudden the time it takes to get it back up becomes real important. Everybody is calling you to ask, "How long until the database is back up?"

Using true temporary tablespaces and tempfiles means you can skip backing up the temp tablespace, and when you need to recover it you can recreate the temp tablespace fast. Otherwise, recreating it can take a long time, meaning the time to recover a crashed database may take longer.

Check Jonathan Lewis's book (Practical Oracle 8i) -- he covers this well in his chapter on temp tablespaces. You'll may also want a simple script available to create the temp tablespace, so you won't have to write it during a recovery, and you'll probably want to practice on a test database. It would be nice to document this too in a DBA notebook -- if you leave, a new DBA who has to recover the database may be puzzled to find the backup is "incomplete," they may not know how to create a temp tablespace quickly, etc.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Greg Moore
  INET: sqlgreg_at_pacbell.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).