11 Replies Latest reply on Oct 10, 2015 1:46 PM by Chiranjeevi M A

    Basic and critical Aps DBA Tasks

    Beauty_and_dBest

      Hi ALL,

       

      ALL EBS version.

       

       

      As an apps dba, I consider the following task as the most basic and most important.

      Can you help check what do I need to add?

       

      1. Check if daily backup runs are successful and recoverable and readable.

      2. Backup/Clean up/delete old log files ( all type of log files).

      3. Check physical disk space freespace utilization  should be less 80% in all mount points /root  /u01  others

      4. Check logical tablespaces freespace utilization, temp, undo, rbs, FRA.

      5. Check init.ora for ORA- errors

      6. Perform gather schema stats weekly.

       

       

      For me the above tasks are the most critical.

      Are there other critical tasks I missed?

       

       

      Thanks a lot,

      jc