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 15:38:25 -0600
Juan - Make careful notes so in a few years you can look back and remind
yourself how good you had it "back then". But if you develop good habits
like creating test databases by recovering the production database, then you
will be in a better situation when the database grows.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Juan Cachito Reyes Pacheco
Sent: Monday, March 01, 2004 2:31 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Methods to Create Smaller Test DB from Production?
I don't have problems because my database is 2GB ;)
----- Original Message -----
From: Hand, Michael <mailto:HANDM@xxxxxxxxxxxx> T
To: 'oracle-l@xxxxxxxxxxxxx' <mailto:'oracle-l@xxxxxxxxxxxxx'>
Sent: Monday, March 01, 2004 3:48 PM
Subject: RE: Methods to Create Smaller Test DB from Production?
David,
I'll have to agree with Dennis on this one. We bit the bullet a long time
ago and now have enough disk space and platforms to replicate our ~750Gb
production database to 3 test instances. The man-hours to design and
mantain a viable subset for accurate testing was deemed more costly.
Mike Hand
-----Original Message-----
From: David Wagoner [mailto:dwagoner@xxxxxxxxxxxxxxxxxx]
Sent: Monday, March 01, 2004 2: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
--
This transmission is intended only for use by the addressee(s) named herein
and may contain information that is proprietary, confidential and/or legally
privileged. If you are not the intended recipient, you are hereby notified
that any disclosure, copying, distribution, or use of the information
contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If
you received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic or
hard copy format. Thank you.
----------------------------------------------------------------
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:
