Saturday, February 22, 2014

SOLARIS 8 INSTALLATION ON SUN FIRE V240 SERVER

Steps to install solaris 8 on  Sunfire V240 Server using putty
*Insert Soalris CD in server CDROM






















































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