RE: Standbys and Temp Space

  • From: "Kevin Lange" <klange@xxxxxxxxxx>
  • To: "A. Coskan Gundogar" <gundogar@xxxxxxxxx>
  • Date: Tue, 27 Mar 2007 17:30:58 -0500

Thats the answer I needed.    Thats what I thought.
 
Thanks a bunch.

________________________________

From: A. Coskan Gundogar [mailto:gundogar@xxxxxxxxx] 
Sent: Monday, March 26, 2007 5:25 PM
To: Kevin Lange
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Standbys and Temp Space


I think you mean the first cloning process of standby set up. 

You do not need to copy the temp files. 

And if this is a physical standby you do not need them until you open
the database as primary or read only 

They are only needed when you open the database not in mount stay which
is the default state of the database during log apply.




On 3/27/07, Kevin Lange <klange@xxxxxxxxxx> wrote: 

        Environment:
            Oracle 9.2.0.7 Database with a  TEMP tablespace defined with
TEMPFILES.
         
        Process: 
            Production Database gets cloned to a Standby using a Standby
Control File and copying all datafiles.  In doing the copy, ALL
Datafiles get copied.  Even the TEMP files.
         
        Question:
            When you mount the Standby Database to accept logs, does it
need the TEMPORARY Tablespace Temp Files ?   It does not look like those
are necessary until you OPEN the database.   Right now space is a bit
tight and I could use that space someplace else.  If they are not
necessary in order for the Standby to apply its logs, I will stop the
Clone Process from copying them and just recreate them if/when we have
to bring the Standby up.
         
         
        Thanks
         
        Kevin
         
         




-- 
A. Coskan GUNDOGAR

Oracle DBA 

http://coskan.wordpress.com 

Other related posts: