| 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: 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
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)
Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit
The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.
--0__=09BBE1EFDFC6BD7A8f9e8a93df938690918c09BBE1EFDFC6BD7A--
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow INET: Tracy.Rahmlow_at_aexp.com 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-LReceived on Thu Mar 14 2002 - 09:53:48 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
- application/octet-stream attachment: ESPN_Disclaimer.txt
 |
 |