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:
Posts (Atom)
How to create Nano Banana 3D figurine step-by-step?
1. Launch Google Gemini or open Google AI Studio. 2. Select and upload the photo you want to convert. 3. Enter the following nanao banana 3...
-
root@localhost dev]# [root@localhost dev]# fdisk /dev/sdc Device contains neither a valid DOS partition table, nor Sun, SGI or OSF diskla...
-
Error while starting ./runInstaller for oracle 19c installation on Linux 8 [oracle@ip-192-168-43-225 oracle]$ ./runInstaller /u01/or...
-
Error: ORA-16662: network timeout when contacting a member DGMGRL> DGMGRL> show configuration Configuration - prod_ddb Protection ...