I. Daily Procedure
1. Verify all instances are up
2. Look for any new alert log entries
3. Verify DBSNMP is running : Which may be security treat
4. Verify success of database backup
5. Verify success of database archiving to tape
6. Verify enough resources for acceptable performance
7. Copy Archived Logs to Standby Database and Roll Forward
8. Read DBA manuals for sometime
II. Nightly Procedures
1. Collect volumetric data
2. Taking offline/cool full backup if necessary
III. Weekly Procedures
1. Look for objects that break rules
2. Look for security policy violations
3. Look in SQL*Net logs for errors, issues
4. Archive all Alert Logs to history
5. Visit home pages of key vendors
IV. Monthly Procedures
1. Look for Harmful Growth Rates
2. Review Tuning Opportunities
3. Look for I/O Contention
4. Review Fragmentation
5. Project Performance into the Future
6. Perform Tuning and Maintenance
No comments:
Post a Comment