Oracle Backup Report and UI Missing RMAN Job Due to Collection Timing Misalignment (4380245)

The Foglight backup report scheduled at 08:00 AM is missing one of the expected RMAN backup jobs — specifically, the ARCHIVELOG job that starts around 04:18 AM. RMAN logs confirm that three backup jobs run daily:

• ARCHIVELOG (~00:30 AM)
• DB FULL (~00:37 AM)
• ARCHIVELOG (~04:18 AM)

When the report is run manually after 08:25 AM, all three jobs are visible. This indicates a timing misalignment between job execution and data collection.

The RMAN job data is collected by the DBO_Backup_Jobs collector, which runs every 6 hours. However, the specific collection times depend on when the Oracle database agent was started. This means collection times can vary across systems and agents. For example, on one system, collections occurred at:

• 02:25 AM
• 08:25 AM

The 08:00 AM report likely uses data from the last completed collection, in this case, 02:25 AM, which occurred before the 04:18 AM ARCHIVELOG job started. As a result, that job is not included in the report.

To ensure all expected backup jobs are included in the report, users have two options:

1. Adjust the report schedule to run after the relevant collection (e.g., after 08:25 AM).
2. Increase the collection frequency of DBO_Backup_Jobs to reduce the gap between job execution and data availability.

Either approach will help align the report timing with the actual backup job execution and ensure complete visibility.