Common Oracle DBA Tasks

As an Oracle DBA, you can expect to be involved in the following tasks:

   作为一名数据库管理员,你需要完成以下任务:


■Installing Oracle software

   安装数据库软件


■Creating Oracle databases

   创建Oracle数据库


■Performing upgrades of the database and software to new release levels

   完成数据库和软件版本升级

■Starting and shutting down the database instance

   开启和关闭数据库实例


■Managing the storage structures of the database

   管理数据库存储结构


■Managing users and security

   管理数据库用户及安全性


■Managing database objects, such as tables, indexes, and views

   管理数据库对象,如:表、索引、视图    


■Backing up the database and performing recovery operations when necessary

   备份数据库,必要时执行恢复操作


■Monitoring the state of the database and taking preventive or corrective action as

required

   监控数据库状态,采取必要的预防或纠正措施


■Monitoring and tuning database performance

   监控和优化数据库性能


■Diagnosing and reporting critical errors to Oracle Support Services

   向数据库技术支持人员诊断并报告严重错误


In a small to medium-sized database environment, you might be the sole person

performing these tasks. In large, enterprise environments, the job is often divided

among several DBAs, each of whom has a specialty, such as database security or

database tuning.

   在小到中型数据库环境下,你可能独自一人完成上述任务。而在大型企业环境下,这些工作通常会划分给多个DBA,每个人专门负责一个方面,例如:有负责数据库安全的,有负责数据库性能优化的。