Introduction to DataBase Administration
Each database requires at least one database administrator (DBA).Database administration is one of the key areas in which a DBA should take care. A system for Oracle database can be very large and can have many users. Therefore, the database administration is not the responsibility of single person but it is a job for a group of DBAs who share responsibility.
The Common tasks of database administration include the following tasks:
- Install and upgrade Oracle Database and Tools
- Allocating system storage and planning future storage requirements for the database.
- Plan Database
- Implement Database design
- Creation of primary structures of database storage (tablespaces) after application developers have designed an application
- Creating primary objects (such as tables, views, indexes) once application developers have designed an application.
Changing database structure as necessary, from information supplied by application developers.
Creating and managing of users and maintain security
compliance system to ensure the supervision of Oracle licenses - monitor user access to databases Data
- Planning Backup of Database
- Planning Recovery of database
- Download and install patches