Amir, We use veritas SAN. have you any idea on anything similar to BCV on veritas. -Prasad On Sun, Mar 16, 2008 at 10:12 AM, Hameed, Amir <Amir.Hameed@xxxxxxxxx> wrote: > Prasad, > In our case, the entire process, which involves snapping of BCV, cloning > of the database and the application tier on the DB server as well as the > application tier on the middle-tier server (this is a multi-tier, multi-node > environment), less than one hour. Are you running EMC SAN or some other SAN? > > ------------------------------ > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Prasad > *Sent:* Sunday, March 16, 2008 12:33 PM > *To:* ORACLE-L > *Subject:* Re: sync up production to UAT for a 500G+ database > > Hi Mark > > > we have a 6 hour window each night. and yes we want to discard anything > that > took place in testing mode and completely resynch. we have dataguard > license. > so it seems to be easier to implement but as the database is expected to > grow to 1.5 tb over > a year and half so getting 2X times the storage is something that I have > to find out. > > Amir,Nuno > > how long does it take to refresh using using EMC BCV . and any idea on the > licensing cost > for these solution. > > > thanks > -Prasad > > On Sat, Mar 15, 2008 at 6:10 PM, Nuno Souto <dbvision@xxxxxxxxxxxx> wrote: > > > Prasad wrote,on my timestamp of 16/03/2008 3:15 AM: > > > Greetings, > > > > > > I have a 500GB production database running on Oracle 9i on Solaris . > > > and now the Users Testing group wants to keep it in sync with > > production > > > every night . So I am looking for any suggestions from List's > > experience . > > > > > > Please advise. > > > > > > this is precisely where features like Mirrorview > > and other SAN replication techniques can be useful. > > And much cheaper than database extensions. > > > > -- > > Cheers > > Nuno Souto > > dbvision@xxxxxxxxxxxx > > -- > > //www.freelists.org/webpage/oracle-l > > > > > > >