Oracle DBA日常任务

好久没看官方文档，最近比较闲，开始回过头来读读oracle官方文档了，感受颇深哈，今天把oracle dba常要做的任务整理如下，供大家参考：

1：安装oracle数据库软件。

2：搭建oracle数据库。

3：升级数据库到新的版本。

4：开，关数据库。

5：数据库存储管理。

6：数据库用户跟权限管理。

7：数据库实体管理，比如表，试图，索引等。

8：数据库备份跟恢复。

9：数据库日常监控以及异常情况处理。

10：数据库性能优化。

 

源信息来源：Oracle Database 2 Day DBA 

Common Oracle DBA Tasks

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

• Installing Oracle software

• Creating an Oracle database

• Upgrading the database and software to new releases

• Starting up and shutting down the database

• Managing the storage structures of the database

• Managing user accounts and security

• Managing schema objects, such as tables, indexes, and views

• Making database backups and performing database recovery, when necessary

• Proactively monitoring the condition of the database and taking preventive or corrective actions, as required

• Monitoring and tuning database performance