Using Backup Exec 9.1 for Windows. Running on Win 2000 server. I have Oracle agent running on another Win 200 server.
When creating Backu job it does not show one of my Tmeporary Oracle files. I have two others that do show up and I can back up. The third one does not appear and therefore is not being backed up. The name of the TEMP space is SKY_LMS_TEMPORARY.
Hi This is in reference to the problem posted by you probably the following details will help us to determine your problem and give you the correct solution: >>Extension of the SKY_LMS_TEMPORARY >>Names of the other two files which you can backup Also, Please Check the rights assigned to Backup Exec logon account. Logon account should have domain admin rights and local admin rights.
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: