RE: Standbys and Temp Space

just to back track ... my description of adding a TEMPFILE "locally" at the Standby was in the context of the original question whether the TEMPFILE from the Primary site needs to be copied to the Standby Site (the way Datafiles are copied to create the clone).

At 09:53 PM Wednesday, Joel.Patterson_at_crowley.com wrote:
>Yes, but you can open the physical standby read only... let them do some
>reporting -- hence need temp tablespace. Then restart managed recovery.
>Now tempfiles are there permanently... And in an emergency that step is
>already done making failover more automatic.
>
>Joel Patterson
>Database Administrator
>joel.patterson_at_crowley.com
>x72546
>904 727-2546
>
>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hemant K Chitale
>Sent: Wednesday, March 28, 2007 9:27 AM
>To: klange_at_ppoone.com; A. Coskan Gundogar
>Cc: oracle-l_at_freelists.org
>Subject: RE: Standbys and Temp Space
>
>
>Consider :
> 1. Monday : You do a first clone to the Standby without the
>TEMPFILE
> 2. Tuesday through Thursday: Your Standby in MOUNT state is
>always "rolling forward"
>through ArchiveLogs shipped from the Primary
> 3. Friday morning : Your Primary goes DOWN. No access to the
>Primary Storage at all.
> 4. Friday afternoon: You OPEN the Standby.
> Hmm. .. we don't have the TEMPFILE .
> Let's add the TEMPFILE.
> 5. Friday evening : Users are happy, transactions continue..
>
>When would you have been able to copy the TEMPFILE ?
>A Standby HAS to assume that the TEMPFILE is not available.
>
>Hemant

Hemant K Chitale
http://web.singnet.com.sg/~hkchital
and
http://hemantscribbles.blogspot.com
and
http://hemantoracledba.blogspot.com

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