need temp file for recovery?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: need temp file for recovery?

  1. #1
    Join Date
    Dec 2000
    Posts
    37
    I have a production database needs to do hot backup. There is a temporary tablespace (not permanent) in it.

    My question is:

    1.do I need to include the datafile in that tablespace in my hot backup script? how about cold backup?

    2. do I need the datafiles associated with temporary tablespace in case I need to do recovery?

    Any help will be greatly appreciated!



  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    I'd answer : if you want to be clean in your save strategy, save your TEMP tablespace.
    Nevertheless you know that if there is a crash and you need to recover your instance, you'll always manage to do it without your TEMP tablespace since you know it's empty, you can then disable, drop, and recreate it quite easily and have your instance running ...

  3. #3
    Join Date
    Dec 2000
    Posts
    37
    Thank you, Pipo. Since the recovery doesn't need the temp file, plus the fact I don't see tempfiles comes up when I query dba_data_files dictionary, can I say this --
    when the check point happens the header of tempfile does NOT get the SCN number as other datafiles?

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by daphnny
    plus the fact I don't see tempfiles comes up when I query dba_data_files dictionary
    TEMP files show up in dba_temp_files.

    Personally, I would have to have a STRONG reason why NOT to include a temporary tablespace/file in a backup. As long as you are doing a complete backup, either hot or cold, why not include the TEMP tablespaces? Not backing up these files probably don't save that much tape or time when doing the backups...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Dec 2000
    Posts
    37
    Jeff,

    Thanks. But for hot backup,
    if I do' alter tablespace temp begin backup', or
    'alter tablspace temp end backup' I will get ORA-03217: invalid option for alter tablespace ...



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