自创网站,网站建设和运维单位责任,就要外贸人才网论坛,个人网页设计作品集分析https://docs.oracle.com/cd/E11882_01/server.112/e25494/diag.htm#ADMIN11007每当一个错误发生的时候#xff0c;oracle会创建一个incident#xff0c;并且分配一个INCIDENT_ID号#xff0c;同时在ADR HOME的INCIDENT目录中创建相应的INCIDENT 目录#xff0c;每个错误号…https://docs.oracle.com/cd/E11882_01/server.112/e25494/diag.htm#ADMIN11007每当一个错误发生的时候oracle会创建一个incident并且分配一个INCIDENT_ID号同时在ADR HOME的INCIDENT目录中创建相应的INCIDENT 目录每个错误号一个INCIDENT目录目录被命名为incdir_。在incident 目录下含有相应的DUMP文件。清理过程登录Oracle用户[rootywsjoracle ~]# su -oracle[oracleywsjoracle~]$进入Oracle的bin目录[oracleywsjoracle ~]$ cd /u01/11g/product/11.2.0/bin进入adrci工具界面[oracleywsjoracle bin]$ adrciADRCI: Release11.2.0.1.0 - Production on Tue Mar 5 09:39:22 2019Copyright (c)1982, 2009, Oracle and/or its affiliates. All rights reserved.ADR base /u01/11g查看Oracle目录并重新设定路径adrcishow homeADR Homes:diag/tnslsnr/ywsjoracle/listenerdiag/rdbms/orcl/orcladrci set homepath diag/rdbms/orcl/orcladrcishow homeADR Homes:diag/rdbms/orcl/orcl查看incident目录adrcishow incidentADR Home /u01/11g/diag/rdbms/orcl/orcl:*************************************************************************INCIDENT_ID PROBLEM_KEY CREATE_TIME-------------------- ----------------------------------------------------------- ----------------------------------------948432 ORA 445 2018-03-15 10:58:31.459000 08:00948433 ORA 445 2018-03-15 11:17:50.442000 08:00948608 ORA 445 2018-03-15 16:10:12.935000 08:00948434 ORA 445 2018-03-15 16:17:57.916000 08:00948435 ORA 445 2018-03-16 09:59:34.706000 08:00948384 ORA 445 2018-03-16 10:35:49.098000 08:00948436 ORA 445 2018-03-16 10:39:00.805000 08:00948609 ORA 445 2018-03-16 10:51:03.735000 08:00948385 ORA 445 2018-03-16 11:05:42.751000 08:00948437 ORA 445 2018-03-16 11:37:55.445000 08:00948438 ORA 445 2018-03-16 11:58:09.025000 08:00948439 ORA 445 2018-03-16 12:22:35.600000 08:00948386 ORA 445 2018-03-16 14:40:46.873000 08:001028260 ORA 445 2018-03-16 14:40:48.737000 08:001028261 ORA 445 2018-03-16 15:31:23.096000 08:001028262 ORA 445 2018-03-16 15:52:59.439000 08:00948387 ORA 445 2018-03-16 16:04:43.397000 08:00948424 ORA 445 2018-03-16 16:14:33.262000 08:001028263 ORA 445 2018-03-16 16:16:59.289000 08:00948610 ORA 445 2018-03-16 16:48:29.259000 08:00954192 ORA 3137 [12333] 2018-03-17 00:05:00.377000 08:00956240 ORA 3137 [12333] 2018-03-17 00:08:08.466000 08:00950664 ORA 3137 [12333] 2018-03-17 00:24:00.919000 08:00954448 ORA 3137 [12333] 2018-03-17 00:54:42.599000 08:00948388 ORA 445 2018-03-19 10:15:38.856000 08:00948389 ORA 445 2018-03-19 11:21:44.250000 08:00948425 ORA 445 2018-03-19 15:31:44.082000 08:001028264 ORA 445 2018-03-19 15:31:59.897000 08:00948390 ORA 445 2018-03-19 17:06:35.034000 08:001028265 ORA 445 2018-03-19 17:08:34.715000 08:001028266 ORA 445 2018-03-20 09:00:25.083000 08:001028267 ORA 445 2018-03-20 09:33:54.698000 08:00948391 ORA 445 2018-03-20 09:48:54.298000 08:001028272 ORA 445 2018-03-20 09:51:53.383000 08:001028273 ORA 445 2018-03-20 09:58:28.477000 08:001028277 ORA 445 2018-03-20 10:24:33.673000 08:001028274 ORA 445 2018-03-20 10:33:52.754000 08:001028278 ORA 445 2018-03-20 10:49:34.743000 08:001028275 ORA 445 2018-03-20 10:51:43.937000 08:001028279 ORA 445 2018-03-20 10:56:01.555000 08:001028276 ORA 445 2018-03-20 11:04:12.931000 08:001028280 ORA 445 2018-03-20 11:10:43.473000 08:001028285 ORA 445 2018-03-20 11:15:54.297000 08:00948426 ORA 445 2018-03-20 11:28:54.552000 08:001028286 ORA 445 2018-03-20 11:31:25.308000 08:001028287 ORA 445 2018-03-20 11:55:14.281000 08:001028288 ORA 445 2018-03-20 14:43:51.694000 08:00958496 ORA 3137 [3120] 2018-03-21 02:23:04.994000 08:001028314 ORA 445 2018-03-22 09:31:01.833000 08:001028302 ORA 445 2018-03-22 09:32:10.803000 08:00First50 rows fetched (*** more available ***)清理10天前的incident问题文件(10天 × 24小时 × 60分钟 14400秒)清理后exit命令退出adrci工具adrci purge -age 14400 -type incidentadrci exit清理情况如下
