标题: Retention Policy for ADR [打印本页] 作者: 郑全 时间: 2021-5-21 20:07 标题: Retention Policy for ADR Retention Policy for ADR (Doc ID 564269.1) To BottomTo Bottom
In this Document
Purpose
Scope
Details
References
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Oracle Database - Standard Edition - Version 11.1.0.6 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
*** Checked for relevance on 13-Mar-2013 ***
PURPOSE
The goal of this document is to explain the retention policies in Automatic Diagnostic Repository (ADR).
SCOPE
All DBAs working on 11g databases.
DETAILS
There are two time attributes which are used to manage the retention of information in ADR.
Both attributes correspond to a number of hours after which the MMON (Memory Monitor) background process removes the expired ADR data:
- SHORTP_POLICY : used to purge information that have a short life.
Default is 720 which corresponds to 30 days - approximately 1 month.
- LONGP_POLICY: to purge ADR contents that have a long life.
Default is 8760 = 365 days = 1 year.
To view and modify these settings, you can either use the Enterprise Manager 11g DB Control GUI or via the ADR Command Interpreter (ADRCI) started from an O/S prompt.
In this note, we will detail you how to check and change the above parameters via ADRCI.
As some of the ADRCI commands (like "show control") do not work with multiple current ADR homes, we need to first select the appropriate homepath:
% adrci
adrci> show home
ADR Homes:
diag/rdbms/<SID>/<SID>
...
adrci> set home <ADR HOME PATH>
To check the current values of SHORTP_POLICY and LONGP_POLICY :
adrci> show control
To set the retention policy values :
adrci> set control (SHORTP_POLICY = 3600)
To get help on the set control command :
adrci> help set control