Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/11.2.0.3/policy/upgrade_delete_metrics.sql /st_emdbsa_11.2/1 2011/05/20 10:15:53 mpawelko Exp $
Rem
Rem upgrade_delete_metrics.sql
Rem
Rem Copyright (c) 2011, Oracle and/or its affiliates. All rights reserved. 
Rem
Rem    NAME
Rem      upgrade_delete_metrics.sql - Upgrade delete metrics script
Rem
Rem    DESCRIPTION
Rem       During 11.2.0.0...11.2.0.3 upgrade, delete affected metrics 
Rem       before recreating them
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.> 
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    mpawelko    05/17/11 - add SET DEFINE OFF/ON
Rem    mpawelko    05/02/11 - use delete_metric_metadata
Rem    mpawelko    04/28/11 - Created
Rem

SET DEFINE OFF

BEGIN

 BEGIN  
   MGMT_METRIC.DELETE_METRIC_METADATA(
       p_target_type => 'oracle_database',
       p_metric_name => 'DB_REDO_LOG_COUNT');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;
 END;

 BEGIN

   MGMT_METRIC.DELETE_METRIC_METADATA(
      p_target_type => 'rac_database',
      p_metric_name => 'DB_REDO_LOG_COUNT');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;

 END;

 BEGIN
   MGMT_METRIC.DELETE_METRIC_METADATA(
      p_target_type => 'rac_database',
      p_metric_name => 'DB_CONTROL_FILE_COUNT');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;

 END;

 BEGIN
   MGMT_METRIC.DELETE_METRIC_METADATA(
      p_target_type => 'oracle_database',
      p_metric_name => 'DB_CONTROL_FILE_COUNT');

   EXCEPTION
    WHEN MGMT_GLOBAL.NO_SUCH_METRIC_FOUND THEN
    NULL;

 END; 

 COMMIT;

END;
/

SET DEFINE ON