Saturday, February 22, 2014

Sunday, February 2, 2014

ROUTINE OF ORACLE DATABASE ADMINISTRATOR


Daily Work of DBA:

* Check Whether Database Instance is up
* Check Oracle alert logs
* Check listener is working
* Check oracle core dumps
* Check oracle background dumps
* Check oracle user dumps
* Check v$backup that all datafiles should be in inactive mode
* Check the number of schema sessions
* Check the number of processes
* Check the various Tablespaces and Datafiles
* Check the DB Buffer Cache hit ratio
* Check the next extents and max extents
* Check DB Library Cache hit ratio
* Check the longer running processes
* Check the Status of Backup
* Check for any locking in the database
* Backing up Archive log files
* Check all schedule job run successfully
* Check all OS level mount point


Weekly Work of DBA:

* Growth of the Database.
* Total full backup of the database through hot backup.
* Taking logical backups, in case of physical backups failure
* Taking weekly Tablespace backup.

* Taking full backup on tape
* Taking Export backup  using EXP/EXPDP(export/import utilities)

Monthly Work of DBA:

* DB Cleaning(Index rebuilding)
* Change backup tape when new month start

Use Cases of Oracle Grid Control

  Use Cases of Oracle Grid Control  Oracle Grid Control was designed for centralized management of on‑premise Oracle IT infrastructure , es...