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. RayanMarch 30, 2018 at 2:07 PM
    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. AnonymousApril 20, 2022 at 7:31 AM
    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. Randy TurnerOctober 10, 2024 at 1:58 AM
    What a breath of fresh air! Your enthusiasm and positivity are contagious. Thank you for spreading such good vibes!
    ReplyDelete
  4. DonaldSchlosserOctober 10, 2024 at 6:44 AM
    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. Anita CoxOctober 30, 2024 at 1:48 AM
    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









Active Directory Authentication with an Oracle Database




















Image







 Wouldn’t it be nice to not have to manage user passwords in your Oracle Databases? Setting up Active Directory aka Kerberos Authentication is a way to avoid having to manage passwords and allows users to authenticate against your Active Directory. Below is a list of useful links and My Oracle references that were used when setting up this example:   EDIT - This post gets a lot of hits so I will include some updated information. If you're on 12c you need to add kerberos5pre to your list of services. e.g.   SQLNET.AUTHENTICATION_SERVICES= (beq,kerberos5pre,kerberos5)  If you are an Oracle Support Customer check out How To Configure Kerberos Authentication In A 12c Database ( Doc ID 1996329.1 ). If not, here is a good 3rd party write up  https://wiki.loopback.org/display/KB/Oracle+Database+12c+Kerberos+Configuration        Master Note For Kerberos Authentication (Doc ID 1375853.1) Configuring ASO Kerberos Authentication with a Microsoft Windows 2008 R2 Active Directory KDC (Doc ...








Read more










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




















Image







Recently I was tasked to build out an OEM 13c instance to manage a few Oracle Database servers and their associated instances. As a part of the setup, I needed to generate a daily email report to confirm the backup status of all databases in the OEM inventory. Unfortunately, it seems Oracle has overlooked this in the default reports, so I had to create a custom report. Here's how this was accomplished.   The EM Repository database keeps track of the last database backup timestamp for each database. This is shown on the home page for any database. We can use this information to create a daily report and confirm that each database has been backed up in the last 24 hours.     Login the BI publisher site https://oemserver.yourdomain:9851/xmlpserver  with your account or sysman.    Near the top right corner click “catalog”.    In the tree on the left create a new folder under “Shared Folders” called custom reports.    Within the custom reports folder create a new folder called “custom d...








Read more










Oracle Enterprise Manager notify when Recovery Area low




















Image







I seem to be on the Oracle Enterprise manager kick lately, so why not one more post on it. Recently I hit the 85% mark on the Fast Recovery Area due to archive log bloat and did not see any alerts triggered in OEM. Well as I discovered, part of the reason for this is that according to MOS,    "If using Fast Recovery Area (FRA) for the archive destination and the destination is set to USE_DB_RECOVERY_FILE_DEST, then the Archive Area % Used metric will not trigger anymore."  Well that is annoying. However, I did find that the alert does trigger, but it is buried and doesn't show up on any main pages. To see it, go to the target database home page. Then navigate to Oracle Database->Monitoring->All Metrics . In the left pane you can scroll down to “ Recovery Area->Recovery Area Free Space ”.  There you will see your alert if active. When viewing the All Metrics page, click on the alerts icon to see active alerts.        If you want to see it triggered just temporaril...








Read more