Lucifer 有限公司-Oracle数据库4019382963_LUCIFER巡检报告_20240315.pdf

Lucifer三思而后行

6363

30页

118次

2024-03-15

5墨值下载

Lucifer

有限公司

Oracle

数据库健康检查与评估

LUCIFER

库

Lucifer

20240315

Lucifer 有限公司

ORACLE 数据库 – 健康检查报告

- 2 -

数据库巡检介绍

....................................................................................................................................................... - 4 -

1.1 巡检对象 ........................................................................................................................................................................... - 4 -

1.2 检查介绍 ........................................................................................................................................................................... - 4 -

1.2.1 检查系统 ................................................................................................................................................................ - 4 -

1.2.2 检查方法 ................................................................................................................................................................ - 5 -

1.2.3 检查范围 ................................................................................................................................................................ - 6 -

1.3 检查总结 ........................................................................................................................................................................... - 6 -

1.3.1 概要 ......................................................................................................................................................................... - 6 -

1.3.2 评价 ......................................................................................................................................................................... - 6 -

1.3.3 建议 ......................................................................................................................................................................... - 6 -

2 LINUX

主机检查

....................................................................................................................................................... - 7 -

2.1 主机信息 ........................................................................................................................................................................... - 7 -

2.2 系统配置 ........................................................................................................................................................................... - 7 -

2.2.1 hosts 文件检查 .......................................................................................................................................................... - 7 -

2.2.2 内核参数检查 ....................................................................................................................................................... - 7 -

2.2.3 用户 limit 参数检查 ............................................................................................................................................. - 7 -

2.2.4 文件系统检查 ....................................................................................................................................................... - 8 -

2.2.5 内存检查 ................................................................................................................................................................ - 9 -

2.2.6 透明大页检查 ....................................................................................................................................................... - 9 -

2.3 DATABASE 补丁检查 ....................................................................................................................................................... - 10 -

2.4 DATABASE 监听检查 ....................................................................................................................................................... - 10 -

2.5 DATABASE SQLNET 检查 ............................................................................................................................................... - 11 -

3 RAC GRID

集群检查

.............................................................................................................................................. - 12 -

3.1 GRID 补丁检查 ................................................................................................................................................................ - 12 -

3.2 ORACLE CLUSTER 配置 .............................................................................................................................................. - 12 -

3.2.1 OCR/Voting Disk 检查 .......................................................................................................................................... - 12 -

3.2.2 Grid 资源和服务检查 ............................................................................................................................................ - 13 -

3.2.3 ASM 磁盘组属性 .................................................................................................................................................... - 14 -

3.2.4 ASM 磁盘组检查 .................................................................................................................................................... - 16 -

4 ORACLE

数据库检查

............................................................................................................................................. - 17 -

4.1 数据库实例一览 ............................................................................................................................................................ - 17 -

4.2 数据库版本信息 ............................................................................................................................................................ - 17 -

4.3 数据库组件和补丁情况 .............................................................................................................................................. - 17 -

4.4 补丁安装情况 ................................................................................................................................................................ - 18 -

4.5 RDBMS 参数文件 .......................................................................................................................................................... - 18 -

4.6 RDBMS 资源使用情况 ................................................................................................................................................ - 18 -

4.7 控制文件 ......................................................................................................................................................................... - 19 -

4.8 联机日志文件 ................................................................................................................................................................ - 19 -

4.9 归档 ARCHIVE LOG 文件 ................................................................................................................................................ - 20 -

4.10 数据库无效对象 ............................................................................................................................................................ - 20 -

4.11 表空间使用情况 ............................................................................................................................................................ - 20 -

4.12 数据库大小以及增长量 .............................................................................................................................................. - 21 -

Lucifer 有限公司

ORACLE 数据库 – 健康检查报告

- 3 -

4.13 TOP10 表 ......................................................................................................................................................................... - 21 -

4.14 TOP10 索引 ..................................................................................................................................................................... - 21 -

4.15 分区表扩展检查 ............................................................................................................................................................ - 21 -

4.16 使用 SYSTEM 作为默认用户表空间 ........................................................................................................................... - 21 -

4.17 AWR 和 SYSAUX 检查 ................................................................................................................................................. - 22 -

4.17.1 AWR 配置与检查 ............................................................................................................................................... - 22 -

4.17.2 SYSAUX 使用空间检查 .................................................................................................................................... - 22 -

4.18 数据库简单风险评估 ................................................................................................................................................... - 22 -

4.18.1 管理员用户密码检查 ........................................................................................................................................ - 22 -

4.18.2 应用用户信息 ..................................................................................................................................................... - 22 -

4.18.3 Profile 及密码过期检查 .................................................................................................................................. - 22 -

4.18.4 比特币勒索病毒检查 ........................................................................................................................................ - 23 -

4.19 自动收集任务检查 ....................................................................................................................................................... - 23 -

4.20 数据库性能评估 ............................................................................................................................................................ - 23 -

4.20.1 数据库总体负载 ................................................................................................................................................. - 23 -

4.20.2 每秒性能指标 ..................................................................................................................................................... - 24 -

4.20.3 命中率指标 .......................................................................................................................................................... - 25 -

4.20.4 Top10 等待事件 ................................................................................................................................................. - 25 -

4.20.5 时间模型 .............................................................................................................................................................. - 26 -

4.20.6 执行耗时 Top10 SQL ........................................................................................................................................ - 26 -

4.21 数据库性能概览 ............................................................................................................................................................ - 27 -

4.21.1 数据库忙碌指标分析 ........................................................................................................................................ - 27 -

4.21.2 登入及交易负载的表现情况 .......................................................................................................................... - 27 -

4.21.3 等待指标分析 ..................................................................................................................................................... - 29 -

4.22 数据库备份评估 ............................................................................................................................................................ - 30 -

4.22.1 当前 RMAN 备份情况 ...................................................................................................................................... - 30 -

4.23 数据库 ALERT 日志检查 ............................................................................................................................................... - 30 -

of 30

5墨值下载

oracle数据库 oracle巡检脚本演示

相关文档

评论