This discussion is archived
3 Replies Latest reply: Feb 21, 2006 12:47 AM by 376714 RSS

Daily activities of dba

472009 Newbie
Currently Being Moderated
Dear all,

Can some tell me daily activities of dba.
and also I want to what to do on the first day of job?
(means How to collect the information of database?)

Thanks In advance.
  • 1. Re: Daily activities of dba
    464759 Newbie
    Currently Being Moderated
    Daily activities of the DBA depends on which kind of organization you work: it can be very different from one company from the other one.

    I would suggest you to read first:
    1. Oracle® Database 2 Day DBA
    Then:
    2. Oracle® Database Administrator's Guide

    A good starting point can be to learn how the DBA team does backups and restores: this is one of the most important thing that a DBA must really know to do in theory and in practive.
  • 2. Re: Daily activities of dba
    424871 Newbie
    Currently Being Moderated
    ...and don't forget answering questions on OTN too ;)
  • 3. Re: Daily activities of dba
    376714 Newbie
    Currently Being Moderated
    Can some tell me daily activities of dba.
    As a DBA I usually take showers, eat, drink, speak with people... :-)
    j/k

    I think it all depends on your company, environment, team, etc. I mean, you'll not do the same things whether you're the only DBA or if you're part of a team, or head of a team.

    What I would do on the first day of the job:
    . Say hi to the team, and get to know as many people as possible. As a DBA, you're not likely to stay everybody's "best friend" for long ^^
    . Set up a little "welcome aperitif"
    . Stick the Network admin in order to get an overall idea of the network
    . Check with the Sysadmin(s) of the box where the databases(s) run how they configured the servers, how they manage it (backup, patch, ...), and if they're using Windows, convince them to migrate to Unix :-)
    . If there's a DBA team, check with the team manager where are the databases, versions, ... if there's no team, just use your boss and colleagues provided info to find where are the database(s).
    . Connect to one and every database and gather info : Log mode, jobs, size, statistics, ...

    Well, these are just some possibilities. I certainly have forgotten lots.

    Yoann.