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,每个人专门负责一个方面,例如:有负责数据库安全的,有负责数据库性能优化的。
转载于:https://blog.51cto.com/wuluwa/1264354