How purge old trace and dump files

Starting from release Oracle 11g was indroduced a new feature which allows:
1. Viewing the alert.log
2. The relation between incident & problem
3. Creation of Packages & ZIP files to send to Oracle Support
4. Purging old diagnostic files
This post we’ll be focusing on purging the old diagnostic files.
There is now a special command line utility dedicated for that purpose called adrci
(Automatic Diagnostic Repository Command Interpreter).
– Use the following command to list ADR homes:
ADRCI> show homes
Diag/rdbms/orcldb/ORCLDB1
– Check the current retention policy:
ADRCI> show control
LONGP_POLICY is set to 365 days by default
SHORTP_POLICY is set to 30 days by default
– To change the retention policy:
ADRCI> set control (shortp_policy = 720)
ADRCI> set control (longp_policy = 720)
( Specify time in hours: 720 = 30 days)

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *