Oracle dba Daily Activities

 Daily Activities of Oracle Database Administrator 

  Daily Work of DBA:

1. Check the Database Availability
2. Check the Listener Availability
3. Monitoring space Availability
4. Viewing the Alert log file to analyze the ORA errors if any.
5. Check tablespaces should not be used more that 95%.
6. Viewing the temporary files, through the DBA_TEMP_FILES.
7. Daily resolving the tickets by using Remedy ticketing tool.
8. Taking backups by using RMAN on daily and weekly basis.
9. Check all last night backups were successful.
10. Health check of the Database.
11. Rebuilding of Indexes, if bulk load of data is inserted.
12. Backing up the archive log files.
13. Monitoring Backups.
14. Take a COLD/RMAN backups at night time. 
15. Validate Database backup or Archive backup
16. Find objects which is going to reach max extents
17. Database Health Check
18. CPU, Processor, Memory usage

  Weekly Work of DBA:

1: Growth of the Database.
2: Total full backup of the database through hot backup.
3: Taking logical backups, in case of physical backups failure.
4: Taking weekly Tablespace backup.

  Monthly Work of DBA:

1: Index Rebuild.
2: Tablespace Reorganization.
    Quarterly Work of DBA:

1: Patching
2: Database Reorganization