Thanks for this site and the people involving in this site .
I want to know what are all the steps i need to follow in sequential manner .
I will be working on unix operating system and sunsolaris as server .
Big Congrats, Inreddy!
For the steps, your boss must gave to you a plan or someting
task list, if not, you spend like me the time looking on internet for big money, since december 2000, I waiting for steps.
Get to know your database structures. Number of instances that are currently running on your site. What are the depending applications and how cretical their functionality to your organization. Know the tools they us to monitor the database and get some aquaitence with them. Always keep a note of what you do? If u have to delete/update/drop any record/table/schema, always double confirm it and make a temp copy of it such that you would not land into problems in case of mistakes. Then the location of your backup scripts and the type of backup they do. Always be ready to involve in the disaster recovery process. Talk to your DBA regaring the methodologies, and the company practice. Get to practice the recovery process in your test database atleast once a month. Talk to your dba, find out how they get the system alerts, and if there are some mailing list, make a request to add you in that. Check the alert logs of your instance for any possible problems. Know your oracle support CSI/username and password, so that you can go and create tar in case of emmergencies
I know it is too much to know, don't worry, if it is going to take some time.
Don't sweat it, you're do just fine. You should be thankful that you have someone to work with. I just got promoted to a DBA gig myself last month, but the sad part is, I'm the only Oracle guy here, and our support with Oracle is non-existant.
Here's what I have been doing.
del, drop stuff left and right, and then try to recovery it backup, and if I have trouble, then I come to this forum..hehehe
here are some of the books I bought with my own money..
1. Oracle Scripts O'Reily
2. Oracle Database Admin O'Reily
3. Oracle8i dba handbook Kevin Loney
4. Oracle database admin Neol Yuhanna
5. OCP oracle8i study guide
if there is something that is good material to keep, let me know guys.
This is a compiled version I have collected from this forum from July 2000 about DBA duties and DBA in new shops
Oracle DBA Daily duties
DAILY ACTIVITIES :
· Monitor disk space usage.
· Monitor CPU usage and kill hanging process
· Monitor disk I/O activities
· Check database errors in alert.log file
· Check Users' login
· Monitor network error in listener. log file
· Monitor SQL*Net connection error in SQLNET.LOG
· Monitor RMAN backup
· Monitor cronjob errors
· Monitor users’ errors in bdump/cdump/udump directory
· Monitor unix messages in /var/adm/messages file for the Disk Array and memory errors
· Monitor cpu usages by using sar command
· Run vmstat command to list out virtual memory usage
· Run ps command to monitor unix processes
· Run appropriate SQL command to monitor free space in all tablespaces with in database and page it to email account
· Run appropriate SQL command to monitor rollback segments contention.
· Run appropriate SQL command to monitor sort area sizes in temp Tablespace
· Run appropriate SQL command to monitor data buffers so that at least 90 % cache hit ratio can be maintained and send email.
· Run appropriate SQL command to monitor library so that at least 90% cache hit ratio can be maintained and sends email.
· Run appropriate SQL command to monitor row cache so that at least 99% hit ratio can be maintained
If you have standby DB,
· Check for any error in UPDATING STANDBY DATABASE
If you do hotbackup,
· Check for any error in HOTBACKUP
Oracle DBA duties in a new company
. List hardware & software vendor, contact phones & E-Mail
. Machine hardware configuration such as, number of CPU, memory, number of disks. Mirrored? Striped disks? Clustered?
. Find out if there are any test machines, possible to test any procedure (backup & recovery for example) in any test machines? Essential to ablecarry out tests in test machines
. How is the database being used, with what applications (any ERPs, E-Commerce, E-Business), how many instances, one per application?
. Hybrid database?
. How many users? If the enviroment is Web Based monitor the database for a couple of days
. Check backup strategy. What software is used, Veritas? RMAN? Suggestion, integrate RMAN with Veritas, if possible Veritas volume manager. What happens if the system goes down, Standby database or Advanced Replication?
. Uptime, 99.9%, 99.99% or 99.999% of year. 525 minutes, 52 minutes or 5 minutes per year
. Check database structure:
Datafile locations, striped at OS level or database level?
Redo Logs locations, multiplexed?
Control fileslocations, multiplexed?
. Check Tablespace, Datafiles free space
. Backup controlfile to trace then check the parameters in the trace file. Such as MaxDatafiles
. Check dump directories
. Check initSID.ora, get a print out
. Check shellscripts, and PL/SQL scripts if any is used. Try to understand as much what do they do
. Keep logs of what you have done, everytime youhave hadto modify databaseconfiguration
. Prepare a list of DAILY ACTIVITIES, WEEKLY ACTIVITIES, MONTHLY ACTIVITIES
. Prepare ERD of the database to help understanding of the system
. Have a talk with the old DBA and the developers to see if there are any potential problems they have faced
. Be a good listener
. Finally after gathered all necessary information plan a perfomance tuning
Appropriate SQL commands may be scripts or manually