RE: Poll & Questions

One more thing:

If you do it on a timely basis (daily, weekly) then people who need data that can be satisfied by
it does not need to use the production database. Also developers like to test against a live like database. This way they are more likely
to catch errors when working against transactions that are very seldom used.

Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il

> -----Original Message-----
> From: Tracy Rahmlow [SMTP:Tracy.Rahmlow_at_aexp.com]
> Sent: Thu, March 14, 2002 5:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Poll & Questions
>
>
> Clarification: My initial question was not really asking how to do it.
> But
> more it was trying to find out what other shops do. In addition, since
> the
> production database is large what benefits/costs can I present to justify
> cloning a fullsized database to an acceptance database?
>
> For example, I think it is far easier to copy the entire database rather
> than
> extract some subset of it for creating a sizable acceptance database.
> Also, I
> think we would obtain more accurate timings for queries in an exact copy
> rather
> than a subset of data. What else?
>
>
>
>
>
> 03/13/2002 10:38 AM PST
>
> Please respond to ORACLE-L_at_fatcity.com
>
> Sent by: root_at_fatcity.com
>
>
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> cc:
>
>
> We do a similar refresh (as mentioned by Kirti) daily using hotbackup and
> archivelogs and it is named DAYOLD.
>
> Raj
> ______________________________________________________
> Rajendra Jamadagni MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect that of ESPN
> Inc.
>
> QOTD: Any clod can have facts, but having an opinion is an art!
>
>
> -----Original Message-----
> Sent: Wednesday, March 13, 2002 12:24 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Kirti,
>
> Why not using "hot" backup + archived log files ? Just wondering, if there
> is any specific reason.
>
> Igor Neyman, OCP DBA
> ineyman_at_perceptron.com
>
> (See attached file: ESPN_Disclaimer.txt)
>
>
> *** eSafe scanned this email for malicious content ***
> *** IMPORTANT: Do not open attachments from unrecognized senders *** <<
> File: ESPN_Disclaimer.txt >>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: adary_at_mehish.co.il

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).