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_at_ppoone.com> 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

--
http://www.freelists.org/webpage/oracle-l