AWR Snaps Getting Generated From Wrong Host for RAC NODE 2 AFTER SWITCHOVER IN 12.2
(Doc ID 2599988.1)
Last updated on MAY 12, 2022
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
- Having a 4 node RAC. On node 2, the awr snaps are getting collected from the host which was old production before switchover in 12.2:
SQL> select distinct
2 ( case when cd.dbid = wr.dbid and
3 cd.name = wr.db_name and
4 ci.instance_number = wr.instance_number and
5 ci.instance_name = wr.instance_name
6 then '* '
7 else ' '
8 end) || wr.dbid dbbid
9 , wr.instance_number instt_num
10 , wr.db_name dbb_name
11 , wr.instance_name instt_name
12 , wr.host_name host
13 from dba_hist_database_instance wr, v$database cd, v$instance ci;
Does not show Node 2 host details.
select * from DBA_HIST_DATABASE_INSTANCE ORDER BY instance_number, startup_time; -- Does not show Node 2 host details
After switchover from standby to primary, unable to see new primary host details for a particular RAC node.
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