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