| 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: CBO irregularity
Dennis,
the strategy is really good.
except as jared mentioned and one of the issues we all have is the Sarbaines-oxley which is coming to effect and has the fact that staging cannot be a copy of production.
Unless you have a way to change the data to the effect that it doesnt look like production
Also i'm glad you get enough space to not only duplicate production as staging but also get to test a production strategy. How fortunate of you.
DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
Rachel
Please forgive my question, but I'm still fairly new to this 3-ring
circus. My objective is to refresh the staging environment by recovering the
production backup. This will accomplish two objectives:
1) Create an exact duplicate of production.
2) Test the production backup, a vital task which never seems to get done
otherwise.
I have always been opposed to the idea of staging being a subset of the
production data. While it sounds good in theory, I feel there are too many
problems with this approach. And you can't test your backup.
If you see any flaws in my logic, please let me know. Naturally, in the
hurly-burly of the daily life of a DBA, the ideal is not always met. If is
tempting to feel the staging database isn't yet stale so doesn't need
refreshed immediately, even though the commitment is to refresh it before a
large implementation. The development environment of course is a whole
different issue, usually treated as a developer playground.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Rachel Carmichael
Sent: Tuesday, June 08, 2004 9:44 AM
To: oracle-l_at_freelists.org
Subject: RE: CBO irregularity
there is dev, QA and production and then there is dev, QA and production
I have all 3 environments, supposedly. QA does not accurately mimic production and in fact, we almost had to roll back a major production release because real load showed problems not found in the QA load test.
Dev is even worse... but TECHNICALLY we have all 3 environments
-- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 Tue Jun 08 2004 - 10:20:43 CDT
 |
 |