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: