RE: Methods to Create Smaller Test DB from Production?

  • From: "Hand, Michael T" <HANDM@xxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 1 Mar 2004 14:48:46 -0500

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.


Other related posts: