| help! Oracle daily dba task needed? [message #369383] |
Fri, 08 September 2000 12:25  |
tommy
Messages: 22
Registered: July 2000
|
Junior Member |
|
|
I am new to Oracle, We have serveral Oracle 8 and Oracle 8i instances running. I am needing to know what daily maintenace needs to be done to the Oracle database to keep it healthy and running correctly.
Do I need to monitor table spaces, rollback segments,temp space....these are the items I can think of. Are there any that I am missing?
|
|
|
|
| Re: help! Oracle daily dba task needed? [message #369398 is a reply to message #369383] |
Wed, 13 September 2000 09:07  |
Salman Khan
Messages: 51
Registered: September 2000
|
Member |
|
|
2
Index
I. DAILY PROCEDURES 3
A. VERIFY ALL INSTANCES ARE UP 3
B. LOOK FOR ANY NEW ALERT LOG ENTRIES 3
C. VERIFY DBSNMP IS RUNNING 3
D. VERIFY SUCCESS OF DATABASE BACKUP 3
E. VERIFY SUCCESS OF DATABASE ARCHIVING TO TAPE 3
F. VERIFY ENOUGH RESOURCES FOR ACCEPTABLE PERFORMANCE 3
G. READ DBA MANUALS FOR ONE HOUR 5
II. WEEKLY PROCEDURES 6
A. LOOK FOR OBJECTS THAT BREAK RULES 6
B. LOOK FOR SECURITY POLICY VIOLATIONS 6
C. LOOK IN SQL*NET LOGS FOR ERRORS, ISSUES 6
D. ARCHIVE ALL ALERT LOGS TO HISTORY 6
E. VISIT HOME PAGES OF KEY VENDORS 7
III. MONTHLY PROCEDURES 8
A. LOOK FOR HARMFUL GROWTH RATES 8
B. REVIEW TUNING OPPORTUNITIES 8
C. LOOK FOR I/O CONTENTION 8
D. REVIEW FRAGMENTATION 8
E. PROJECT PERFORMANCE INTO THE FUTURE 8
F. PERFORM TUNING AND MAINTENANCE 8
IV. APPENDIX 9
A. DAILY PROCEDURES 9
B. WEEKLY PROCEDURES 11
V. REFERENCES 14
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
