4 Replies Latest reply: Sep 24, 2013 8:52 AM by mseberg RSS

    Switchover Status on Standby is NOT ALLOWED after a Switchback

    Jimbo

      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

          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

            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

              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

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