使用adrci清理日志：

[orauat@rhdbuat ~]$ adrci

ADRCI: Release 12.1.0.2.0 - Production on Fri Feb 25 15:11:26 2022

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/u01/oracle/ebsdb/12.1.0/admin/UAT_rhdbuat"
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 incident

adrci> show alert -tail
DIA-48449: Tail alert can only apply to single ADR home

adrci> show alert -tail
DIA-48449: Tail alert can only apply to single ADR home

adrci> select value from v$diag_info where name='DiagAlert';
DIA-48202: Illegal Identifier [4] [V$DIAG_INFO]

DIA-48202: Illegal Identifier [4] [V$DIAG_INFO]


ADR Home = /u01/oracle/ebsdb/12.1.0/admin/UAT_rhdbuat/diag/tnslsnr/rhdbuat/uat:
*************************************************************************
0 rows fetched

ADR Home = /u01/oracle/ebsdb/12.1.0/admin/UAT_rhdbuat/diag/rdbms/uat/UAT:
*************************************************************************
0 rows fetched

adrci> exit

[orauat@rhdbuat ~]$ adrci

ADRCI: Release 12.1.0.2.0 - Production on Fri Feb 25 15:32:54 2022

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/u01/oracle/ebsdb/12.1.0/admin/UAT_rhdbuat"
adrci> show homes;
ADR Homes: 
diag/tnslsnr/rhdbuat/uat
diag/rdbms/uat/UAT
adrci> show alert -tail
DIA-48449: Tail alert can only apply to single ADR home

adrci> puge purge -age 60 -type alert       
DIA-48415: Syntax error found in string [puge purge ] at column [11]

adrci> purge -age 60 -type alert;   
DIA-48448: This command does not support multiple ADR homes

adrci> set home /u01/oracle/ebsdb/12.1.0/admin/UAT_rhdbuat/diag/tnslsnr/rhdbuat/uat;                                                
DIA-48447: The input path [/u01/oracle/ebsdb/12.1.0/admin/UAT_rhdbuat/diag/tnslsnr/rhdbuat/uat] does not contain any ADR homes

adrci> show home;
ADR Homes: 
diag/tnslsnr/rhdbuat/uat
diag/rdbms/uat/UAT
adrci> set home diag/tnslsnr/rhdbuat/uat
adrci> purge -age 60 -type alert     
adrci> purge -age 60 -type trace
adrci> show home  
ADR Homes: 
diag/tnslsnr/rhdbuat/uat
adrci> purge -age 60 -type trace

清理完成之后查看对应alert目录的大小，如下图所示：

微信图片_20220225182252.png

接着清理trace日志：
alter system trace_enable=false
删除/u01/UAT/ebsdb/12.1.0/admin/TEST_testdb/diag/tnslsnr/testdb/uat/trace/=test.log
alter system trace_enable=true;重新启动数据库

image.png