Saturday, June 9, 2012

DBA checklists



Bellow are some procedures that Oracle DBA might know 
 
 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