我要评论介绍
oracle中通常有好多日志文件，遇到异常情况会产生大量日志，造成磁盘空间紧张。
故需要清理对应文件。包括trace文件，incident文件，listener log文件等
11g中oracle提供了一个adrci的命令行工具来查看adr中的alert日志和trace信息，可以批量删除对应的日志文件。
adrci的位置在$oracle_home/bin目录下
详细adrci介绍
1.删除incident文件
- 调用adrci
[root@prod-idm-storage incident]# adrci adrci: release 11.2.0.2.0 - production on tue may 7 15:19:08 2019 copyright (c) 1982, 2009, oracle and/or its affiliates. all rights reserved. adr base = "/app/oracle"
- 查看目录
adrci> show home adr homes: diag/rdbms/orcl/orcl
存在多个home需要指定单个hone进行操作
adrci> set homepath diag/rdbms/tyrz/tyrz
- 查看incident
adrci> show incident adr home = /app/oracle/diag/rdbms/orcl/orcl: ************************************************************************* incident_id problem_key create_time -------------------- ----------------------------------------------------------- ---------------------------------------- 243353 ora 227 2018-08-31 09:22:40.871000 +08:00 262554 ora 227 2018-08-31 09:34:26.395000 +08:00 339426 ora 1578 2018-09-22 06:01:46.329000 +08:00 339370 ora 1578 2018-09-22 10:07:49.852000 +08:00 339402 ora 1578 2018-09-22 14:08:23.558000 +08:00 339386 ora 1578 2018-09-22 18:08:47.587000 +08:00 339394 ora 1578 2018-09-22 22:09:26.524000 +08:00 339410 ora 1578 2018-09-23 06:01:17.392000 +08:00 339387 ora 1578 2018-09-23 10:10:58.257000 +08:00 339411 ora 1578 2018-09-23 14:11:21.786000 +08:00 339412 ora 1578 2018-09-23 18:11:59.186000 +08:00 339413 ora 1578 2018-09-23 22:12:19.998000 +08:00 339414 ora 1578 2018-09-24 22:01:20.661000 +08:00 339434 ora 1578 2018-09-25 22:01:21.496000 +08:00 339415 ora 1578 2018-09-26 22:01:09.127000 +08:00 339442 ora 1578 2018-09-27 22:01:26.124000 +08:00 339450 ora 1578 2018-09-28 22:01:21.893000 +08:00 339403 ora 1578 2018-09-29 06:01:25.350000 +08:00 339418 ora 1578 2018-09-29 10:07:14.940000 +08:00 339388 ora 1578 2018-09-29 14:07:53.091000 +08:00 339389 ora 1578 2018-09-29 18:08:10.510000 +08:00 339404 ora 1578 2018-09-29 22:08:50.151000 +08:00 339419 ora 1578 2018-09-30 06:01:15.858000 +08:00 339390 ora 1578 2018-09-30 10:10:21.898000 +08:00 339391 ora 1578 2018-09-30 14:10:47.874000 +08:00 339371 ora 1578 2018-09-30 18:11:24.833000 +08:00 339405 ora 1578 2018-09-30 22:11:47.994000 +08:00 339372 ora 1578 2018-10-01 22:01:17.620000 +08:00 339435 ora 1578 2018-10-02 22:01:30.078000 +08:00 339451 ora 1578 2018-10-03 22:01:23.725000 +08:00 339420 ora 1578 2018-10-04 22:01:21.404000 +08:00 339416 ora 1578 2018-10-05 22:01:15.775000 +08:00 339421 ora 1578 2018-10-06 06:01:29.564000 +08:00 339417 ora 1578 2018-10-06 10:08:21.342000 +08:00 339422 ora 1578 2018-10-06 14:08:52.711000 +08:00 345607 ora 1578 2018-10-06 18:09:17.919000 +08:00 345609 ora 1578 2018-10-06 22:09:56.154000 +08:00 339436 ora 1578 2018-10-07 06:01:18.502000 +08:00 339406 ora 1578 2018-10-07 10:01:23.514000 +08:00 339407 ora 1578 2018-10-07 14:01:46.542000 +08:00 339354 ora 1578 2018-10-07 18:02:21.533000 +08:00 339355 ora 1578 2018-10-07 22:02:45.654000 +08:00 339498 ora 1578 2018-10-08 22:01:23.626000 +08:00 339466 ora 1578 2018-10-09 22:01:21.970000 +08:00 339467 ora 1578 2018-10-10 22:01:11.649000 +08:00 339499 ora 1578 2018-10-11 22:01:17.955000 +08:00 339443 ora 1578 2018-10-12 22:01:24.071000 +08:00 339423 ora 1578 2018-10-13 06:01:17.901000 +08:00 339373 ora 1578 2018-10-13 10:06:37.319000 +08:00 339374 ora 1578 2018-10-13 14:07:14.910000 +08:00 first 50 rows fetched (*** more available ***)
- 删除100天前的incident 14400=60min*24*100
adrci>purge -age 144000 -type incident
- 退出
adrci> exit
- 帮助
adrci> help purge
usage: purge [[-i <id1> | <id1> <id2>] |
[-age <mins> [-type alert|incident|trace|cdump|hm|utscdmp]]]:
purpose: purge the diagnostic data in the current adr home. if no
option is specified, the default purging policy will be used.
options:
[-i id1 | id1 id2]: users can input a single incident id, or a
range of incidents to purge.
[-age <mins>]: users can specify the purging policy either to all
the diagnostic data or the specified type. the data older than <mins>
ago will be purged
[-type alert|incident|trace|cdump|hm|utscdmp]: users can specify what type of
data to be purged.
examples:
purge
purge -i 123 456
purge -age 60 -type incident2.删除listener log
3.删除trace
- 查看trace
adrci> show tracefile
diag/rdbms/oam/oam/trace/oam_vkrm_10487.trc
diag/rdbms/oam/oam/trace/oam_vkrm_6627.trc
diag/rdbms/oam/oam/trace/oam_j003_26131.trc
diag/rdbms/oam/oam/trace/oam_m000_404.trc
diag/rdbms/oam/oam/trace/oam_m000_20336.trc
diag/rdbms/oam/oam/trace/oam_w000_3502.trc
diag/rdbms/oam/oam/trace/oam_vkrm_31062.trc
diag/rdbms/oam/oam/trace/oam_m000_14702.trc
diag/rdbms/oam/oam/trace/oam_j000_949.trc
diag/rdbms/oam/oam/trace/oam_vkrm_28172.trc
diag/rdbms/oam/oam/trace/alert_oam.log
diag/rdbms/oam/oam/trace/oam_vkrm_12182.trc
diag/rdbms/oam/oam/trace/oam_w000_31588.trc
diag/rdbms/oam/oam/trace/oam_j000_6363.trc
diag/rdbms/oam/oam/trace/oam_w001_8741.trc
diag/rdbms/oam/oam/trace/oam_m000_15978.trc
diag/rdbms/oam/oam/trace/oam_vkrm_15883.trc
diag/rdbms/oam/oam/trace/oam_m000_5141.trc
diag/rdbms/oam/oam/trace/oam_j001_15641.trc
diag/rdbms/oam/oam/trace/oam_j000_21062.trc
diag/rdbms/oam/oam/trace/oam_m000_24268.trc
diag/rdbms/oam/oam/trace/oam_m000_21366.trc
diag/rdbms/oam/oam/trace/oam_vkrm_14072.trcadrci> purge -age 8760 -type trace
以上就是oracle使用adrci清理日志文件的操作指南(trace文件，incident文件，listener log文件)的详细内容，更多关于oracle adrci清理文件的资料请关注代码网其它相关文章！
发表评论