Delete Old Trace file & Alert log older in RAC or Single Instance

-

 

Recommended Trace File Retention Policy for Production

Trace TypeSuggested RetentionNotes
.trc / .trm     7–30 daysBasic diagnostic traces. 30 days if enough disk, else 7–14 days is typical.
Alert log30–90 daysRotate or archive regularly (text or XML version).
Listener logs14–30 daysEspecially if logging is verbose.
Audit logs30–90 daysDepends on compliance/security requirements.

bash-4.3$ du -sg *
0.07    alert
0.00    cdump
0.00    hm
4.77    incident
0.00    incpkg
0.00    ir
0.00    lck
0.00    log
0.01    metadata
0.00    metadata_dgif
0.00    metadata_pv
0.00    stage
0.00    sweep
71.50   trace

bash-4.3$ adrci

ADRCI: Release 19.0.0.0.0 - Production on Tue Jun 24 23:01:07 2025

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

ADR base = "/u01/app/oracle"

adrci> set home diag/rdbms/testdb/testdb1

adrci> show homes
ADR Homes:
diag/rdbms/testdb/testdb1


# NOTE :  (43200 minutes = 30 days) , (86400 minutes = 60 days)

adrci> purge -age 86400

adrci> purge -age 86400 -type trace




For RAC
------------- 

Apply the same in all nodes


Comments

Post a Comment

Popular posts from this blog

Enabling Autostart during server reboot of Oracle Database 19c filesystem on Oracle / Redhat Linux 7

-
============= Create a file /etc/init.d/dbora using dbora ================ vi /etc/init.d/dbora #! /bin/sh  -x # # This is my old script for auto-starting Oracle DB on Linux. # When I'm not using Cloud Databases, I now install the Oracle Database 21c RPM which includes its own script # # chkconfig: 2345 80 05 # description: start and stop Oracle Databases # # OL7: systemctl enable dbora # # Note: #   Change the awk pattern to match a DB of the ORACLE_HOME to be used #   Change the autostart entry of /etc/oratab to Y for any DB you want started; this is required by dbstart ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1 # Note: Change the value of ORACLE to the login name of the oracle owner ORACLE=oracle PATH=${PATH}:$ORACLE_HOME/bin export ORACLE_HOME PATH case $1 in 'start')         echo -n $"Starting Oracle: "         su $ORACLE -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME" &         ;; 'stop') ...
Read more

Management of Users and privilleges in Oracle Database 12c / 19c in container & Pluggable database

-
 [oracle@LNX-D1V-ORCL01 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Fri Mar 15 07:59:58 2024 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle.  All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> show pdbs;     CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 PDB                            READ WRITE NO   Create the common user using the CONTAINER clause SQL> create user c##user1 identified by c##user1 container=all; User created. SQL> grant create session to c#...
Read more

Oracle Temporary Tablespace Resize

-
  Description:- In this article I'm going to see how to resize Temp Tablespace on PDB database level Demo:- Login in to PDB Database SQL> alter session set container=ORCLPDB; Session altered. First Check Temporary Tablespace Usage From PDB Level:- SELECT A.tablespace_name tablespace, D.GB_total,SUM (A.used_blocks * D.block_size) / 1024 / 1024 / 1024 GB_used,D.GB_total , SUM (A.used_blocks * D.block_size) / 1024 / 1024 / 1024 GB_free FROM v$sort_segment A, ( SELECT B.name, C.block_size, SUM (C.bytes) / 1024 / 1024 / 1024 GB_total FROM v$tablespace B, v$tempfile C WHERE B.ts#= C.ts# GROUP BY B.name, C.block_size ) D WHERE A.tablespace_name = D.name GROUP by A.tablespace_name, D.GB_total; TABLESPACE GB_TOTAL GB_USED GB_FREE —————————— ———- ———- ———- TEMP               .034179688            0             .034179688 From CDB level:- To find CDB and PDB temporary tablespace files s...
Read more