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 [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
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
[EMAIL PROTECTED]
(See attached file: ESPN_Disclaimer.txt)
ESPN_Disclaimer.txt
Description: Binary data
