Noons wrote:
> DA Morgan wrote:
>
>>As a DBA do you ask management to sanction using LMT rather than DMT?
>
> Do
>
>>you ask management if it is Ok to use UNDO rather than RBS? I don't
>
> like
>
>>your argument because as a DBA you are supposed to be a subject
>
> matter
>
>>expert. If you have tested RMAN and know how to implement it then you
>>implement it just as you would any other similar question within your
>>realm of expertise.
>
>
> Very contingent on the type of site, Daniel.
> I am currently working at one that has the dubious "advantage"
> of being on DMT + RBO with 9ir2!!!!
> The previous dba - for whatever reasons that don't matter here -
> decided
> to leave the schema and the data at V7 while upgrading the db
> software to 9ir2. WTF for begs explaining, but let's ignore it...
>
> With the result that I now have a headache of dinossauric proportions!
> And an app that "only works with RBO", or so the development
> manager has been led to believe.
>
> So, my mission (should I accept it) is to:
> 1) convince the DM that contrary to what the previous dba told him,
> CBO in 9ir2 is darn good.
> 2) convince the DM to do testing of the app with 9ir2 + LMT + CBO.
> 3) convince the CTO that all this is worth doing when all
> he hears is that "MySql is free therefore must be good".
> 4) find a slot somewhere in a 24X7X365 system to do the necessary
> manipulations to get rid of the old stuff and put in the new
> with minimal disruption.
> 5) write a plan to implement 4) above in such a way that if ANYTHING
> goes wrong, even the proverbial pointy-hair damager can set
> things back the way they were.
>
> Meanwhile, the backups are churning along with good old crontab/cpio.
> Do you think for a second I'm going to touch them AT ALL before
> I fix all the other crap?
>
> NBW!!! (No-Bloody-Way!!!)
>
> Life isn't always linear, my friend...
Your points are good and you have my sympathy. Don't they make test
boxes in your country? ;-)
Anyway that problem will go away if they ever decide to upgrade to 10g
or above. They'll look pretty funny demanding DMTs.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Apr 18 2005 - 12:21:23 CDT