Daily Oracle DBA Taks

• Verify all database, instances, listener status
• Identify bad growth projections
• Clear the trace files in the udump and bdump directory as per the policy
• Verify all the monitoring agent, including OEM agent and third party monitoring agents
• Verify the status of daily scheduled jobs/daily backups in the morning very first hour
• Check the database performance, periodic basis usually in the morning very first hour after the night shift schedule backup has been completed
• Verify the success of archive log backups, based on the backup interval
• Check the space usage of the archive log file system for both primary and standby DB
• Check the space usage and verify all the tablespace usage is below critical level once in a day
• Verify Rollback segments
• Check the sync between the primary database and standby database, every 20 min
• Make a habit to check out the new alert.log entry hourly specially if getting any error
• Check the system performance, periodic basis
• Check for the invalid objects
• Check out the audit files for any suspicious activities
• Make a daily habit to learn something new from any technology