AWR Snaps Getting Generated From Wrong Host for RAC NODE 2 AFTER SWITCHOVER IN 12.2 (Doc ID 2599988.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• 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

   

Changes

After switchover from standby to primary, unable to see new primary host details for a particular RAC node.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.