Tempfiles clarify recovery needs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Tempfiles clarify recovery needs

  1. #1
    Join Date
    Jun 2002
    Location
    Longmont, Colorado
    Posts
    174

    Tempfiles clarify recovery needs

    Just want to clarify...

    tempfiles are only used by tablespaces used for storing temporary segments. In which case, it is locally managed.

    If I understand correctly, tablespaces likes these (ie temp tablespace) don't requiry media recovery and do not require to be backed-up.

    I've tested and found that if a tempfile was deleted from the OS, the instance will still startup normal. You simply need to do what it is you need to do to fix this.

    I'm interested to clarify this because I have a HOT BACKUP scripts that dynamically creates the scripts that backup the tablespaces. It complains when it gets to the temp tablespace and tries to put it in backup mode.

    So what I propose to do is simply not backup any tablespace that has tempfiles associated with it (dba_temp_files). Would this be anout correct? I'm assuming the only tablespaces that would ever have temp files associated with them are those that store temporary objects.

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    > So what I propose to do is simply not backup any tablespace that has tempfiles associated with it (dba_temp_files). Would this be anout correct?

    Correct.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width