Skip to main content

How to Delete Old Trace & Dump files with ADRCI


The ADRCI command interpreter has multiple features:-
  • Create a package with incident or problem information for Oracle Support
  • Analyze diagnostic data within the Automatic Diagnostic Repository (ADR)
  • Run health checks
In this post, we'll be concentrating on deleting the old diagnostic files with ADRCI.
Set your environment and run the ADRCI utility:

$ adrci

Use the following command to list the ADR homes:

adrci> show home

ADR Homes:
diag/rdbms/db11g/DB11G
diag/tnslsnr/sol10/listener

Choose the ADR home from the list above:
adrci> set home diag/rdbms/db11g/DB11G
Check the current retention policy:

adrci> show control


Check the following columns in the output:
LONGP_POLICY:-
It is set to 365 days by default.
It is responsible for Incidents and Health Monitor warnings.
SHORTP_POLICY:-
It is set to 30 days by default.
It manages the trace and core dump files.

Use the following commands to change the retention policy:
Specify the time in hours: 10 Days = 240 , 1 Month = 744

adrci> set control (SHORTP_POLICY = 240)
adrci> set control (LONGP_POLICY = 1095)

Now you have the following choices to purge the old logs/traces:
1) Purge the old files manually:
 To delete manually you have to specify the retention period explicitly
Specify the time in minutes e.g 7 days old files is  7x24x60 = 10080
It is also possible to delete different diagnostic files separately

adrci> purge -age 10080 -type ALERT
adrci> purge -age 10080 -type TRACE
adrci> purge -age 10080 -type incident
adrci> purge -age 10080 -type hm
adrci> purge -age 10080 -type utscdmp
adrci> purge -age 10080 -type cdump

Also you may want to purge all files at once

adrci> purge -age 10080


2) Use autopurge option:
With just this command the current retention policy is applied.

adrci> purge

Comments

Post a Comment

Popular posts from this blog

Oracle Database 19c Step by Step Installation On Oracle Linux 7.6

This post describes the installation of Oracle Database 19c 64-bit on Oracle Linux 7.6  x86-64 bit. The Linux server needs a minimum of 3G swap and secure Linux set to permissive. An example of this type of Linux installation can be seen here . Download Software Download the Oracle software from oracle edelivery . Oracle Installation Prerequisites Automatic Setup Use the "oracle-database-preinstall-19c" package to perform all your prerequisite setup. # yum install -y oracle-database-preinstall-19c If you are using RHEL7 or CentOS7, you can pick up the PRM from the OL7 repository and install it. It will pull the dependencies from your normal repositories. # yum install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm Hosts File Set a fully qualified name for the server in the "/etc/hosts" file. < IP-address > < fully-qualified-machine-name > < machin...

Oracle Database 12C Error Codes, Solutions and Suggestions from ORA-19700 to ORA-20000

Oracle 12C Error Codes, Solutions and Suggestions from ORA 19700 to ORA 20000 ORA-19700: device type exceeds maximum length of string Cause:  The device type indicated is invalid. Action:  Supply a correct device type and retry the allocation. ORA-19701: device name exceeds maximum length of  string Cause:  The device name indicated is invalid. Action:  Supply a correct device name and retry the allocation. ORA-19702: device parameter exceeds maximum length of  string ORA-19703: device command string exceeds maximum length of  string Cause:  The device command string exceeds maximum length. Action:  Correct the command and retry the operation. ORA-19704: file name exceeds maximum length of  string Cause:  The specified file name, which was a parameter to a copy, backup, or restore operation, exceeds the maximum file name length for this operating system. Action:  Retry the operation with a s...