| 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: Methods to Create Smaller Test DB from Production?
Juan - Yes, speed is definitely an advantage. But more importantly, you have
given your customer's data an additional measure of security. Good for you.
I just witnessed a situation where a hosting company didn't test their
backups. And the worst happened. I can assure you that their customers were
pretty upset about the loss of data.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Juan Cachito Reyes
Pacheco
Sent: Monday, March 01, 2004 3:41 PM
To: oracle-l_at_freelists.org
Subject: Re: Methods to Create Smaller Test DB from Production?
Thanks Denis I always recover production database, is the fastest
We have several database about 30 in customers (3 per custoemr average),
other way will take longer.
then only do full backups. ;) Thanks for the advice
we only do full backups
----- Original Message -----
From: "DENNIS WILLIAMS" <DWILLIAMS_at_LIFETOUCH.COM>
To: <oracle-l_at_freelists.org>
Sent: Monday, March 01, 2004 5:38 PM
Subject: RE: Methods to Create Smaller Test DB from Production?
> 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_at_lifetouch.com
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On
> Behalf Of Juan Cachito Reyes Pacheco
> Sent: Monday, March 01, 2004 2:31 PM
> To: oracle-l_at_freelists.org
> 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_at_polaroid.com> T
> To: 'oracle-l_at_freelists.org' <mailto:'oracle-l_at_freelists.org'>
> 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_at_arsenaldigital.com]
> Sent: Monday, March 01, 2004 2:20 PM
> To: 'oracle-l_at_freelists.org'
> 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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Mar 01 2004 - 15:58:45 CST
 |
 |