My Oracle Support Banner

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 later
Information 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:

SQL>select * from mgmt_purge_policy where policy_name = 'MGMT_AVAILABILITY';

Executing the following query shows the first record only from 6 months back despite the target is added a year ago.

select min(ah.start_collection_timestamp) as "First Record"
,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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.