These are the some basic DBA daily check list.
1) Daily Procedures:
Many of these procedures can be automated using shell scripts and a scheduler like cron or even using tools such as Oracle Enterprise Manager (OEM).
2) Verify all instances availability:
Make sure that all databases are available. Log into each instance and run daily reports or test scripts.
3 ) Look for any new alert log entries:
Each Oracle Instance has a background dump destination, usually in $ORACLE_BASE/ORACLE_SID/bdump. The alert log file (alert_ORACLE_SID.log) is in this location and should be checked for errors each day.
4) Verify success of database backup:
Keep a schedule of database backups and review logs to assure backups occurred successfully.
5) Verify enough resources for acceptable performance:
Keep a record of acceptable minimum amount / percentage free in tablespaces and compare it daily to reports.
6)Review contention for CPU, memory, network or disk resources:
Work with system administrators to develop methods to review contention for these resources.
7)verify the DR sync (if applicable):
Check to determine if latest archive logs have been applied to the database by looking at the alert log file for the standby(DR) database.
8)Maintan the monitoring scripts:
DBA can maintain the above listed monitoring scripts scheduled in crontab
No comments:
Post a Comment