Saturday, February 22, 2014
SOLARIS 8 INSTALLATION ON SUN FIRE V240 SERVER
Labels:
OPERATING SYSTEM(UNIX/LINUX)
I am Anurag Pandey, working as Cloud Database Architect | Migration & Modernization Expert .
Database Administration and Implementation. Provide technical guidance and work with global team.
Extensive Experience in Database Installation and Configuration, Real Application Cluster (RAC), ASM, Dataguard , Patching, Upgrade, RMAN, Performance Tuning, Backup and Recovery, Azure, Google, AWS Cloud, AWS RDS, MySQL, Database Migration Service(DMS),CloudEndure - MGN, Azure Site Recovery, Azure Migrate, Datapump, terraform automation, Ansible
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
Labels:
ORACLE DATABASE
I am Anurag Pandey, working as Cloud Database Architect | Migration & Modernization Expert .
Database Administration and Implementation. Provide technical guidance and work with global team.
Extensive Experience in Database Installation and Configuration, Real Application Cluster (RAC), ASM, Dataguard , Patching, Upgrade, RMAN, Performance Tuning, Backup and Recovery, Azure, Google, AWS Cloud, AWS RDS, MySQL, Database Migration Service(DMS),CloudEndure - MGN, Azure Site Recovery, Azure Migrate, Datapump, terraform automation, Ansible
Subscribe to:
Posts (Atom)