Dba Activities

Dba Activities

Introduction

In this blog i am going to explain Dba Activities in daily ,monthly,quarterly and other activities for database administrators in real time projcets and different domains and environments like production,testing,development etc

Daily Activities

• Check the Database Availability
• Check the listener Availability
• Check Space Availability
• Check any sessions Blocking the other sessions oracle locks and clear locks
• Check long running unix process
• Check the Alert log for an error
• Check the Top sessions using more physical I/o
• Deleted Locked Objects
• Check the SQL query Consuming lot of Resources
• Monitoring Temp and UndoTablespace
• Taking Database/Archived Backups
• Checked Failed backups and retrigger them
• Health Check of the Database
• Password lock/expired issues
• Tuning slow running queries
• Refresh activities- datapump
• Check all Crontab house keeping script logs
• Daily tablespace utilization and growth
• Rebuilding of Indexes,if bulk load of data is inserted
• Check the temporary tablespace/Files
• Check locked and expired user in database and unlock/reset/informto business users
• Check the user account grace period
• Check the Undotablespace and retention 
• Check the unix /tmp and /var location
• Check the UTL_file location 
• Check all database filesystem or drive
• Monitor the archive log location 
• verify sucess of database archive to tape
• Monitor the logfiles,bakups,database space usage and the use of system resources
• Monitoring the production database performance 
• Find high cpu/memory/physical io consuming process and trace the sql/form/report running behind the database and update to application team/users
• Check OEM agent is running or not in each node 
• Verify DBSNMP is running
• Verify sucess of database backup
• User management and user profile monitoring on daily basis
• Check invalid objects and recompile
• Check and monitor audit log or table for new audit entry
• Monitor daily failed login attempts in database and update to respective endusers
• Backup your Crontab or windows jobscheduler
• Taking incremental backups and monitor the sucess or failure and mail to respective stake holders
• Check all lastnight backups were sucessful
• Check your oracle licence and do not run/execute/create anything beyond the oracle licence expiry policy
• Daily resolving tickets and maintained the SLA's and RPO's
• Check audit logs for checking unauthorized access  
• Daily checking of nagios or any ticketing tool alerts and take corrective action
• Daily checking database reports scheduled in html formats related to both database maintanace and project functionality  

Weekly Activities

• Growth of the database
• Database growth Comparsion
• Identify bad growth projections
• Database Refresh from Production
• Cross check weekly report of RMAN full databse backup
• Analyse database and schema to gather statastics
• Truncate teh listener.logfile in the $oracle_home/network/log ifthe listener log has increased to a size > 500mb ensure that the space is released,otherwise reload listener
• Check how much redo generated perweek 
• Archive or deleted listener log file
• Archive or delete tracefiles from diagnostioc destination
• Archive and compress all alertlogs and applications log history location
• Check i/o of each data file
• Check open_cursor not reaching the max_limit
• Check the size of the tables & check whether it need to partition or not
• check the objcet reload in memory many times
• Remove audit logs since at present we have oneweek retention policy
• Weekly checking the ADDM Reports and AWR Reports and OEM Reports if problems any found in Database 
• Check the objects Fragmented,chaining &migrated rows
• Check for block corruption
• Check the free space at o/s level(weekly ,monthly)
• Check the Invalid Objects of the database
• Growth of the Database(weekly,monthly)
• Taking logical backups,incase of physical backup failure

Dba Montly Activities

• Check Database growth and free space availability at OS level request for next month  disk space to storage team
• Check and Rebuild indexes if needed
• Investigate fragmentation(eg rowchaining etc)
• Check the overall database statastics
• Trend analysis of objects with tablespace,last analyzed no ofrows,growth indays
• Restoration of monthly fullbackups
• Mail of backup stategy to all stake holders
• Tablespace reorganization
• Check default tablespace and temporary tablespace of each user

Dba Quarterly Activities

• Database Patching
• Bounce most critical database once a month
• Review common oracle tuning point

Other Dba Activities

• Install and configure oracle database on server perform database upgrades
• Add new users to database and assignprivileges
• Prepare the backup strategy and list all the receovery scenario
• Perform POC ---proof of concept and show it to the client

What kind of issus will find in daily

• Backup failure issues
• Tablespace issues
• File system Space
• Alert log and Trace file house keeping
• Gathering stats---> monitoring
• Archived log full ---->Free up using RMAN
• Dataguard -Rebuild if found gap more and missing archives
• Configure/setup-disatser receovery 
• Maintanance
• Patching
• Listener failure/reason if any maintanance
• Monitoring Alert log
• Verify instance up and running

Note : Info on  Dba Activities it may be differ in your environment like production,testing,development etc

THANKS FOR VIEWING MY BLOG FOR MORE UPDATES FOLLOW ME AND SUBSCRIBE ME