EM 13c: Availability History Of Targets is Available Only for 6 months Despite the Retention Policy Is Not Set for MGMT_AVAILABILITY
(Doc ID 2690364.1)
Last updated on JULY 14, 2020
Applies to:
Enterprise Manager for Oracle Database - Version 13.2.2.0.0 and laterInformation in this document applies to any platform.
Symptoms
Availability History Of Targets is Available Only for the last 6 months Despite the Retention Policy Is Not Set for MGMT_AVAILABILITY.
One may assume that if there is no retention policy for MGMT_AVAILABILITY, history of the target availability will remain in the repository database since the time of creation.
Retention policy on MGMT_AVAILABILITY can be verified from the repository database using the following query:
Executing the following query shows the first record only from 6 months back despite the target is added a year ago.
,t.target_name
,t.creation_date as "Target Creation Date" from
EM_AVAILABILITY_E ah, mgmt$target t
where 1=1 and ah.target_guid = t.target_guid
and t.target_name like 'middle_%'
and t.target_type = 'oracle_database'
group by t.target_name, t.creation_date
order by 1;
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |