TEMP tablespace in RMAN backup

chuck_forbes · #1 (**permalink**) 09-30-04, 15:49

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

borzoi313 · #2 (**permalink**) 09-30-04, 18:18

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.

chuck_forbes · #3 (**permalink**) 10-01-04, 14:02

I ran

RMAN> list backupset;

and noticed that it was not included.

-cf