RE: Standbys and Temp Space

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

At 06:30 AM Wednesday, Kevin Lange wrote:
>Thats the answer I needed. Thats what I thought.
>
>Thanks a bunch.
>
>
>----------
>From: A. Coskan Gundogar [mailto:gundogar_at_gmail.com]
>Sent: Monday, March 26, 2007 5:25 PM
>To: Kevin Lange
>Cc: oracle-l_at_freelists.org
>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.
>
>
>

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


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