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@xxxxxx> wrote: > Yes, keep Temp tablespace on separate mountpoint and > don't replicate > that mountpoint > > -----Original Message----- > From: hrishy [mailto:hrishys@xxxxxxxxxxx] > Sent: Tuesday, May 22, 2007 9:45 AM > To: Thotangare, Ajay (GTI); oracle-l@xxxxxxxxxxxxx > Subject: Re: SRDF Setup - Temp tablespace > replication > > > Hi > > Is it possible to bypass this in SRDF env ? > > regards > Hrishy > --- "Thotangare, Ajay (GTI)" > <Ajay_Thotangare@xxxxxx> > 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 -- //www.freelists.org/webpage/oracle-l