This discussion is archived
4 Replies Latest reply: Sep 24, 2013 6:52 AM by mseberg RSS

Switchover Status on Standby is NOT ALLOWED after a Switchback

Jimbo Explorer
Currently Being Moderated

Hi,

 

I have created a Primary & Physical Standby. I was able to successfully do a switchover. However when I do my switch back, my Standby is showinf a switchover_status of NOT ALLOWED

 

Any ideas what could be the problem. It seems strange I was able to a switchover but the switchback ( whilst it has worked i.e. my primary is once again my primary and my standby is once again my standby ) has left the switchover status of the standby as NOT ALLOWED.

 

Is there somwhere ( table or log ) that might provide a clue as to why the status is NOT ALLOWED ?

 

My listeners on both primary and standby server are running ok.

 

Any help greatly appreciated,

Jim

  • 1. Re: Switchover Status on Standby is NOT ALLOWED after a Switchback
    mseberg Guru
    Currently Being Moderated

    Hello;

     

    On the current primary force a log switch and then confirm the log transported and applied.

     

    You can use this script to check:

     

    Monitor Data Guard Transport

     

    If logs are moving and being applied check the status again.

     

    Best Regards

     

    mseberg

  • 2. Re: Switchover Status on Standby is NOT ALLOWED after a Switchback
    Jimbo Explorer
    Currently Being Moderated

    Logs are shipping and applying ok

     

    On my Primary

     

    DB_NAME    HOSTNAME       LOG_ARCHIVED LOG_APPLIED APPLIED_TIME   LOG_GAP

    ---------- -------------- ------------ ----------- -------------- -------

    PRIMARYP   LAB1                    135         135 24-SEP/14:29         0

     

    SQL> select switchover_status from v$database;

    SWITCHOVER_STATUS

    --------------------

    TO STANDBY

     

    However on my Standby

     

    SQL> select switchover_status from v$database;

    SWITCHOVER_STATUS
    --------------------
    NOT ALLOWED

     

    I though it was because my log_archive_dest_2 was set on my standby. However it does not matter if I have this set or not, the switchover_status remains as NOT ALLOWED regardsless.

     

    Any thoughts ?

    Jim

  • 3. Re: Switchover Status on Standby is NOT ALLOWED after a Switchback
    mseberg Guru
    Currently Being Moderated

    OK.

     

    Normal.

     

    My Primary Test

     

    export ORACLE_SID=PRIMARY

    /home/oracle:PRIMARY >sqlplus "/ as sysdba"

     

    SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 24 08:50:12 2013

     

    Copyright (c) 1982, 2011, Oracle. All rights reserved.

     

     

    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, OLAP, Data Mining and Real Application Testing options

     

    SQL> select switchover_status from v$database;

     

    SWITCHOVER_STATUS

    --------------------

    TO STANDBY

     

    SQL>

     

     

    My Standby Test

     

    export ORACLE_SID=STANDBY

    /home/oracle:STANDBY >sqlplus "/ as sysdba"

     

    SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 24 08:48:40 2013

     

    Copyright (c) 1982, 2011, Oracle. All rights reserved.

     

     

    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    With the Partitioning, OLAP, Data Mining and Real Application Testing options

     

    SQL> select switchover_status from v$database;

     

    SWITCHOVER_STATUS

    --------------------

    NOT ALLOWED

     

    SQL>

     

    You don't have an issue.   NOT ALLOWED should change to TO PRIMARY about half way into a switch.

     

    Best Regards

     

    mseberg

  • 4. Re: Switchover Status on Standby is NOT ALLOWED after a Switchback
    Jimbo Explorer
    Currently Being Moderated

    thanks - it looks as if the switchover command on the primary is when the standby changes its switchover_status from NOT ALLOWED

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points