从RAC环境恢复的备库报警日志中有:Warnings WARNING: Clusterware is not configured

郑全

现象：

      通过RAC主库恢复了一个测试单机环境，在单机环境打开后，报警日志中，有这么一条日志：

WARNING: Clusterware not configured

解决：

     可以忽略，后面自动会消失

参考：

     

   

Alert Log Warnings WARNING: Clusterware is not configured After Switchover. (Doc ID 2807142.1)        


In this Document
Symptoms
Changes
Cause
Solution
References


Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.
Symptoms
Primary is Rac (2 node or 4 node)
Standby is Standalone none Rac.


Switchover was performed  and Original primary is Standby and Original Standby is now New Primary


Alert log of new Primary continuously throws






WARNING: Clusterware is not configured.
WARNING: Clusterware is not configured.
WARNING: Clusterware is not configured.



Changes



Cause
This is an Expected Behavior as the Old Standby and new Primary is Standalone and Non Rac.


So when it receives information about the other thread the background process CKPT and LGWR would disable those threads internally.
Once this change gets propagated to new Standby these Message will not longer be shown after few minutes.


  
Redo thread 2 internally disabled at seq 2222 (CKPT)   =============> it detects there is a thread 2 enabled and disables it
Wed Sep 08
WARNING: Clusterware is not configured.
WARNING: Clusterware is not configured.
Solution


These Messages are Ignorable and will disappear once the disable thread information is propogated to new Standby.


You can query v$thread on primary and standby to confirm the same





  select THREAD#, STATUS, ENABLED ,     GROUPS INSTANCE,open_time from v$thread;


  THREAD# STATUS ENABLED      GROUPS   INSTANCE                              OPEN_TIME
---------- ------ -------- ---------- ----------------------------- -------------- ---------- ------------------ --------- -------------- --------- --------------- --------- ------------------- -----
        1 OPEN        PUBLIC                 6         <name >                            08-SEP-21      
        2 CLOSED     PUBLIC                6       UNNAMED_INSTANCE_2