Re: Hot backup/Tempfile Question

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 19 Dec 2002 18:45:05 +1000
Message-ID: <OyeM9.6228$jM5.17985@newsfeeds.bigpond.com>

Hi Chucky,

Not only can you not perform a hot backup (Oracle won't let you), not only will RMAN ignore them, but Oracle won't even allow you to recover them (Oracle simply "pretends" the files or tablespaces are not there).

Attempting to backup temp files is a pointless exercise.

Regards

Richard

"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?
>
> Thx,
> CC
>
>
>
> -----------== 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 Thu Dec 19 2002 - 02:45:05 CST