Oracle Database Administrator


Oracle DBA responsibilites

This is a very basic post in field on Oracle DBA, What actually a DBA do, what are his responsibilities; here we will discuss it all.

*Evaluation of database server hardware:
DBA needs to evaluate the Oracle server hardware, it mainly depend on what is database size, what is backup strategy, total number on users connecting. Many more factors are there, which helps to decide the hardware for Oracle server.
• How many disk drive it needs
• Tape drives for backups
• Memory for instance in other terms SGA, PGA

*Install Oracle Software
As a DBA you need to install Oracle software on server, installation process may be slightly different for OS to OS.
Along with database software, you need to install and configure oracle clients, Oracle Net connection configuration.

*Planning the Database design
• Logical and physical storage structure
• Overall DB design
• Backup strategy etc.

*Backup Database
After database configured, we need to design backup strategy and adjust related parameters like redo logs etc
Along with that, there are several different duties also like security and policies, user and roles administration.
Performance tuning is the toughest job in Oracle DBA field.

We will discuss these entire things in later posts.


Reference: http://linux-oracle-dba.blogspot.com/2009/11/oracle-dba-tasks.html


Related Articles

Oracle Database architecture : for Beginers

In this post I am trying to simplify Oracle Architecture, generally we found thousands of Articles over this topic , but these are somewhat complicated for a new DBA or junior level DBA Or a DBA aspirant . So, I ll try to make it simple at start then gradually we will go for some detailed knowledge.

More articles: Oracle Database Administrator Computer

Comments

No responses found. Be the first to comment...


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: