DBA duties
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: DBA duties

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    DBA duties

    Hello all..

    I have Oracle 9.2 on sun 5.8

    What are the things i need to look into Daily, Weekly, monthly for the database.

    I look into Alert log , and check the nightly backup's. What other things do i need to look into on a daily, weekly, monthly basis.?


    Appeciate if anyone can help me on this
    Thanks
    Ron

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    DBA 101 by Oracle Press/Osborne
    DBA Bible by IDG Books
    http://tahiti.oracle.com

  3. #3
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    DBA Job responsibilities vary by organizations. Anyways, You can check the following Document which lists the daily, weekly and montly tasks that are performed by DBA's in general. This Document is old but still holds good.

    www.quest-pipelines.com/newsletter/checklist.doc
    -- Dilip

  4. #4
    Join Date
    Apr 2001
    Posts
    108
    Those lists are good places to start. As was stated above, generic duties vary from site to site. The best advice is to be proactive on your systems and dig into them to insure you know how they are set up and running so that when a problem comes up you don't have to spend time looking to see how it was.

    And for your backups I cannot stress heavily enough to verify the backups were valid. I knew a site where all they did to verify the backup was to look at the byte count for the tape backup. Then when they had to restore from tape they then discovered that their backups were not any good and they could not restore from tape. From time to time take a backup tape and restore it to a test server to insure that your process is working correctly.
    Eric Hanson

    There are 10 types of people in the world:

    Those who understand binary and those who don't!

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Have a look here..

    http://www.dbazine.com/liu2.html

    regards
    Hrishy

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Jan 2001
    Posts
    3,131
    Don't believe any of this!!

    For the most part we sit around drinking coffee and verbally humiliate developers. Of course there is the occasional discussion on sports, and the ever popular Biggest Booger Contest of which yours truly is the reigning champion 2 years in a row.
    Now where is my double mocha frappachino late’.

    MH
    I remember when this place was cool.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width