DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Temporary tablespace backup

  1. 02-16-2005, 03:59 PM #1
    svk
    svk is offline Advisor
    Join Date
    Jul 2000
    Posts
    521

    Temporary tablespace backup

    There was a 806 database. The TEMP tablespace was "temporary", "dictionary managed" and had "datafiles".

    The database has been upgraded to 9205. Nothing @ the TEMP tablespace has been changed. So, that tablespace is still "temporary", "dictionary managed" and has "datafiles". It has NOT been changed to "locally managed" and to have "tempfiles".

    We still do conventional HOT backup of this database (alter tablespace begin backup...)

    When the db was 806, we used to backup "datafiles" of this TEMP tablespace and have used those backups many times to clone the database. After the 9i upgrade, it was decided NOT to backup the "datafiles" of this TEMP tablespace.

    The question is : Do I need to back the datafiles of this TEMP tablespace when we do HOT backup ?

    What if I don't backup the "datafiles" of this TEMP tablespace and I need to perform complete/incomplete recovery ?

    Gosh...this is back to basics !!
    svk
    Reply With Quote Reply With Quote
  2. 02-16-2005, 05:07 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I would try to restore/recover without. Most likely, it will fail because you are using a permanent tablespace.

    IMHO, just create a new TEMP_LMT as a temporary tablespace with tempfiles locally managed. Assign everybody to it. Drop the old TEMP ts. Recreate TEMP as temporary with tempfiles. Assign everybody to it. Don't ever worry about temp again.
    Jeff Hunter
    Reply With Quote Reply With Quote
  3. 02-16-2005, 06:03 PM #3
    svk
    svk is offline Advisor
    Join Date
    Jul 2000
    Posts
    521
    Thanks.

    I agree. We actually have done that already. But, there was a lot of techinical "discussion" that wasn't exactly "friendly".

    That why seeking opinion. What is techinically most correct. Irrespective of whether the problems have work-arounds.
    svk
    Reply With Quote Reply With Quote
  4. 02-17-2005, 05:39 AM #4
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    LMT or DMT, backup for TEMP tableapce is not required.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    Reply With Quote Reply With Quote
  5. 02-17-2005, 08:54 AM #5
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by SANJAY_G
    LMT or DMT, backup for TEMP tableapce is not required.
    Temporary tablespace, true. Permanent, not true.
    Jeff Hunter
    Reply With Quote Reply With Quote
  6. 02-17-2005, 09:40 AM #6
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by marist89
    Temporary tablespace, true. Permanent, not true.
    Right! But the poster has clearly mentioned his is TEMPORARY TEMP tablespace.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    Reply With Quote Reply With Quote
  7. 02-17-2005, 11:16 AM #7
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by SANJAY_G
    Right! But the poster has clearly mentioned his is TEMPORARY TEMP tablespace.
    ...but it has datafiles, not tempfiles.
    Jeff Hunter
    Reply With Quote Reply With Quote
  8. 02-19-2005, 03:02 AM #8
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by marist89
    ...but it has datafiles, not tempfiles.
    Why to backup TEMP tablespace of type 'TEMPORARY' even though it has datafiles not tempfiles?
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width