This post is part of a blog series.
With release 26ai, generating AWR reports from Active Data Guard standby databases is now simple and direct, without extra configuration required.
Previously, starting in version 12c Release 2, you had to set up DB links and use the Remote Management Framework (RMF) with the DBMS_UMF package to let the primary database collect remote AWR snapshots from standby databases. This process, documented in MOS note 2409808.1 How to Generate AWRs in Active Data Guard Standby Databases (now KB140685), was complex and could lead to non-working state, especially after failovers.
Now, you can generate reports right on the standby database. Because the standby is open read-only, we export snapshots to a dump file, transfer them internally to the primary using Data Guard communication, and import them there for reporting.
Latest posts by Ludovico (see all)
- Data Guard 26ai – #19: Easy AWR snapshots on the standby - February 25, 2026
- Data Guard 26ai – #18: PDB Recovery Isolation - February 23, 2026
- Data Guard 26ai – #17: Automatic standby tempfile creation - February 20, 2026