RE: Copying Large Amounts of Data From Prod to Dev

  • From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
  • To: <mzito@xxxxxxxxxxx>, <regdba@xxxxxxxxx>, "Oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 15 Jun 2007 17:02:39 -0400

We evaluated Symclone a few years ago and found it was painfully slow
and therefore we decided not to use it for the creation of our nightly
DSS copy from production. It may have improved now but we have not
tested it recently.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Matthew Zito
Sent: Friday, June 15, 2007 2:57 PM
To: regdba@xxxxxxxxx; Oracle-l
Subject: RE: Copying Large Amounts of Data From Prod to Dev


It should work alright - the only downside being that you have to
allocate identically sized volumes to your production.  Obviously, make
sure you correctly map your timefinder groups to the underlying volumes
(which if it's a veritas or LVM environment can be a little tricky, as
sometimes your filesystem volumes have random blocks from disk devices
you didn't realize were in use).

Thanks,
Matt

--
Matthew Zito
Chief Scientist
GridApp Systems
P: 646-452-4090
mzito@xxxxxxxxxxx


> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Peter Barnett
> Sent: Friday, June 15, 2007 1:46 PM
> To: Oracle-l
> Subject: Copying Large Amounts of Data From Prod to Dev
> 
> We are considering using EMC Symclone to copy data from production to 
> development databases.  Does anyone have any experience with this 
> product used in this way?  Any 'gotchas'
> or words of wisdom?
> 
> Pete Barnett
> Lead Database Administrator
> The Regence Group
> pnbarne@xxxxxxxxxxx
> 
--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


Other related posts: