Ok, here is the story.
That temporary tablespace is a Locally Managed Tablespace (LMT), with temporary files.
I found out that temp LMTâÂÂs are not backed up by oracle, and I guess not by veritas. There is no need to back them up, because they contain only temp data.
I do not know why the Oracle Storage Manager does not show the temp files. My guess is that temp files are only used when needed, and they were probably de-allocated at the time we are looking at them. Look during the day and maybe it will show differently.
This query shows that the files are indeed in the system along with there name:
SQLWKS> select tablespace_name,file_name from dba_temp_files;
TABLESPACE_NAME FILE_NAME
------------------------------ -----------------------------------------------------------------
SQL_LMS_TEMPORARY E:\ORACLE\ORADATA\SKY2000\LMSTEMP1.ORA
SQL_LMS_TEMPORARY E:\ORACLE\ORADATA\SKY2000\LMSTEMP2.ORA
2 rows selected.
I knew they had to be there, because that tablespace is used by everyone.
Note that I added LMSTEMP2.ORA while I was testing this out.
Maybe we need to just copy those files to the backup server once, and then weâÂÂll be okâ¦