Re: Hot backup/Tempfile Question

From: Chucky <chuck.carson_at_syrrx.com>
Date: Wed, 18 Dec 2002 10:04:35 -0800
Message-ID: <3E00B8B3.107@syrrx.com>

However, I could only figure out how to re-create the temp files with the REUSE datafile option. How can I dynamically generate the SQL to rebuild all tempfiles from scratch?

Thx,
CC

Niall Litchfield wrote:
> "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
>
> ******************************************
>
>

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Wed Dec 18 2002 - 12:04:35 CST