Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    1,074

    Unanswered: TEMP tablespace in RMAN backup

    Our backup last night caused most of the space to be consumed in our Flash Recovery Area. In looking at any obvious causes, I noticed that the TEMP tablespace had grown from about 100M to it's 5G limit. Is the TEMP tablespace included in an RMAN backup?

    RMAN> backup database;

    -Chuck
    10g

  2. #2
    Join Date
    Mar 2004
    Location
    Colorado
    Posts
    49
    If the table space is temporary it should not be in the RMAN backup but if it is permanent it would be in the back up. So check to see which type it is if the data file shows in v$datafile it is permanent if it is in v$tempfile then it is temporary.

  3. #3
    Join Date
    Dec 2003
    Posts
    1,074
    I ran

    RMAN> list backupset;

    and noticed that it was not included.

    -cf

Posting Permissions

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