Here I am giving to give a quick checklist for a production dba. I have not included any script because each dba have its own scripts. Please have a look on into daily, weekly and quarterly checks .

 Daily Checks

  • Check the availability of the database and instance , every 15 mts
  • Check the availability of the listener, every 15 mts
  • Check the sync between the primary database and standby database , every 15 mts  or based on the SLA(Service level Agreement)
  • Check the space usage and make sure that all the tablespace  usage is below critical level, once in a day
  • Check the space usage of the archive log file system for both primary and standby
  • Verify the success of daily backups, once in a day
  • Verify the success of archive log backups , based on the backup interval to the  backup media
  • Check the system performance , periodic basis
  • Check the database performance , periodic  basis
  • Clear the tickets assigned in the ticketing mechanism
  • Check for the invalid objects
  • Go through the audit files for any suspicious activities
  • Go through the alert logs for any critical ora  errors , once in an hour
  • Verify all the monitoring agent, including OEM agent and third party monitoring agents , once in an hour
  • Archive the alert logs , if required
  • Clear the trace  files in the udump and bdump directory as per the policy
  • Verify the status of daily scheduled jobs

Weekly Checks

  • Check the database statistics collection. On some databases this needs to be done every day depending upon the requirement
  • Approve or plan any scheduled changes for the week
  • Check for critical and patch updates  from oracle
  • Verify the cron jobs scheduled and clear the output directory if required
  • Perform logical level backups of important tables
  • Perform level 0 or cold backup , this can be changed as per the backup policy

Quarterly Checks

  • Checks for the critical patch updates from Oracle,make sure that your systems are in compliance with CPU patches
  • Verify the accuracy for the backs by creating test databases from the backup
  • Verify the accuracy of the DR mechanism by peforming  a database switch over test. This can be done once in six months based on the business requirements