Oracle DBA Daily Checklist
1. Check that all instances are up.
2. Monitor alert log entries (using tail -f)
3. Check that dbsnmp(SNMP subagent for Oracle DB) is running.
4. Check all last night backups were successful.
5. Check all database archiving are done.
6. Check tablespaces should not be used more that 95%.
7. Check all crons and Oracle Jobs are completed without any error
8. Verify resources for acceptable performance.
9. Identify bad growth of Segments.
10. Identify atleast 1 top resource consuming query
Related Links:
- Database Routine Checklist Queries
- Total Size of Database
- Find 10 largest objects
1. Check that all instances are up.
2. Monitor alert log entries (using tail -f)
3. Check that dbsnmp(SNMP subagent for Oracle DB) is running.
4. Check all last night backups were successful.
5. Check all database archiving are done.
6. Check tablespaces should not be used more that 95%.
7. Check all crons and Oracle Jobs are completed without any error
8. Verify resources for acceptable performance.
9. Identify bad growth of Segments.
10. Identify atleast 1 top resource consuming query
Related Links:
- Database Routine Checklist Queries
- Total Size of Database
- Find 10 largest objects
why "(using tail -f)" in point 2
ReplyDeleteits a suggestion only (for linux)
ReplyDeletetail -f continues to 'follow' the file. When some lines are added to file, they will be displayed on the terminal automatically. This is very useful for watching log files.
but if you check alert log with "tail -f", wouldn't you miss the errors/warning generated last night, as you are 'following' the file for current and future entries.
ReplyDeleteyes u have to check last night error using some text editor or vi.
ReplyDeletemake some shell script to grep some special logs (usually other then checkpoint and log switch) in alert log and send a mail or sms to you
DeleteHi Nimish, "send a mail or sms to you" you have a script that does that? kindly share
Deleteand what about logs other then alert log ( listener.log or sqlnet.log etc. )
ReplyDeletelistener.log is usually not monitored on daily basis. we usually check it when we get one of following error(s).
ReplyDeleteTNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNSrotocol adapter error
TNS-00510: Internal limit restriction exceeded
Here I want to add that listener is usually the target of many database attacks, this information can reveal
valuable clues and help you build better defenses.
also i got one oracle document about this, plz check this out
ReplyDeletehttp://download.oracle.com/docs/cd/B19306_01/network.102/b14212/troublestng.htm#i440403
"listener.log is usually not monitored on daily basis. we usually check it when we get one of following error(s).
ReplyDeleteTNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNSrotocol adapter error
TNS-00510: Internal limit restriction exceeded"
And where did you get these errors??
usually at the application level
ReplyDelete