Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tasks of an Oracle-DBA

Re: Tasks of an Oracle-DBA

From: Michiel <cube_at_REMOVE.dds.nl>
Date: Mon, 25 Jun 2001 23:00:36 +0200
Message-ID: <3b37a6be$0$21750@reader4>

actually, the best DBA tasks should be:
none!

If you're a good DBA, all tasks should be initialized and automated... : a normal server should be up at least for 500 days. And if your good (and use Oracle 9i), that should be the same uptime for all the instances you're responsible for.

Tasks for you 'DBA' are:
Easeup an upgrade of an application.
Distribute that upgrade to several servers. Fine-tune, in case of bad peformance, but a DBA should have done that during the upgrade.
And, of course, do all of the above from his house-hold and through scripts.

If none of the above is applieable for you: (if you're starting) think of easy scripts for:
write scripts for backup/restore.
performance (use enterprise manager!).
write automated scripts for everything (so they can run at night). try to write logging for exceptional tasks

If you have no experience with shell-scripting (in any shell), search the internet.

good luck,
Michiel K.

>Hi all!
>
>What are the daily/weekly/monthly/yearly tasks of an Oracle-DBA that
>must/can/should be done?
>
>production-db: Oracle 8.1.5 on Sun Solaris 7
>test-db: Oracle 8.1.6 on RedHat 6.2 Prof.
>
>Thanx Stefan
Received on Mon Jun 25 2001 - 16:00:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US