RE: Methods to Create Smaller Test DB from Production?
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 1 Mar 2004 13:33:20 -0600
David
<soapbox>
Sometimes it is a matter of educating management. Management tends to be
like everyone else, in that they don't want to spend money on stuff that
isn't important. Sometimes they won't get the message the first time, so you
must re-emphasize the importance at various times. I feel that I've had some
success at my current site in pushing this message.
Knowing your organization's budget cycle is critical. Maybe they won't
just immediately write out a check, but can be persuaded to put it into the
next budget cycle. Also, it doesn't need to be "high-performance" disk. Some
of the network-attached devices can dramatically lower the cost.
The other point is that if you've emphasized the vulnerability of being
unable to properly test backups, and then something goes wrong, it doesn't
look like you were simply incompetent. But the other side is if you've
clumsily made a pest of yourself, they may be inclined to use a failure to
rid themselves of a pain. Okay, I'm winding down now. Obviously this is a
topic that I feel strongly about.
</soapbox>
You might Google this list for DataBee, because a previous discussion
thread may have mentioned a free tool.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of David Wagoner
Sent: Monday, March 01, 2004 1:20 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Methods to Create Smaller Test DB from Production?
So, Dennis, do you always have enough disk space on your test/dev servers to
hold an entire copy of Production? For sites with VLDB, this is not
possible.
(I agree that testing your backups is critical, and this is one method to do
that- if you have enough disk space in Test.)
Best regards,
David B. Wagoner
Database Administrator
-----Original Message-----
From: DENNIS WILLIAMS [ mailto:DWILLIAMS@xxxxxxxxxxxxx
<mailto:DWILLIAMS@xxxxxxxxxxxxx> ]
Sent: Monday, March 01, 2004 2:12 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Methods to Create Smaller Test DB from Production?
David - I disagree. I feel that your energy is better expended in creating
test databases by recovering your production backup. You do test your
backups, don't you? When we have created subset databases, the testing often
failed to reveal problems, or the users would become frustrated with missing
data. Just my 2 cents worth.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [ mailto:oracle-l-bounce@xxxxxxxxxxxxx
<mailto:oracle-l-bounce@xxxxxxxxxxxxx> ]On
Behalf Of David Wagoner
Sent: Monday, March 01, 2004 1:06 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Methods to Create Smaller Test DB from Production?
Juan,
Unfortunately, that solution requires that you have enough disk space to
hold an entire copy of production, not to mention the archive logs that will
be generated by deleting data.
I'm looking for clever solutions to this problem. I suppose writing your
own referentially-correct ETL from Production to Test is one way. That's
sort of what the DataBee product does, I think. Subsetting a production DB
for test would be an excellent new feature for 10g!
Best regards,
David B. Wagoner
Database Administrator
-----Original Message-----
From: Juan Cachito Reyes Pacheco [ mailto:jreyes@xxxxxxxxxxxxxxxx
<mailto:jreyes@xxxxxxxxxxxxxxxx> ]
Sent: Monday, March 01, 2004 1:44 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Methods to Create Smaller Test DB from Production?
You can copy the production database, the optimal
You can delete records, and make this faster, and export import statistics
to get performance test more accurate to reality.
----- Original Message -----
From: David Wagoner < mailto:dwagoner@xxxxxxxxxxxxxxxxxx
<mailto:dwagoner@xxxxxxxxxxxxxxxxxx> >
To: ORACLE-L < mailto:oracle-l@xxxxxxxxxxxxx
<mailto:oracle-l@xxxxxxxxxxxxx> > (E-mail)
Sent: Monday, March 01, 2004 2:37 PM
Subject: Methods to Create Smaller Test DB from Production?
I know many of you have addressed this same issue...
What is a good method to create a smaller test database from Production?
I've read about the commercial product called DataBee for doing this, but
what other methods are you guys using? With all of the expertise in this
list, there are bound to be some interesting solutions.
Best regards,
David B. Wagoner
Database Administrator
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
<http://www.orafaq.com>
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
<//www.freelists.org/archives/oracle-l/>
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
<//www.freelists.org/help/fom-serve/cache/1.html>
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
