Dream Always Dream , if you don't work on it : Real-world Oracle DBA troubleshooting guides for RAC, Data Guard, RMAN, performance tuning, upgrades, backups, and cloud migration. Tested in production environments.
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
Subscribe to:
Comments (Atom)
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...
-
C:\Users\Administrator.ANURAG-PC>tnsping ducat TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 27-DEC-2017 21:...
-
Error while starting ./runInstaller for oracle 19c installation on Linux 8 [oracle@ip-192-168-43-225 oracle]$ ./runInstaller /u01/or...
-
Install CSSCAN login with SYS user @?/rdbms/admin/csminst.sql ############### csscan \"sys as sysdba\" full=y ...



















































