Tasks of database administrator
- 1. Presentation On: Tasks Of Database Administrator Presented To: Sir Israr Hussain Presented By: Attia Qamar
- 2. Database Administrator TasksDatabase Administrator Tasks These are the following tasks of Database Administrator: Task 1:Evaluate the Database Server Hardware Task 2:Install the Oracle Database Software Task 3:Plan the Database Task 4:Create and Open the Database Task 5:Back Up the Database Task 6:Enroll System Users Task 7:Implement the Database Design Task 8:Back Up the Fully Functional Database Task 9:Tune Database Performance Task 10:Download and Install Patches Task 11:Roll Out to Additional Hosts
- 3. Task 1: Evaluate the Database Server Hardware This evaluation should reveal the following information: Best use the available computer resources How many disk drives are available to the Oracle products How many, if any, dedicated tape drives are available to Oracle products How much memory is available to the instances of Oracle Database
- 4. Task 2: Install the Oracle Database Software As the database administrator: Install the Oracle Database server software Any front-end tools Database applications Install the Oracle Net components
- 5. Task 3: Plan the Database As the database administrator, you must plan: The logical storage structure of the database The overall database design A backup strategy for the database
- 6. Task 4: Create and Open the Database
- 7. Task 5: Back Up the Database After you create the database structure: Carry out the backup strategy Create any additional redo log files, Take full database backup (online or offline), Schedule future database backups at regular intervals
- 8. Task 6: Enroll System Users
- 9. Task 7: Implement the Database Design Implement the planned logical structure database by creating: All necessary tablespaces When you have finished creating tablespaces, you can create the database objects.
- 10. Task 8: Back Up the Fully Functional Database Regularly scheduled backups
- 11. Task 9: Tune Database Performance Optimizing the performance of the database Control the allocation of resources among various user groups.
- 12. Task 10: Download and Install Patches After installation DB, download and install patches A patch is a piece of software designed to update a computer program single interim patches patch sets (or patch releases)
- 13. Task 11: Roll Out to Additional Hosts Clone your tested Oracle Database: Cloning an Oracle home Manually clone an Oracle home You have multiple production database systems. You want to create development and test systems that are identical to your production system.