Multiple DBID exist in dba_hist_wr_control
(Doc ID 2989623.1)
Last updated on MAY 02, 2024
Applies to:
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A to N/A [Release N/A]Information in this document applies to any platform.
Goal
Multiple DBID exist in dba_hist_wr_control in Data Guard on Exadata Cloud Service.
Also, multiple DBID are displayed when create AWR report.
SQL> select DBID,CON_ID,SRC_DBID,SRC_DBNAME from dba_hist_wr_control;
DBID CON_ID SRC_DBID SRC_DBNAME
---------- ---------- ---------- ---------------
2801609023 2232400006 standby
1055176825 2232400006 primary
2232400006 0 2232400006 CDB$ROOT
SQL> @?/rdbms/admin/awrrpt.sql
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ ---------- --------- ---------- ---------
2232400006 2 ORCLDB primary2 prim_host
2801609023 1 ORCLDB standby1 stby_host
2801609023 2 ORCLDB standby2 stby_host
* 2232400006 1 ORCLDB primary1 prim_host
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |