健康检查报告

XXXXXXXXXXXXXXX

XXXXX

数据库健康检查与评估XXXX

巡检人： 报告生成日期：

yyyy-mm-dd

Oracle

文档控制

此文档仅供江苏移动审阅，不得向与此无关的个人或机构传阅或复制。

修改记录

分发者

审阅记录

相关文档

健康检查报告 日期 作者 版本 修改记录 、姓名 职位 姓名 职位

第2页

目录

健康检查报告 文档控制 ....................................................................................................................................2

修改记录 .............................................................................................................................2 分发者 .................................................................................................................................2 审阅记录 .............................................................................................................................2 相关文档 .............................................................................................................................2 目录 ............................................................................................................................................3 1.

检查介绍 ......................................................................................................................5

1.1 检查系统 ...............................................................................................................5 1.2 检查范围 ...............................................................................................................5 2.

硬件配臵 ......................................................................................................................7

2.1 主机配臵 ...............................................................................................................7 3.

系统配臵 ......................................................................................................................8

3.1 操作系统数据库相关要求补丁 ...........................................................................8 3.2 硬盘可用空间 .......................................................................................................8 3.3 CPU 利用率 ........................................................................................................8 4.

数据库配臵 ................................................................................................................10 4.1 数据库版本和单独补丁 .....................................................................................10 4.2 CRS版本和单独补丁 ........................................................................................10 4.3 ORACLE CLUSTER配臵 ...............................................................................10 4.4 数据库产品选项 .................................................................................................11 4.5 初始化参数文件 .................................................................................................11 4.6 CRS日志文件 ....................................................................................................11 4.7 RDBMS运行日志和跟踪文件 ..........................................................................11 4.8 控制文件 .............................................................................................................12 4.9 Redo log 文件 ..................................................................................................12 4.10 归档Redo log 文件 ..........................................................................................13 4.11 数据文件 .............................................................................................................13 4.12 表空间 .................................................................................................................14 4.13 回滚段管理 .........................................................................................................16

5.

数据库简单风险评估 ................................................................................................17

5.1 安全性管理 .........................................................................................................17 6.

SqlNet 概况 .............................................................................................................18

6.1 监听器Listener .................................................................................................18 6.2 SQL*Net ............................................................................................................18 6.3 TNSNAMES ......................................................................................................18 7.

数据库性能 ................................................................................................................19

7.1 数据库各项基于时间模型的统计信息 .............................................................19 7.2 数据库负荷压力分析 .........................................................................................20 7.3 各项命中率 .........................................................................................................21 7.4

等待事件 .............................................................................................................21

第3页

健康检查报告 7.5 统计信息分析 .....................................................................................................21 7.6 数据库I/O性能 ..................................................................................................22 7.7 索引/行迁移/行链 ............................................................................................22 7.8 Enqueue等待分析............................................................................................23 7.9 Latch分析 ..........................................................................................................23 7.10 Resource Limit分析 ........................................................................................23 7.11 Top SQL语句 ....................................................................................................24

8.

数据库备份策略评估 ................................................................................................25

8.1 备份 .....................................................................................................................25 8.2 恢复 .....................................................................................................................25 9. 数据库特别关注点检查 ............................................................................................26 10.

检查总结 ....................................................................................................................27

附录:初始化参数 .....................................................................................................................28

数据库所有非默认值的参数： .......................................................................................28

第4页