日志,Oracle定期删除日志文件"/>
oracle删除adr日志,Oracle定期删除日志文件
ADR Command Interpreter
ADRCI是一个命令行工具,是Oracle Database 11 g中引入的故障诊断基础结构的一部分。
ADRCI使您能够:
查看自动诊断存储库(ADR)中的诊断数据。
查看运行状况监视器报告。
将事件和问题信息打包到一个zip文件中,以传输给Oracle支持。
Oracle中经常会产生许多日志文件,导致操作系统空间紧张,需要经常清理,除了采用手工清理的方式,我们也可以通过ADRCI工具进行清理。
调用adrci
oracle/grid用户下直接调用的$ORACLE_HOME/bin/adrci工具
[oracle@racdb1 ~]:ora11g1[11g]$adrci
ADRCI: Release 11.2.0.4.0 - Production on Mon Mar 29 10:07:06 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"
adrci>
查看目录
grid:
adrci> show home
ADR Homes:
diag/asm/+asm/+ASM1
diag/crs/racdb1/crs
diag/clients/user_grid/host_805754952_110
diag/clients/user_root/host_805754952_110
diag/clients/user_oracle/host_805754952_110
diag/tnslsnr/racdb1/asmnet1lsnr_asm
diag/tnslsnr/racdb1/listener_scan1
diag/tnslsnr/racdb1/listener
diag/tnslsnr/racdb1/lsnrdg
diag/tnslsnr/racdb1/listener_dg
diag/asmtool/user_grid/host_805754952_110
diag/asmcmd/user_grid/racdb1
diag/asmcmd/user_oracle/racdb1
diag/kfod/racdb1/kfod
oracle:
adrci> show home
ADR Homes:
diag/rdbms/ypcdb/ypcdb1
diag/rdbms/racdb/racdb1
diag/rdbms/ora11g/ora11g1
diag/rdbms/ora11gn/ora11gn1
diag/rdbms/daxia/daxia
diag/rdbms/sddb/sddb1
diag/rdbms/unknown/ypcdb1
diag/rdbms/destdb/destdb1
diag/clients/user_oracle/host_805754952_110
diag/asmcmd/user_oracle/racdb1
diag/kfod/racdb1/kfod
查看帮助
adrci> help
HELP [topic]
Available Topics:
CREATE REPORT
ECHO
EXIT
HELP
HOST
IPS
PURGE
RUN
SET BASE
SET BROWSER
SET CONTROL
SET ECHO
SET EDITOR
SET HOMES | HOME | HOMEPATH
SET TERMOUT
SHOW ALERT
SHOW BASE
SHOW CONTROL
SHOW HM_RUN
SHOW HOMES | HOME | HOMEPATH
SHOW INCDIR
SHOW INCIDENT
SHOW PROBLEM
SHOW REPORT
SHOW TRACEFILE
SPOOL
There are other commands intended to be used directly by Oracle, type
"HELP EXTENDED" to see the list
关于PURGE命令
日志类型-type ALERT|INCIDENT|TRACE|CDUMP|HM|UTSCDMP|LOG
需要清理时间-age(分钟)
adrci> help purge
Usage: PURGE [-i { | } ] |
[-problem { | } ] |
[[-age ] |
[-size ] |
[-type {ALERT|INCIDENT|TRACE|CDUMP|HM|UTSCDMP|LOG} ]]
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]: Purge a single specified incident, or a range
of incidents.
[-problem id1 | id1 id2]: Purge a single specified problem, or a range
of problems.
[-age ]: Purge diagnostic data older than from the
ADR home, if the data is purgable.
[-size ]: Purge diagnostic data from the ADR home until the size
of the home reaches bytes.
[-type ALERT|INCIDENT|TRACE|CDUMP|HM|UTSCDMP|LOG]: Purge a specific
type of data.
Notes:
When purging by size, only INCIDENT, TRACE, CDUMP and UTSCDMP data
is considered.
Some data can not be purged (such as incidents in the 'tracked' state),
which means that the specified target size may not be reached in all cases.
Examples:
purge
purge -i 123 456
purge -age 60 -type incident
purge -size 10000000
删除1天前的alert
adrci> purge -age 3600 -type alert
DIA-48448: This command does not support multiple ADR homes
存在多个目录,需要手工设置目录地址
adrci> show home
ADR Homes:
diag/rdbms/ypcdb/ypcdb1
diag/rdbms/racdb/racdb1
diag/rdbms/ora11g/ora11g1
diag/rdbms/ora11gn/ora11gn1
diag/rdbms/daxia/daxia
diag/rdbms/sddb/sddb1
diag/rdbms/unknown/ypcdb1
diag/rdbms/destdb/destdb1
diag/clients/user_oracle/host_805754952_110
diag/asmcmd/user_oracle/racdb1
diag/kfod/racdb1/kfod
adrci> set home diag/rdbms/destdb/destdb1
adrci> purge -age 1400 -type alert
adrci> show alert
ADR Home = /u01/app/oracle/diag/rdbms/destdb/destdb1:
*************************************************************************
Output the results to file: /home/oracle/xtt/alert_104216_140393074140992_destdb1_5.ado
2021-03-28 03:22:49.993000 +08:00
Creating new log segment:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
注意:alert删除的 rdbms/destdb/destdb1/alert的文件而不是altersid.log文件
删除60分钟前的trace(trc/trm)
adrci> purge -age 60 -type trace
[oracle@racdb1 trace]:ora11g1[11g]$ls -tlr
total 1101856
-rw-r----- 1 oracle asmadmin 194042 Mar 23 14:59 drcdestdb1.log
-rw-r----- 1 oracle asmadmin 42584 Mar 29 11:31 destdb1_lms0_25910_25913.trm
-rw-r----- 1 oracle asmadmin 578277 Mar 29 11:31 destdb1_lms0_25910_25913.trc
-rw-r----- 1 oracle asmadmin 215643 Mar 29 11:35 destdb1_lg01_25937.trm
-rw-r----- 1 oracle asmadmin 1697929 Mar 29 11:35 destdb1_lg01_25937.trc
-rw-r----- 1 oracle asmadmin 106435 Mar 29 11:35 destdb1_arc3_26174.trm
-rw-r----- 1 oracle asmadmin 8907517 Mar 29 11:35 destdb1_arc3_26174.trc
-rw-r----- 1 oracle asmadmin 110317 Mar 29 11:35 destdb1_arc1_26168.trm
-rw-r----- 1 oracle asmadmin 9206562 Mar 29 11:35 destdb1_arc1_26168.trc
-rw-r----- 1 oracle asmadmin 6711814 Mar 29 11:36 alert_destdb1.log
-rw-r----- 1 oracle asmadmin 321664 Mar 29 11:36 destdb1_tt02_26182.trm
-rw-r----- 1 oracle asmadmin 50937045 Mar 29 11:36 destdb1_tt02_26182.trc
-rw-r----- 1 oracle asmadmin 107050 Mar 29 11:36 destdb1_arc2_26172.trm
-rw-r----- 1 oracle asmadmin 8973923 Mar 29 11:36 destdb1_arc2_26172.trc
-rw-r----- 1 oracle asmadmin 217433 Mar 29 11:36 destdb1_tt04_84290.trm
-rw-r----- 1 oracle asmadmin 13106288 Mar 29 11:36 destdb1_tt04_84290.trc
-rw-r----- 1 oracle asmadmin 22228 Mar 29 11:36 destdb1_ipc0_25866.trm
-rw-r----- 1 oracle asmadmin 90818 Mar 29 11:36 destdb1_ipc0_25866.trc
-rw-r----- 1 oracle asmadmin 2784 Mar 29 11:38 destdb1_m002_90451.trm
-rw-r----- 1 oracle asmadmin 17809 Mar 29 11:38 destdb1_m006_39012.trm
-rw-r----- 1 oracle asmadmin 272182 Mar 29 11:38 destdb1_m006_39012.trc
-rw-r----- 1 oracle asmadmin 32034 Mar 29 11:38 destdb1_m002_90451.trc
-rw-r----- 1 oracle asmadmin 4518 Mar 29 11:38 destdb1_m000_62120.trm
-rw-r----- 1 oracle asmadmin 60484 Mar 29 11:38 destdb1_m000_62120.trc
-rw-r----- 1 oracle asmadmin 595445 Mar 29 11:38 destdb1_rsm0_26150.trm
-rw-r----- 1 oracle asmadmin 13102735 Mar 29 11:38 destdb1_rsm0_26150.trc
-rw-r----- 1 oracle asmadmin 333650 Mar 29 11:38 destdb1_arc0_26165.trm
-rw-r----- 1 oracle asmadmin 31666316 Mar 29 11:38 destdb1_arc0_26165.trc
-rw-r----- 1 oracle asmadmin 234391 Mar 29 11:39 destdb1_tt05_49174.trm
-rw-r----- 1 oracle asmadmin 1984412 Mar 29 11:39 destdb1_tt05_49174.trc
-rw-r----- 1 oracle asmadmin 628907 Mar 29 11:39 destdb1_tmon_26025.trm
-rw-r----- 1 oracle asmadmin 284122890 Mar 29 11:39 destdb1_tmon_26025.trc
-rw-r----- 1 oracle asmadmin 492375 Mar 29 11:39 destdb1_tt01_26178.trm
-rw-r----- 1 oracle asmadmin 167673912 Mar 29 11:39 destdb1_tt01_26178.trc
-rw-r----- 1 oracle asmadmin 492976 Mar 29 11:39 destdb1_tt00_26163.trm
-rw-r----- 1 oracle asmadmin 54617691 Mar 29 11:39 destdb1_tt00_26163.trc
-rw-r----- 1 oracle asmadmin 3711 Mar 29 11:39 destdb1_m001_83647.trm
-rw-r----- 1 oracle asmadmin 48903 Mar 29 11:39 destdb1_m001_83647.trc
-rw-r----- 1 oracle asmadmin 1018 Mar 29 11:39 destdb1_m004_111731.trm
-rw-r----- 1 oracle asmadmin 2474 Mar 29 11:39 destdb1_m004_111731.trc
-rw-r----- 1 oracle asmadmin 2734771 Mar 29 11:39 destdb1_dbrm_25888.trm
-rw-r----- 1 oracle asmadmin 80508404 Mar 29 11:39 destdb1_dbrm_25888.trc
-rw-r----- 1 oracle asmadmin 867 Mar 29 11:39 destdb1_dia0_25900_base_1.trm
-rw-r----- 1 oracle asmadmin 2166 Mar 29 11:39 destdb1_dia0_25900_base_1.trc
-rw-r----- 1 oracle asmadmin 7651093 Mar 29 11:39 destdb1_lmhb_25915.trm
-rw-r----- 1 oracle asmadmin 89535398 Mar 29 11:39 destdb1_lmhb_25915.trc
-rw-r----- 1 oracle asmadmin 10799132 Mar 29 11:39 destdb1_lgwr_25927.trm
-rw-r----- 1 oracle asmadmin 100676410 Mar 29 11:39 destdb1_lgwr_25927.trc
-rw-r----- 1 oracle asmadmin 8942061 Mar 29 11:39 destdb1_lg00_25933.trm
-rw-r----- 1 oracle asmadmin 67691994 Mar 29 11:39 destdb1_lg00_25933.trc
[oracle@racdb1 trace]:ora11g1[11g]$date
Mon Mar 29 11:39:28 CST 2021
更多推荐
oracle删除adr日志,Oracle定期删除日志文件
发布评论