2011-05-09 14:25:17nut
[技術]Oracle數据庫管理員要做的事(每天、每周、每月)
==============每天===========================================
I. DAILY PROCEDURES
A. VERIFY ALL INSTANCES ARE UP 查看所有的介面都是可work的
B. LOOK FOR ANY NEW ALERT LOG ENTRIES 尋找是否有任何新的異動log
C. VERIFY DBSNMP IS RUNNING 查看DBSNMP是否有RUN起來
D. VERIFY SUCCESS OF DATABASE BACKUP 查看DB備份是否成功
E. VERIFY SUCCESS OF DATABASE ARCHIVING TO TAPE 查看DB是否有成功歸檔到磁帶機
F. VERIFY ENOUGH RESOURCES FOR ACCEPTABLE PERFORMANCE 查看是否有足夠的資源可運作且效能沒有down下來
G. COPY ARCHIVED LOGS TO STANDBY DATABASE AND ROLL FORWARD 複製歸檔的log到另一台DB中, 互相備援
H. READ DBA MANUALS FOR ONE HOUR 每個小時看一下DBA手冊 (看要做哪些事?)
=================每晚==========================
II. NIGHTLY PROCEDURES
A. COLLECT VOLUMETRIC DATA 收集容積資料
=================每周=============================
III. WEEKLY PROCEDURES
A. LOOK FOR OBJECTS THAT BREAK RULES 尋找發生錯誤的物件
B. LOOK FOR SECURITY POLICY VIOLATIONS 尋找違反安全性的政策
C. LOOK IN SQL*NET LOGS FOR ERRORS, ISSUES 查看SQL*NET Log, 看是否有錯誤議題
D. ARCHIVE ALL ALERT LOGS TO HISTORY 將所有的異動log歸檔到歷史資料區
E. VISIT HOME PAGES OF KEY VENDORS 瀏覽關鍵供應商的官網
=================每月================================
IV. MONTHLY PROCEDURES
A. LOOK FOR HARMFUL GROWTH RATES 查看損害成長率
B. REVIEW TUNING OPPORTUNITIES 複查校調機會
C. LOOK FOR I/O CONTENTION 尋找是否有I/O競爭及其原因
D. REVIEW FRAGMENTATION 複查破碎
E. PROJECT PERFORMANCE INTO THE FUTURE 計畫未來的效能(未來成長率?)
F. PERFORM TUNING AND MAINTENANCE 效能調校與維護
=======================================================================
I. DAILY PROCEDURES
A. VERIFY ALL INSTANCES ARE UP 查看所有的介面都是可work的
B. LOOK FOR ANY NEW ALERT LOG ENTRIES 尋找是否有任何新的異動log
C. VERIFY DBSNMP IS RUNNING 查看DBSNMP是否有RUN起來
D. VERIFY SUCCESS OF DATABASE BACKUP 查看DB備份是否成功
E. VERIFY SUCCESS OF DATABASE ARCHIVING TO TAPE 查看DB是否有成功歸檔到磁帶機
F. VERIFY ENOUGH RESOURCES FOR ACCEPTABLE PERFORMANCE 查看是否有足夠的資源可運作且效能沒有down下來
G. COPY ARCHIVED LOGS TO STANDBY DATABASE AND ROLL FORWARD 複製歸檔的log到另一台DB中, 互相備援
H. READ DBA MANUALS FOR ONE HOUR 每個小時看一下DBA手冊 (看要做哪些事?)
=================每晚==========================
II. NIGHTLY PROCEDURES
A. COLLECT VOLUMETRIC DATA 收集容積資料
=================每周=============================
III. WEEKLY PROCEDURES
A. LOOK FOR OBJECTS THAT BREAK RULES 尋找發生錯誤的物件
B. LOOK FOR SECURITY POLICY VIOLATIONS 尋找違反安全性的政策
C. LOOK IN SQL*NET LOGS FOR ERRORS, ISSUES 查看SQL*NET Log, 看是否有錯誤議題
D. ARCHIVE ALL ALERT LOGS TO HISTORY 將所有的異動log歸檔到歷史資料區
E. VISIT HOME PAGES OF KEY VENDORS 瀏覽關鍵供應商的官網
=================每月================================
IV. MONTHLY PROCEDURES
A. LOOK FOR HARMFUL GROWTH RATES 查看損害成長率
B. REVIEW TUNING OPPORTUNITIES 複查校調機會
C. LOOK FOR I/O CONTENTION 尋找是否有I/O競爭及其原因
D. REVIEW FRAGMENTATION 複查破碎
E. PROJECT PERFORMANCE INTO THE FUTURE 計畫未來的效能(未來成長率?)
F. PERFORM TUNING AND MAINTENANCE 效能調校與維護
=======================================================================