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

合规检查_不合规项目明细表
主机名: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