Sunday, September 27, 2020

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


Dba Activities,oracle dba tasks checklist,dba tasks and responsibilities,senior oracle dba roles and responsibilities,oracle dba roles and responsibilities resume,oracle dba job description,sql dba roles and responsibilities,oracle dba skills,senior oracle dba job description,database administrator responsibilities,sql dba roles and responsibilities,what is main function of database administrator,what are the main duties of dba,database administrator skills,oracle dba issues and solutions,oracle database troubleshooting scenarios,oracle dba activities,database administrator responsibilities,oracle dba tasks checklist,oracle dba administrator roles and responsibilities,sql dba roles and responsibilities,all dba activities in sql server,sql dba roles and responsibilities,database administrator skills,database administrator job description


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


ITIL Process

ITIL Process Introduction In this Blog i am going to explain  ITIL Process, ITIL stands for Information Technology Infrastructure Library ...