Oracle Enterprise Manager Last Backup timestamp is incorrect

Oracle Enterprise Manager 13 has a nice feature that shows the last backup timestamp on the home page of each target database. You can see this info directly in the SYSMAN.MGMT$HA_BACKUP table of the EM repository database. However, sometimes you may notice that this time stamp is older than the latest current backup. To add to the confusion if you navigate to "Availability->Backup&Recovery ->Backup Reports, you will see the true current time stamp which doesn't align with the time stamp shown on the target page.

This is because the metric collection job that updates the SYSMAN.MGMT$HA_BACKUP table, only runs every 12 hours by default. At 12am/pm UTC. If you would like a particular target to update more frequently, you can use emcli. Example command shown below

./emcli modify_collection_schedule \
-targetType="oracle_database" \
-targetNames="MYDB" -collectionName="haconfig1_collection" \
-freqType="HOUR" -freqValue="1" -preview="N"


After successfully running this, the time stamp will update every hour on the hour. You can read more about it at Oracle Doc ID -  EM 12c: Enterprise Manager 12.1.0.2 Cloud Control Backup Timestamp increased to 12 Hours Compared to 1 Hour 11g Grid Control (Doc ID 1549322.1)

Comments

  1. This is a great post! I've referred back to it several times in looking for all data backup. It's incredibly helpful. Thanks!!

    ReplyDelete
  2. Oracle Enterprise Manager Last Backup Timestamp Is Incorrect >>>>> Download Now

    >>>>> Download Full

    Oracle Enterprise Manager Last Backup Timestamp Is Incorrect >>>>> Download LINK

    >>>>> Download Now

    Oracle Enterprise Manager Last Backup Timestamp Is Incorrect >>>>> Download Full

    >>>>> Download LINK pk

    ReplyDelete
  3. What a breath of fresh air! Your enthusiasm and positivity are contagious. Thank you for spreading such good vibes!

    ReplyDelete
  4. The incorrect last backup Tur Host timestamp in Oracle Enterprise Manager may indicate an issue with backup scheduling or reporting that needs to be investigated for accurate data management.






    ReplyDelete
  5. An incorrect last backup timestamp in Oracle Enterprise Manager can lead to confusion about data recovery points. Club Hosty
    offers troubleshooting tips to accurately verify and update backup timestamps for better data management.

    ReplyDelete

Post a Comment

Popular posts from this blog

Create a custom backup report with BI Publisher for Oracle Enterprise Manager/Cloud Control 13c

Active Directory Authentication with an Oracle Database

Oracle Enterprise Manager notify when Recovery Area low