在MOS查詢一些問題是， 發現了一個清理日誌的指令碼，比較好用。 j具體可參考mos文件2081655.1。該指令碼具體命令如下：

``` shell
[root@rac19c soft]# ./purgeLogs -h
Usage:
     purgeLogs [ -days <days> [ -aud ] [ -lsnr ] ] |
               [ -orcl <days> [ -aud ] [ -lsnr ] ] |
               [ -tfa <days> ] | 
               [ -osw <days> ] | 
               [ -oda <days> ] | 
               [ -extra '<folder>':<days> | [, '<folder>':<days>] ]
               [ -automigrate ]
               [ -dryrun ]

purgeLogs OPTIONS
      -days  <days>             Purge orcl,tfa,osw,oda components logs & traces older then # days
      -orcl  <days>             Purge only GI/RDBMS logs & traces (Default 30 days)
      -tfa   <days>             Purge only TFA repository older then # days (Default 30 days)
      -osw   <days>             Purge only OSW archives older then # days (Default 30 days)
      -oda   <days>             Purge only ODA logs and trace older then # days (Default 30 days)
      -extra '<folder>':<days>  Purge only files in user specified folders (Default 30 days)
      -aud                      Purge Audit logs based on '-orcl <days>' option
      -lsnr                     It will force the cleanup of listeners log independently by the age
      -dryrun                   It will show the purge commands w/o execute them
      -automigrate              It will run the adrci schema migrate commands in case of DIA-49803
      -h                        Display this help and exit

Example:
       purgeLogs
       purgeLogs -days 20
       purgeLogs -orcl 50
       purgeLogs -orcl 50 -aud -lsnr
       purgeLogs -tfa  50
       purgeLogs -osw  20 -oda 10
       purgeLogs -orcl 20 -osw 20 -oda 10
       purgeLogs -orcl 20 -osw 20 -oda 10 -extra /tmp:10,/var/log:20
```

具體效果測試： 環境，rac19c
``` shell
[root@rac19c soft]# ./purgeLogs -days 20

│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
 purgeLogs version: 1.65
 Copyright (c) 2015-2020 Oracle and/or its affiliates.
 -------------------------------------------------------
 Author: Ruggero Citton <ruggero.citton>
 RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│

~~~~~~~~~~~~~~~~~~~~~~adrci GI purge started~~~~~~~~~~~~~~~~~~~~~~
2021-12-13 10:33:29: I Checking if this is an Oracle Restart environment
2021-12-13 10:33:30: I adrci GI purging diagnostic destination diag/kfod/rac19c/kfod
2021-12-13 10:33:30: I ... purging ALERT older than 20 days
2021-12-13 10:33:40: I ... purging INCIDENT older than 20 days
2021-12-13 10:33:40: I ... purging TRACE older than 20 days
2021-12-13 10:33:58: I ... purging CDUMP older than 20 days
2021-12-13 10:33:58: I ... purging STAGE older than 20 days
2021-12-13 10:33:58: I ... purging SWEEP older than 20 days
2021-12-13 10:33:58: I ... purging HM older than 20 days
2021-12-13 10:33:58: I ... purging UTSCDMP older than 20 days

2021-12-13 10:33:58: I adrci GI purging diagnostic destination diag/asmtool/user_root/host_113130551_110
2021-12-13 10:33:58: I ... purging ALERT older than 20 days
2021-12-13 10:33:58: I ... purging INCIDENT older than 20 days
2021-12-13 10:33:58: I ... purging TRACE older than 20 days
2021-12-13 10:33:58: I ... purging CDUMP older than 20 days
2021-12-13 10:33:58: I ... purging STAGE older than 20 days
2021-12-13 10:33:58: I ... purging SWEEP older than 20 days
2021-12-13 10:33:58: I ... purging HM older than 20 days
2021-12-13 10:33:59: I ... purging UTSCDMP older than 20 days

2021-12-13 10:33:59: I adrci GI purging diagnostic destination diag/asmtool/user_grid/host_113130551_110
2021-12-13 10:33:59: I ... purging ALERT older than 20 days
2021-12-13 10:33:59: I ... purging INCIDENT older than 20 days
2021-12-13 10:33:59: I ... purging TRACE older than 20 days
2021-12-13 10:33:59: I ... purging CDUMP older than 20 days
2021-12-13 10:33:59: I ... purging STAGE older than 20 days
2021-12-13 10:33:59: I ... purging SWEEP older than 20 days
2021-12-13 10:33:59: I ... purging HM older than 20 days
2021-12-13 10:33:59: I ... purging UTSCDMP older than 20 days

2021-12-13 10:33:59: I adrci GI purging diagnostic destination diag/afdboot/user_root/host_113130551_110
2021-12-13 10:33:59: I ... purging ALERT older than 20 days
2021-12-13 10:33:59: I ... purging INCIDENT older than 20 days
2021-12-13 10:33:59: I ... purging TRACE older than 20 days
2021-12-13 10:33:59: I ... purging CDUMP older than 20 days
2021-12-13 10:33:59: I ... purging STAGE older than 20 days
2021-12-13 10:33:59: I ... purging SWEEP older than 20 days
2021-12-13 10:33:59: I ... purging HM older than 20 days
2021-12-13 10:33:59: I ... purging UTSCDMP older than 20 days

2021-12-13 10:34:00: I adrci GI purging diagnostic destination diag/asmcmd/user_root/rac19c
2021-12-13 10:34:00: I ... purging ALERT older than 20 days
2021-12-13 10:34:00: W Not able to purge ALERT, due to error: 'DIA-49803: Purge not possible due to incompatible schema version'
2021-12-13 10:34:00: W skipping cleanup for homepath 'diag/asmcmd/user_root/rac19c'

2021-12-13 10:34:00: I adrci GI purging diagnostic destination diag/asmcmd/user_grid/rac19c
2021-12-13 10:34:00: I ... purging ALERT older than 20 days
2021-12-13 10:34:00: W Not able to purge ALERT, due to error: 'DIA-49803: Purge not possible due to incompatible schema version'
2021-12-13 10:34:00: W skipping cleanup for homepath 'diag/asmcmd/user_grid/rac19c'

2021-12-13 10:34:00: I adrci GI purging diagnostic destination diag/asmcmd/user_oracle/rac19c
2021-12-13 10:34:00: I ... purging ALERT older than 20 days
2021-12-13 10:34:00: W Not able to purge ALERT, due to error: 'DIA-49803: Purge not possible due to incompatible schema version'
2021-12-13 10:34:00: W skipping cleanup for homepath 'diag/asmcmd/user_oracle/rac19c'

2021-12-13 10:34:00: I adrci GI purging diagnostic destination diag/crs/rac19c/crs
2021-12-13 10:34:00: I ... purging ALERT older than 20 days
2021-12-13 10:34:02: I ... purging INCIDENT older than 20 days
2021-12-13 10:34:02: I ... purging TRACE older than 20 days
2021-12-13 10:34:02: I ... purging CDUMP older than 20 days
2021-12-13 10:34:02: I ... purging STAGE older than 20 days
2021-12-13 10:34:02: I ... purging SWEEP older than 20 days
2021-12-13 10:34:02: I ... purging HM older than 20 days
2021-12-13 10:34:03: I ... purging UTSCDMP older than 20 days

2021-12-13 10:34:03: I adrci GI purging diagnostic destination diag/clients/user_root/host_113130551_110
2021-12-13 10:34:03: I ... purging ALERT older than 20 days
2021-12-13 10:34:03: I ... purging INCIDENT older than 20 days
2021-12-13 10:34:03: I ... purging TRACE older than 20 days
2021-12-13 10:34:03: I ... purging CDUMP older than 20 days
2021-12-13 10:34:03: I ... purging STAGE older than 20 days
2021-12-13 10:34:03: I ... purging SWEEP older than 20 days
2021-12-13 10:34:03: I ... purging HM older than 20 days
2021-12-13 10:34:03: I ... purging UTSCDMP older than 20 days

2021-12-13 10:34:03: I adrci GI purging diagnostic destination diag/clients/user_grid/host_113130551_110
2021-12-13 10:34:03: I ... purging ALERT older than 20 days
2021-12-13 10:34:05: I ... purging INCIDENT older than 20 days
2021-12-13 10:34:06: I ... purging TRACE older than 20 days
2021-12-13 10:35:37: I ... purging CDUMP older than 20 days
2021-12-13 10:35:37: I ... purging STAGE older than 20 days
2021-12-13 10:35:37: I ... purging SWEEP older than 20 days
2021-12-13 10:35:37: I ... purging HM older than 20 days
2021-12-13 10:35:37: I ... purging UTSCDMP older than 20 days

2021-12-13 10:35:37: I adrci GI purging diagnostic destination diag/tnslsnr/rac19c/listener
2021-12-13 10:35:37: I ... purging ALERT older than 20 days
2021-12-13 10:35:37: I ... purging INCIDENT older than 20 days
2021-12-13 10:35:38: I ... purging TRACE older than 20 days
2021-12-13 10:35:38: I ... purging CDUMP older than 20 days
2021-12-13 10:35:38: I ... purging STAGE older than 20 days
2021-12-13 10:35:38: I ... purging SWEEP older than 20 days
2021-12-13 10:35:38: I ... purging HM older than 20 days
2021-12-13 10:35:38: I ... purging UTSCDMP older than 20 days

2021-12-13 10:35:38: I adrci GI purging diagnostic destination diag/tnslsnr/rac19c/listener_scan1
2021-12-13 10:35:38: I ... purging ALERT older than 20 days
2021-12-13 10:35:38: I ... purging INCIDENT older than 20 days
2021-12-13 10:35:38: I ... purging TRACE older than 20 days
2021-12-13 10:35:38: I ... purging CDUMP older than 20 days
2021-12-13 10:35:38: I ... purging STAGE older than 20 days
2021-12-13 10:35:38: I ... purging SWEEP older than 20 days
2021-12-13 10:35:39: I ... purging HM older than 20 days
2021-12-13 10:35:39: I ... purging UTSCDMP older than 20 days

2021-12-13 10:35:39: I adrci GI purging diagnostic destination diag/tnslsnr/rac19c/asmnet1lsnr_asm
2021-12-13 10:35:39: I ... purging ALERT older than 20 days
2021-12-13 10:35:39: I ... purging INCIDENT older than 20 days
2021-12-13 10:35:39: I ... purging TRACE older than 20 days
2021-12-13 10:35:39: I ... purging CDUMP older than 20 days
2021-12-13 10:35:39: I ... purging STAGE older than 20 days
2021-12-13 10:35:39: I ... purging SWEEP older than 20 days
2021-12-13 10:35:39: I ... purging HM older than 20 days
2021-12-13 10:35:39: I ... purging UTSCDMP older than 20 days

2021-12-13 10:35:39: I adrci GI purging diagnostic destination diag/asm/user_root/host_113130551_110
2021-12-13 10:35:39: I ... purging ALERT older than 20 days
2021-12-13 10:35:39: I ... purging INCIDENT older than 20 days
2021-12-13 10:35:39: I ... purging TRACE older than 20 days
2021-12-13 10:35:39: I ... purging CDUMP older than 20 days
2021-12-13 10:35:39: I ... purging STAGE older than 20 days
2021-12-13 10:35:40: I ... purging SWEEP older than 20 days
2021-12-13 10:35:40: I ... purging HM older than 20 days
2021-12-13 10:35:40: I ... purging UTSCDMP older than 20 days

2021-12-13 10:35:40: I adrci GI purging diagnostic destination diag/asm/user_grid/host_113130551_110
2021-12-13 10:35:40: I ... purging ALERT older than 20 days
2021-12-13 10:35:40: I ... purging INCIDENT older than 20 days
2021-12-13 10:35:40: I ... purging TRACE older than 20 days
2021-12-13 10:35:40: I ... purging CDUMP older than 20 days
2021-12-13 10:35:40: I ... purging STAGE older than 20 days
2021-12-13 10:35:40: I ... purging SWEEP older than 20 days
2021-12-13 10:35:40: I ... purging HM older than 20 days
2021-12-13 10:35:40: I ... purging UTSCDMP older than 20 days

2021-12-13 10:35:40: I adrci GI purging diagnostic destination diag/asm/+asm/+ASM1
2021-12-13 10:35:40: I ... purging ALERT older than 20 days
2021-12-13 10:35:42: I ... purging INCIDENT older than 20 days
2021-12-13 10:35:46: I ... purging TRACE older than 20 days
2021-12-13 10:35:46: I ... purging CDUMP older than 20 days
2021-12-13 10:35:46: I ... purging STAGE older than 20 days
2021-12-13 10:35:46: I ... purging SWEEP older than 20 days
2021-12-13 10:35:46: I ... purging HM older than 20 days

2021-12-13 10:36:43: I ... purging UTSCDMP older than 20 days

~~~~~~~~~~~~~~~~~~GPNP purge started~~~~~~~~~~~~~~~~~~
2021-12-13 10:36:44: I Purging GPNP client logs older then 20 days

~~~~~~~~~~~~~~~~~~ACFS purge started~~~~~~~~~~~~~~~~~~
2021-12-13 10:36:47: I Purging ACFS logs older then 20 days

~~~~~~~~~~~~~~~~~~~~~~adrci RDBMS purge started~~~~~~~~~~~~~~~~~~~~~~
2021-12-13 10:36:48: I Getting dbhome for 'testdb'
2021-12-13 10:36:54: I adrci RDBMS purging diagnostic destination diag/rdbms/testdb/testdb1
2021-12-13 10:36:54: I ... purging ALERT older than 20 days
2021-12-13 10:36:56: I ... purging INCIDENT older than 20 days
2021-12-13 10:36:59: I ... purging TRACE older than 20 days
2021-12-13 10:40:22: I ... purging CDUMP older than 20 days
2021-12-13 10:40:23: I ... purging HM older than 20 days
2021-12-13 10:40:55: I ... purging STAGE older than 20 days
2021-12-13 10:40:56: I ... purging SWEEP older than 20 days
2021-12-13 10:40:56: I ... purging UTSCDMP older than 20 days

~~~~~~~~~~~~~~~~~TFA purge started~~~~~~~~~~~~~~~~~
2021-12-13 10:40:57: I Purging TFA archives older then 20 days

~~~~~~~~~~~~~~~~~~~~~~ODA OSW purge started~~~~~~~~~~~~~~~~~~~~~~
2021-12-13 10:41:00: W Path /opt/oracle/oak/oswbb/archive does not exist, ODA OSW archive cleanup skipped...

~~~~~~~~~~~~~~~~~~~~~~ExaWatcher purge started~~~~~~~~~~~~~~~~~~~~~~
2021-12-13 10:41:00: W Path /opt/oracle.ExaWatcher/archive does not exist, ExaWatcher archive cleanup skipped...

~~~~~~~~~~~~~~~~~~~~~~ODA OAK purge started~~~~~~~~~~~~~~~~~~~~~~
2021-12-13 10:41:00: W Path /opt/oracle/oak/log does not exist, ODA OAK logs cleanup skipped...

~~~~~~~~~~~~~~~~~~~~~~ODA DCS purge started~~~~~~~~~~~~~~~~~~~~~~
2021-12-13 10:41:00: W Path /opt/oracle/dcs/log does not exist, ODA DCS logs cleanup skipped...
2021-12-13 10:41:00: S Purging completed succesfully!

-----------------------------------------------------------------------
Above warning 'DIA-49803' could be solved executing following commands:
export ORACLE_HOME=/u01/app/19.0.0/grid;/u01/app/19.0.0/grid/bin/adrci exec="set homepath diag/asmcmd/user_root/rac19c; migrate schema"
su grid -c 'export ORACLE_HOME=/u01/app/19.0.0/grid;/u01/app/19.0.0/grid/bin/adrci exec="set homepath diag/asmcmd/user_grid/rac19c; migrate schema"'
su oracle -c 'export ORACLE_HOME=/u01/app/19.0.0/grid;/u01/app/19.0.0/grid/bin/adrci exec="set homepath diag/asmcmd/user_oracle/rac19c; migrate schema"'
```</ruggero.citton></days></days></folder></days></days></days></days></days></days></folder></days></folder></days></days></days></days></days>

【LOG】Oracle資料庫清理日誌、跟蹤檔案利器

相關文章