Re: sync up production to UAT for a 500G+ database
Date: Sun, 16 Mar 2008 11:20:31 -0700
Message-ID: <666b99c70803161120g6a8b3693x9d5cb4e62331e6a1@mail.gmail.com>
Thanks Amir for correcting me . Yes we use veritas vxvm. So I am going to
explore both these option of using standy and veritas vxvm .
thanks
-Prasad
On Sun, Mar 16, 2008 at 11:05 AM, Prasad <p4cldba_at_gmail.com> wrote:
> 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_at_xerox.com>
> 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_at_freelists.org [mailto:
> > oracle-l-bounce_at_freelists.org] *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_at_iinet.net.au>
> > 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_at_iinet.net.au
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > >
> > >
> > >
> >
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Mar 16 2008 - 13:20:31 CDT