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
Wednesday, January 15, 2014
ADD NAS STORAGE VOLUME IN SOLARIS
All step do carefully
* Create directory login as Root user
mkdir /nas_dbbkp_vol07
*mount storage volume
mount 10.1.1.182 : /vol07 /nas_dbbkp_vol07
Same like df -k command output show below
10.1.1.182:/vol03 527653368 454725188 72928180 87% /nas_db_vol03
10.1.1.182:/vol04 733729284 655457888 78271396 90% /nasbackup
10.1.1.182:/vol07 527653368 469690572 57962796 90% /nas_dbbkp_vol07
10.1.1.182:/vol08 527653368 465027508 62625860 89% /nas_dbbkp_vol08
10.1.1.184:/vol06 527653368 356831744 170821624 68% /nas_dbbkp_vol06
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 ...

























































