Here I'll show you how to clear this unnecessary information.
login into database with sysman user and execute this script:
SELECT t.target_name,
t.target_type,
collection_timestamp,
MESSAGE,
'exec em_severity.delete_current_severity('''
|| t.target_guid
|| ''','''
|| metric_guid
|| ''','''
|| key_value
|| ''')'
em_severity
FROM sysman.mgmt_targets t
INNER JOIN
sysman.mgmt_current_severity s
ON t.target_guid = s.target_guid;result:
after that run this scripts
SQL> exec em_severity.delete_current_severity('C894D538793FFA3B4727BCBCD84D4925',
'3F2BBE6BF105C0D16A3710F2868B8399','RECOVERY AREA');
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.same way you can clear entire alerts.

No comments:
Post a Comment