Hi,
OEM version : 11.1.0.1
OEM Repository database version : 11.2.0.2
Agent version : 10.2.0.5
MGMT$DB_DATAFILES and MGMT$DB_TABLESPACES views are not sync with dba_data_files/dba_tablespaces and they are out of date. I'm trying to collect data for them manually using runcollection method.
References:
|
select distinct collection_timestamp ,target_name from MGMT$DB_DATAFILESwhere target_name='KAP'
SQL> /
COLLECTIO TARGET_NAME
--------- --------------------
28-JUL-14 KAP
orakap> ./emctl control agent runCollection KAP:oracle_database oracle_dbconfig
Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0.
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD runCollection completed successfully
orakap> ./emctl control agent runCollection KAP:oracle_database tbspAllocation
Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0.
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD runCollection completed successfully
orakap> ./emctl upload agent
Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0.
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD upload completed successfully
select distinct collection_timestamp ,target_name from MGMT$DB_DATAFILESwhere target_name='KAP'
SQL> /
COLLECTIO TARGET_NAME
--------- --------------------
07-OCT-14 KAP
After sometime collection timestamp rolled back to old time. I'm wondering how it is changing back to old status. Am I missing something ?
select distinct collection_timestamp ,target_name from MGMT$DB_DATAFILESwhere target_name='KAP'
SQL> /
COLLECTIO TARGET_NAME
--------- --------------------
28-JUL-14 KAP
Please advice and thanks in advance.