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

From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Sun, 16 Mar 2008 13:12:16 -0400
Message-ID: <304F58144267C5439E733532ABC9A3A105E79860@USA0300MS02.na.xerox.net>

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

Received on Sun Mar 16 2008 - 12:12:16 CDT