Re: AWR report looks same for primary and standby database

You'll need at least 12.2 and Note 2409808.1 to configure AWR reporting for an Active Data Guard standby.

On Thu, Aug 11, 2022 at 11:16 AM yudhi s <learnerdatabase99_at_gmail.com> wrote:

> Hello All, This is version 12c Oracle database and oem is "Enterprise
> ManagerCloud Control 13c" and its a Exadata system. We have read-only
> standby database configured using data-guard. The standby database is
> currently serving some of the reporting jobs which are read-only types. We
> have a requirement to see how much load those jobs are putting on the
> standby database and if we can run some of those back on primary.
>
> While fetching the AWR report to see the standby database stats and its
> storage cell related usage statistics, we are seeing all the statistics are
> same as primary for a specific snap duration. Even the host name is showing
> as that of primary. So it means they(AWR data) were copied from primary and
> shipped to standby same as transaction data. So wanted to understand is
> there any specific configuration require to pull only standby database
> related AWR reports from oem and related exadata storage cell statistics?
>
> Regards
> Yudhi
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l