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

《ORACLE合规检查和健康检查不正常项目明细》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、合规检查_不合规项目明细表主机名:bj1ecidb8    检查类别检查项说明明细配置信息重做日志大小正常：所有大小都一样，都在50M到1G之间eciforg_std:LOGSIZE5005005005005005006rowsselected.配置信息归档目录正常－按照规范的目录不正常－不是按照规范的目录eciforg_std:OracleDatabase10gEnterpriseEditionRelease10.2.0.4.0-64bitProductionWiththePartitioning,OLAP,DataMiningandR

2、ealApplicationTestingoptionsDatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestination/home/db/oraarchOldestonlinelogsequence3785Nextlogsequencetoarchive0Currentlogsequence3787配置信息监听端口listenerport正常－按照规定的端口(11521)不正常－默认的端口eciforg_std:listenerportnumber:15211521配

3、置信息用户ulimit正常－都为unlimited不正常－不全是unlimitedeciforg_std:time(seconds)unlimitedfile(blocks)unlimiteddata(kbytes)unlimitedstack(kbytes)8192memory(kbytes)unlimitedcoredump(blocks)2097151nofiles(descriptors)unlimited命名规则控制文件名eciforg_std:NAME/home/db/oracle/oradata/eciforg/rcontr

4、ol1_512m/home/db/oracle/oradata/eciforg/rcontrol2_512m正常－按照规范的名称不正常－不是按照规范的名称/home/db/oracle/oradata/eciforg/rcontrol3_512m日志alert日志 eciforg_std:ORA-00316:log3ofthread1,type0inheaderisnotlogfileORA-00312:onlinelog3thread1:'/home/db/oracle/oradata/eciforg/rlog1_3_1_512m'Er

5、rorsinfile/home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_245876.trc:ORA-00367:checksumerrorinlogfileheaderORA-00316:log4ofthread2,type0inheaderisnotlogfileORA-00312:onlinelog4thread2:'/home/db/oracle/oradata/eciforg/rlog2_1_1_512m'Errorsinfile/home/db/oracle/adm

6、in/eciforg_std/bdump/eciforg_std_mrp0_245876.trc:ORA-00367:checksumerrorinlogfileheaderORA-00316:log6ofthread2,type0inheaderisnotlogfileORA-00312:onlinelog6thread2:'/home/db/oracle/oradata/eciforg/rlog2_3_1_512m'Errorsinfile/home/db/oracle/admin/eciforg_std/bdump/eciforg_

7、std_mrp0_245876.trc:ORA-00367:checksumerrorinlogfileheaderORA-00316:log8ofthread2,type0inheaderisnotlogfileORA-00312:onlinelog8thread2:'/home/db/oracle/oradata/eciforg/rlog2_2_2_512m'Errorsinfile/home/db/oracle/admin/eciforg_std/bdump/eciforg_std_mrp0_245876.trc:ORA-16037

8、:userrequestedcancelofmanagedrecoveryoperationRecoveryinterrupted!Errorsinfile/home/db/oracle/ad