Hi Ajay
I havent tested this as in my environment my temp
tablespaces has been littered all over the mount
points.
But in case the temp tablespaces are on a single mount
point then i would certainly consider this given the
fact that the temp tablespaces might run into a few
hundred giga bytes.
I doubt though anybody would have an environment to
test this.
At the risk of being horribly wrong i am
wundering to myself how much network bandwidth can one
really be able to save by not replicating the temp
tablespace as srdf essentially as i understand it
replicates at the storage level byte by byte.And
unless you are a terabyte DW i am not sure how much
bandwidth we can save.
regards
Hrishy
- "Thotangare, Ajay (GTI)" <Ajay_Thotangare_at_ml.com>
wrote:
> Yes, keep Temp tablespace on separate mountpoint and
> don't replicate
> that mountpoint
>
> -----Original Message-----
> From: hrishy [mailto:hrishys_at_yahoo.co.uk]
> Sent: Tuesday, May 22, 2007 9:45 AM
> To: Thotangare, Ajay (GTI); oracle-l_at_freelists.org
> Subject: Re: SRDF Setup - Temp tablespace
> replication
>
>
> Hi
>
> Is it possible to bypass this in SRDF env ?
>
> regards
> Hrishy
> --- "Thotangare, Ajay (GTI)"
> <Ajay_Thotangare_at_ml.com>
> wrote:
>
> > Has anyone used SRDF without replicating TEMP
> > tablespace? If yes, during
> > failover was there any problem?
> >
> > As far as I know there should not be any need of
> > temp tablespace to be
> > replicated as there is no recovery done on temp
> > tablespace.
> >
> > Please confirm if that's true and appreciate your
> > experience in this
> > matter.
> >
>
> >
> > This message w/attachments (message) may be
> > privileged, confidential or proprietary, and if
> you
> > are not an intended recipient, please notify the
> > sender, do not use or share it and delete it.
> Unless
> > specifically indicated, this message is not an
> offer
> > to sell or a solicitation of any investment
> products
> > or other financial product or service, an official
> > confirmation of any transaction, or an official
> > statement of Merrill Lynch. Subject to applicable
> > law, Merrill Lynch may monitor, review and retain
> > e-communications (EC) traveling through its
> > networks/systems. The laws of the country of each
> > sender/recipient may impact the handling of EC,
> and
> > EC may be archived, supervised and produced in
> > countries other than the country in which you are
> > located. This message cannot be guaranteed to be
> > secure or error-free. This message is subject to
> > terms available at the following link:
> > http://www.ml.com/e-communications_terms/. By
> > messaging with Merrill Lynch you consent to the
> > foregoing.
> >
>
> >
>
>
>
>
>
>
> The all-new Yahoo! Mail goes wherever you go - free
> your email address
> from your Internet provider.
> http://uk.docs.yahoo.com/nowyoucan.html
>
>
> This message w/attachments (message) may be
> privileged, confidential or proprietary, and if you
> are not an intended recipient, please notify the
> sender, do not use or share it and delete it. Unless
> specifically indicated, this message is not an offer
> to sell or a solicitation of any investment products
> or other financial product or service, an official
> confirmation of any transaction, or an official
> statement of Merrill Lynch. Subject to applicable
> law, Merrill Lynch may monitor, review and retain
> e-communications (EC) traveling through its
> networks/systems. The laws of the country of each
> sender/recipient may impact the handling of EC, and
> EC may be archived, supervised and produced in
> countries other than the country in which you are
> located. This message cannot be guaranteed to be
> secure or error-free. This message is subject to
> terms available at the following link:
> http://www.ml.com/e-communications_terms/. By
> messaging with Merrill Lynch you consent to the
> foregoing.
>
>
Yahoo! Mail is the world's favourite email. Don't settle for less, sign up for
your free account today
http://uk.rd.yahoo.com/evt=44106/*http://uk.docs.yahoo.com/mail/winter07.html
--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 22 2007 - 09:00:05 CDT
