Re: sync up production to UAT for a 500G+ database

  • From: Prasad <p4cldba@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 16 Mar 2008 09:33:27 -0700

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
>
>
>

Other related posts: