Re: 10rR2 automatically re-creates missing TEMP files

From: joel garry <joel-garry_at_home.com>
Date: Thu, 21 Jan 2010 13:45:47 -0800 (PST)
Message-ID: <9581bd3c-6dc9-4073-9eb3-af1aa6bae028_at_k17g2000yqh.googlegroups.com>

On Jan 21, 12:48 pm, vsevolod afanassiev <vsevolod.afanass..._at_gmail.com> wrote:
> I've done following test:
> - Brought database down using 'shutdown abort'
> - Renamed temp files to .bak
> - Started database using 'startup'
> Basically I wanted to know whether Oracle will complain about missing
> temp files or it will ignore them
> and then I'll be able to add them manually.
>
> Instead Oracle re-created the files:
>
> Thu Jan 21 16:26:57 2010
> SMON: enabling tx recovery
> Thu Jan 21 16:26:57 2010
> Re-creating tempfile /eip/db04/oracle/EIP4T/oradata/EIP4T_temp_02.dbf
> Re-creating tempfile /eip/db05/oracle/EIP4T/oradata/EIP4T_temp_01.dbf
> Database Characterset is AL32UTF8
> Opening with internal Resource Manager plan
> where NUMA PG = 1, CPUs = 8
> replication_dependency_tracking turned off (no async multimaster
> replication found)
> Starting background process QMNC
>
> This is 10.2.0.4 on AIX

Also see bugs 1641989 and 5861994

In retrospect, this makes perfect sense, as tempfiles don't have anything needed for recovery.

(Don't feel bad about not noticing this long ago, I'm sure I've seen posts and ran across this on this along the way but had totally forgotten about it until your post - RMAN makes things too easy :-)

jg

--
_at_home.com is bogus.
Tom Snyder and the Clash http://www.youtube.com/watch?v=JVygiX0KEEw

Received on Thu Jan 21 2010 - 15:45:47 CST