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
June 21, 2009 at 7:46 am
Good keep it up
October 16, 2009 at 4:07 am
Thx for sharing the informatiom,keep it up.