Re: Basic Scripts for Database Administration
Date: Thu, 25 Jun 2009 16:45:55 -0700 (PDT)
Message-ID: <a383da98-5fcc-4fe7-976c-7318f637449f_at_y28g2000prd.googlegroups.com>
> > If you just got a new job in which you inherited 10 servers, with 10
> > databases on each server, and no administration for the databases
> > existed yet, what approach would you take to providing DBA support?
> > Assume the databases are equally divided among windows and unix
> > servers and range in version from 9i, 10g to 11g.
>
> Is that what happened to you or are you posing theoreticals?
>
> Hire someone immediately with appropriate skills and experience if you
> don't have that set of knowledge would be my 1st recommendation.
No :) it didn't happen to me. But I first started working at a uni where the situation was similar. They had maybe 50 different scripts to manage things from database shutdowns, to analyzing, to kicking off batch jobs and all manner of custom scripts. Way too many now that I think about it.
> > Health checks would obviously be needed for things like disk space,
> > tablespaces, log monitoring, load monitoring, statspack, Data Guard
> > etc.
>
> Dude this whole area has been discussed time after time after time in
> this newsgroup.
>
> If you want to locate old relevant discussions here you can use the
> google groups interface and search the old postings.
You know I've never really got the impression that this has been discussed in length in this group. But, the thing is everyone has to do it someway. Received on Thu Jun 25 2009 - 18:45:55 CDT