"Chucky" <chuck.carson_at_syrrx.com> wrote in message
news:3E0097FB.6000607_at_syrrx.com...
>
> Our DBA's have created several temporary files that are not listed in
> dba_data_files, but instead dba_temp_files.
>
> My question is, when backing these up during a hotbackup, does it matter
> is they are being written to or not. I currently generate the SQL to
> recreate them using the same datafiles (with the REUSE clause). It it
> safe to copy these files during the hotbackup even though they may be in
> use?
>
> Also, it listed the status of each of these temporary files as
> AVAILABLE, does this mean they are not being used, or they are? ie: what
> are the different values the STATUS can be?
Don't back them up, just preserve the sql. Creating a temporary tablespace
with tempfiles will add approximately 10 nanoseconds to recovery time, and
there is no information in them to backup.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Wed Dec 18 2002 - 09:49:28 CST
