收藏 分销(赏)
立即下载 开通VIP

ORACLE合规检查和健康检查不正常项目明细.doc

上传人：xrp****65 文档编号：9853356 上传时间：2025-04-10 格式：DOC 页数：6 大小：63KB
下载 相关 举报
ORACLE合规检查和健康检查不正常项目明细.doc_第1页
第1页 / 共6页
ORACLE合规检查和健康检查不正常项目明细.doc_第2页
第2页 / 共6页
点击查看更多>>
资源描述
合规检查_不合规项目明细表 主机名:bj1ecidb8     检查类别 检查项 说明 明细 配置信息 重做日志大小 正常：所有大小都一样，都在50M到1G之间 eciforg_std : LOGSIZE 500 500 500 500 500 500 6 rows selected. 配置信息 归档目录 正常－按照规范的目录不正常－不是按照规范的目录 eciforg_std : Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Database log mode Archive Mode Automatic archival Enabled Archive destination /home/db/oraarch Oldest online log sequence 3785 Next log sequence to archive 0 Current log sequence 3787 配置信息 监听端口listener port 正常－按照规定的端口(11521) 不正常－默认的端口 eciforg_std : listener port number: 1521 1521 配置信息 用户ulimit 正常－都为unlimited 不正常－不全是unlimited eciforg_std : time(seconds) unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes) 8192 memory(kbytes) unlimited coredump(blocks) 2097151 nofiles(descriptors) unlimited 命名规则 控制文件名 正常－按照规范的名称不正常－不是按照规范的名称 eciforg_std : NAME /home/db/oracle/oradata/eciforg/rcontrol1_512m /home/db/oracle/oradata/eciforg/rcontrol2_512m /home/db/oracle/oradata/eciforg/rcontrol3_512m 日志 alert日志   eciforg_std : ORA-00316: log 3 of thread 1, type 0 in header is not log file ORA-00312: online log 3 thread 1: '/home/db/oracle/oradata/eciforg/rlog1_3_1_512m' Errors in file /home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_245876.trc: ORA-00367: checksum error in log file header ORA-00316: log 4 of thread 2, type 0 in header is not log file ORA-00312: online log 4 thread 2: '/home/db/oracle/oradata/eciforg/rlog2_1_1_512m' Errors in file /home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_245876.trc: ORA-00367: checksum error in log file header ORA-00316: log 6 of thread 2, type 0 in header is not log file ORA-00312: online log 6 thread 2: '/home/db/oracle/oradata/eciforg/rlog2_3_1_512m' Errors in file /home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_245876.trc: ORA-00367: checksum error in log file header ORA-00316: log 8 of thread 2, type 0 in header is not log file ORA-00312: online log 8 thread 2: '/home/db/oracle/oradata/eciforg/rlog2_2_2_512m' Errors in file /home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_245876.trc: ORA-16037: user requested cancel of managed recovery operation Recovery interrupted! Errors in file /home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_245876.trc: ORA-16037: user requested cancel of managed recovery operation ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL... Errors in file /home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_151552.trc: ORA-16037: user requested cancel of managed recovery operation Recovery interrupted! Errors in file /home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_151552.trc: ORA-16037: user requested cancel of managed recovery operation Errors in file /home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_131130.trc: ORA-16037: user requested cancel of managed recovery operation Recovery interrupted! Errors in file /home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_131130.trc: ORA-16037: user requested cancel of managed recovery operation 日志 listener日志   eciforg_std : WARNING: Subscription for node down event still pending WARNING: Subscription for node down event still pending TNS-12514: TNS:listener does not currently know of service requested in connect descriptor WARNING: Subscription for node down event still pending WARNING: Subscription for node down event still pending WARNING: Subscription for node down event still pending WARNING: Subscription for node down event still pending WARNING: Subscription for node down event still pending WARNING: Subscription for node down event still pending WARNING: Subscription for node down event still pending WARNING: Subscription for node down event still pending 配置信息 临时表空间大小 正常：>=4G eciforg_std : 配置信息 UNDO表空间大小 正常：>=8G eciforg_std : 配置信息 用户环境配置 正常－按照规范的目录不正常－不是按照规范的目录 eciforg_std : ORACLE_BASE:/home/db/oracle ORACLE_HOME:/home/db/oracle/product/10.2.0 配置信息 在线日志目录 正常－按照规范的目录不正常－不是按照规范的目录 eciforg_std : MEMBER /home/db/oracle/oradata/eciforg/rlog1_1_1_512m /home/db/oracle/oradata/eciforg/rlog1_2_1_512m /home/db/oracle/oradata/eciforg/rlog1_3_1_512m /home/db/oracle/oradata/eciforg/rlog2_1_1_512m /home/db/oracle/oradata/eciforg/rlog2_2_2_512m /home/db/oracle/oradata/eciforg/rlog2_3_1_512m /home/db/oracle/oradata/eciforg/rlog2_1_2_512m /home/db/oracle/oradata/eciforg/rlog2_2_1_512m /home/db/oracle/oradata/eciforg/rlog1_1_2_512m /home/db/oracle/oradata/eciforg/rlog1_2_2_512m /home/db/oracle/oradata/eciforg/rlog1_3_2_512m MEMBER /home/db/oracle/oradata/eciforg/rlog2_3_2_512m /home/db/oracle/oradata/eciforg/rstb1_1_512m /home/db/oracle/oradata/eciforg/rstb1_2_512m /home/db/oracle/oradata/eciforg/rstb2_1_512m /home/db/oracle/oradata/eciforg/rstb2_2_512m /home/db/oracle/oradata/eciforg/rstb3_1_512m /home/db/oracle/oradata/eciforg/rstb3_2_512m /home/db/oracle/oradata/eciforg/rstb4_1_512m /home/db/oracle/oradata/eciforg/rstb4_2_512m /home/db/oracle/oradata/eciforg/rstb5_1_512m /home/db/oracle/oradata/eciforg/rstb5_2_512m MEMBER /home/db/oracle/oradata/eciforg/rstb6_1_512m /home/db/oracle/oradata/eciforg/rstb6_2_512m /home/db/oracle/oradata/eciforg/rstb7_1_512m /home/db/oracle/oradata/eciforg/rstb7_2_512m /home/db/oracle/oradata/eciforg/rstb8_1_512m /home/db/oracle/oradata/eciforg/rstb8_2_512m 28 rows selected. 命名规则 在线日志文件 正常－按照规范的名称不正常－不是按照规范的名称 eciforg_std : MEMBER /home/db/oracle/oradata/eciforg/rlog1_1_1_512m /home/db/oracle/oradata/eciforg/rlog1_2_1_512m /home/db/oracle/oradata/eciforg/rlog1_3_1_512m /home/db/oracle/oradata/eciforg/rlog2_1_1_512m /home/db/oracle/oradata/eciforg/rlog2_2_2_512m /home/db/oracle/oradata/eciforg/rlog2_3_1_512m /home/db/oracle/oradata/eciforg/rlog2_1_2_512m /home/db/oracle/oradata/eciforg/rlog2_2_1_512m /home/db/oracle/oradata/eciforg/rlog1_1_2_512m /home/db/oracle/oradata/eciforg/rlog1_2_2_512m /home/db/oracle/oradata/eciforg/rlog1_3_2_512m MEMBER /home/db/oracle/oradata/eciforg/rlog2_3_2_512m /home/db/oracle/oradata/eciforg/rstb1_1_512m /home/db/oracle/oradata/eciforg/rstb1_2_512m /home/db/oracle/oradata/eciforg/rstb2_1_512m /home/db/oracle/oradata/eciforg/rstb2_2_512m /home/db/oracle/oradata/eciforg/rstb3_1_512m /home/db/oracle/oradata/eciforg/rstb3_2_512m /home/db/oracle/oradata/eciforg/rstb4_1_512m /home/db/oracle/oradata/eciforg/rstb4_2_512m /home/db/oracle/oradata/eciforg/rstb5_1_512m /home/db/oracle/oradata/eciforg/rstb5_2_512m MEMBER /home/db/oracle/oradata/eciforg/rstb6_1_512m /home/db/oracle/oradata/eciforg/rstb6_2_512m /home/db/oracle/oradata/eciforg/rstb7_1_512m /home/db/oracle/oradata/eciforg/rstb7_2_512m /home/db/oracle/oradata/eciforg/rstb8_1_512m /home/db/oracle/oradata/eciforg/rstb8_2_512m 28 rows selected. 命名规则 sid命名格式 正常－按照规范的名称不正常－不是按照规范的名称 eciforg_std : NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ instance_name string eciforg_std 空间使用情况 system上是否有其他用户对象 正常－默认表空间不是system 不正常－默认表空间是system eciforg_std : select OWNER, SEGMENT_NAME, TABLESPACE_NAME FROM Dba_segments where tablespace_NAME='SYSTEM' and owner not in ('SYS','SYSTEM') * ERROR at line 1: ORA-01219: database not open: queries allowed on fixed tables/views only 空间使用情况 是否有用户默认表空间system 正常－system表空间上没有其它用户不正常－有其它用户 eciforg_std : 安全情况 是否默认密码已修改 正常－没有默认的密码不正常－有默认的密码 eciforg_std : 安全情况 是否授予普通用户DBA权限 正常－只有sys ,system外这两个超级用户有dba权限不正常，有其他的超级用户 eciforg_std : select 'dbausers',GRANTEE,GRANTED_ROLE from dba_role_privs where GRANTED_ROLE='DBA' and GRANTEE not in ('SYS','SYSTEM','SYSMAN') 命名规则 spfile 名 正常－按照规范的名称不正常－不是按照规范的名称 eciforg_std : NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ spfile string /home/db/oracle/oradata/ecifor g/rspfile01_512m 健康检查_不正常项目明细表 主机名:bj1ecidb8     检查类别 检查项 说明 明细 基本信息 数据库statistics 正常－不超过3个月 eciforg_std : SYSDATE STARTUP_TIME RUNTIME ------------------- ------------------- ---------- 2011-05-30 10:25:07 2011-05-20 21:18:23 10 运行状态 SGA信息(读命中率) 正常大于85% eciforg_std : CACHE HIT RATIO -446.2 目录空间 日志备份空间 正常－可以超过48小时的要求,日志备份目录足够大，能容纳2天产生的日志量 eciforg_std : 未设置归档模式 运行状态 日志切换频率 正常－在规定的切换时间范围内(高峰期>5分钟，通常情况小于15－20分钟) 不正常－超过规定的时间范围 eciforg_std : SWITCHTIME MAXI MINI -------------------------------- ---------- ---------- logswitch 30 -1950
展开阅读全文

开通  VIP会员、SVIP会员  优惠大
下载10份以上建议开通VIP会员
下载20份以上建议开通SVIP会员

开通VIP      成为共赢上传
相似文档                                   自信AI助手自信AI助手

当前位置：首页 > 教育专区 > 其他

移动网页_全站_页脚广告1

关于我们      便捷服务       自信AI       AI导航        抽奖活动

©2010-2025 宁波自信网络信息技术有限公司  版权所有

客服电话：4009-655-100  投诉/维权电话：18658249818

gongan.png浙公网安备33021202000488号   

icp.png浙ICP备2021020529号-1  |  浙B2-20240490  

关注我们 ：微信公众号    抖音    微博    LOFTER 

客服