健康检查报告
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页