| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Copying Large Amounts of Data From Prod to Dev
Couldn't Enterprise Manager management packs -- Configuration manager?
Do this... in such a way that you could create and account with
authority to refresh on demand and hand that account over to the 'owner'
of the data....
Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Peter Barnett
Sent: Monday, June 18, 2007 4:21 PM
To: Matthew Zito; Oracle-l
Subject: RE: Copying Large Amounts of Data From Prod to Dev
Thanks for the thoughts. We are likely going to be refreshing and rebuilding at least three multi-terabyte databases every month for development. Same for systems and integration testing. Speed is definitely an issue.
We would also like to reduce the number of DBA resources required to do this. That is what originally drove the Symclone question. Can we do this with little, or no, DBA time? There seems to be agreement that it is slow. Guess we need a 'Plan B'.
> And actually, as I think about it, if you're just
> looking to move data
> from one place to another, the symclone stuff might
> be a bit of overkill
> for it - if you just want to move a chunk of data
> from one place to
> another, you could use a timefinder snapshot, which
> would reduce your
> disk usage, or if its done infrequently, you could
> use a standard BCV,
> which provides better performance than the symclone
> piece.
>
> Thanks,
> Matt
>
> --
> Matthew Zito
> Chief Scientist
> GridApp Systems
> P: 646-452-4090
> mzito_at_gridapp.com
>
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org
> > [mailto:oracle-l-bounce_at_freelists.org] 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_at_regence.com
> >
> >
> >
> >
>
Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 19 2007 - 06:58:25 CDT
 |
 |