14 Replies Latest reply: May 16, 2013 1:13 AM by j_DBA_sourav RSS

    Primary database switchover problem

    Madhu.149
      I am getting the following error when i execute 'alter database commit to switchover to standby with session shutdown' in primary database

      ora-16416 no viable physical standby switchover targets available

      What may be the reason???

      I am using Oracle Server-Standard Edition 11g R2
      version: 11.2.0.1
        • 1. Re: Primary database switchover problem
          Helios-GunesEROL
          Hi;

          Please see:
          ORA-16416 Switchover Target Is Not Synchronized With The Primary [ID 753766.1]
          Bug 8287155 - Final gap error (ORA-16416) reported during switchover to standby [ID 8287155.8]

          Regard
          Helios
          • 2. Re: Primary database switchover problem
            Shivananda Rao
            Hi,

            Please post the following from the primary database:

            Primary:
            select switchover_status from v$database;
            • 3. Re: Primary database switchover problem
              Madhu.149
              in primary

              Switchover_status
              ------------------------
              NOT ALLOWED


              in standby


              Switchover_status
              ------------------------
              to primary
              • 4. Re: Primary database switchover problem
                Helios-GunesEROL
                Hi;

                Please see:
                Physical Standby Switchover_status Showing Not Allowed. [ID 1392763.1]

                Regard
                Helios
                • 5. Re: Primary database switchover problem
                  Shivananda Rao
                  Please post from the primary and standby databases:

                  Primary:
                  select max(sequence#) from v$archived_log;
                  Standby:
                  select max(sequence#) from v$archived_log where applied='YES';
                  select process,status,sequence# from v$managed_standby;
                  • 6. Re: Primary database switchover problem
                    mseberg
                    What may be the reason???
                    Oracle Server-Standard Edition 11g R2

                    Source - Data Guard Concepts and Administration 11g Release 2 (11.2) E10700-02


                    2.3.2 Oracle Software Requirements

                    "It is possible to simulate a standby database environment with databases running Oracle Database Standard Edition"

                    But I have doubts about trying a switchover without additional changes to the environment.

                    Sorry.

                    Best Regards

                    mseberg
                    • 7. Re: Primary database switchover problem
                      CKPT
                      Madhu.149 wrote:
                      I am getting the following error when i execute 'alter database commit to switchover to standby with session shutdown' in primary database

                      ora-16416 no viable physical standby switchover targets available

                      What may be the reason???

                      I am using Oracle Server-Standard Edition 11g R2
                      version: 11.2.0.1
                      Agreed with Mseberg.
                      Standard edition wont support any features like Switchover, Arch/Redo transport.
                      Have you configured only standby where archives will be transferred manually & applied? even still you cant perform switchover.
                      • 8. Re: Primary database switchover problem
                        Karan
                        Not Allowed must be the answer.. also mentioned above its standard edition, so it wont be possible, still for your confirmation you make try your hands on broker but before that read doc for standard edition, it should be mentioned there...

                        Regards
                        Karan
                        • 9. Re: Primary database switchover problem
                          420678
                          Oracle Standard Edition does not support Data Guard and as such does not support feature such as Primary and Standby Switchover.
                          If you want to use Data Guard like functionality in Oracle Standard edition with features such as Primary and Standby Switchover, then look at a product called Dbvisit Standby.

                          Here is a review from oracle-base.com on Dbvisit Standby: http://www.oracle-base.com/articles/misc/dbvisit-standby.php

                          Regards, Arjen
                          • 10. Re: Primary database switchover problem
                            Madhu.149
                            sorry for late response
                            Standard edition wont support any features like Switchover, Arch/Redo transport.
                            Have you configured only standby where archives will be transferred manually & applied? even still you cant perform switchover.
                            So, finally i can come to a conclusion that, switchover is not possible in standard edition

                            I am generating archive in primary, and transferring it manually to standby.
                            Is switchover related to dataguard?
                            Also, Is switchover possible without dataguard setup.

                            Earlier, in my standby database, switchover_status was 'to primary'. But after I applied archive log, the switchover_status became 'Not allowed'

                            And the statement, 'ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY' always results in error in primary.
                            • 11. Re: Primary database switchover problem
                              CKPT
                              Madhu.149 wrote:
                              sorry for late response
                              Standard edition wont support any features like Switchover, Arch/Redo transport.
                              Have you configured only standby where archives will be transferred manually & applied? even still you cant perform switchover.
                              So, finally i can come to a conclusion that, switchover is not possible in standard edition

                              I am generating archive in primary, and transferring it manually to standby.
                              Is switchover related to dataguard?
                              Also, Is switchover possible without dataguard setup.
                              Yes, its not possible. this feature applicable only for Enterprise Edition and Switchover related to DataGuard. Switchover not possible with standard edition.

                              Earlier, in my standby database, switchover_status was 'to primary'. But after I applied archive log, the switchover_status became 'Not allowed'
                              And the statement, 'ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY' always results in error in primary.
                              Its because of there is no standby database in the dataguard configuration of primary to switch from primary to standby and vice versa. So this is an expected behavior.
                              • 12. Re: Primary database switchover problem
                                Madhu.149
                                Thank you very much for your assistance.

                                One more thing.. I noticed today
                                When I manually applied log by using "ALTER DATABASE REGISTER LOGFILE '' " I am getting error as
                                ORA-00439 Feature not enabled
                                • 13. Re: Primary database switchover problem
                                  CKPT
                                  Madhu.149 wrote:
                                  Thank you very much for your assistance.

                                  One more thing.. I noticed today
                                  When I manually applied log by using "ALTER DATABASE REGISTER LOGFILE '' " I am getting error as
                                  ORA-00439 Feature not enabled
                                  Can you post complete errors associated with it and command with output?
                                  • 14. Re: Primary database switchover problem
                                    j_DBA_sourav
                                    Hello Gurus,

                                    I did a switchover and then performed a reverse switchover again. So Primary(original) is Primary now and My Standby(original) is Standby now.
                                    The Problem is when I monitor the Logs Archived and Applied I noticed below:

                                    In PRIMARY SIDE

                                    NAME ARC APPLIED SEQUENCE# DEST_ID
                                    ---------------------------------------- --- --------- ---------- ----------
                                    D:\EDRIVE\PRIMARY\ARC\1_55_815075358.ARC YES YES 55 1
                                    D:\EDRIVE\PRIMARY\ARC\1_56_815075358.ARC YES YES 56 1
                                    STANDBY YES YES 56 2
                                    STANDBY YES YES 55 2
                                    STANDBY YES YES 54 2
                                    STANDBY YES YES 53 2
                                    STANDBY YES YES 52 2
                                    STANDBY YES YES 50 2
                                    STANDBY YES YES 51 2
                                    STANDBY YES YES 57 2
                                    D:\EDRIVE\PRIMARY\ARC\1_57_815075358.ARC YES YES 57 1
                                    D:\EDRIVE\PRIMARY\ARC\1_58_815075358.ARC YES YES 58 1
                                    STANDBY YES YES 58 2
                                    STANDBY YES YES 59 2
                                    D:\EDRIVE\PRIMARY\ARC\1_59_815075358.ARC YES YES 59 1
                                    STANDBY YES YES 60 2
                                    D:\EDRIVE\PRIMARY\ARC\1_60_815075358.ARC YES YES 60 1
                                    STANDBY YES YES 61 2
                                    D:\EDRIVE\PRIMARY\ARC\1_61_815075358.ARC YES YES 61 1
                                    STANDBY YES YES 62 2
                                    D:\EDRIVE\PRIMARY\ARC\1_62_815075358.ARC YES YES 62 1
                                    D:\EDRIVE\PRIMARY\ARC\1_63_815075358.ARC YES YES 63 1
                                    STANDBY YES YES 63 2
                                    D:\EDRIVE\PRIMARY\ARC\1_64_815075358.ARC YES YES 64 1
                                    D:\EDRIVE\PRIMARY\ARC\1_65_815075358.ARC YES YES 65 1
                                    D:\EDRIVE\PRIMARY\ARC\1_66_815075358.ARC YES YES 66 1
                                    D:\EDRIVE\PRIMARY\ARC\1_67_815075358.ARC YES YES 67 1
                                    D:\EDRIVE\PRIMARY\ARC\1_68_815075358.ARC YES YES 68 1
                                    D:\EDRIVE\PRIMARY\ARC\1_69_815075358.ARC YES NO 69 1
                                    STANDBY YES YES 69 2
                                    D:\EDRIVE\PRIMARY\ARC\1_70_815075358.ARC YES NO 70 1
                                    STANDBY YES YES 70 2
                                    D:\EDRIVE\PRIMARY\ARC\1_71_815075358.ARC YES NO 71 1
                                    STANDBY YES YES 71 2
                                    STANDBY YES YES 72 2
                                    D:\EDRIVE\PRIMARY\ARC\1_72_815075358.ARC YES NO 72 1
                                    D:\EDRIVE\PRIMARY\ARC\1_73_815075358.ARC YES NO 73 1
                                    STANDBY YES YES 73 2
                                    D:\EDRIVE\PRIMARY\ARC\1_74_815075358.ARC YES NO 74 1
                                    STANDBY YES YES 74 2
                                    D:\EDRIVE\PRIMARY\ARC\1_75_815075358.ARC YES NO 75 1
                                    STANDBY YES YES 75 2
                                    STANDBY YES YES 76 2
                                    D:\EDRIVE\PRIMARY\ARC\1_76_815075358.ARC YES NO 76 1
                                    D:\EDRIVE\PRIMARY\ARC\1_77_815075358.ARC YES NO 77 1
                                    STANDBY YES YES 77 2

                                    In STANDBY SIDE

                                    NAME ARC APPLIED SEQUENCE#
                                    ---------------------------------------- --- --------- ----------
                                    D:\EDRIVE\STANDBY\ARC\1_55_815075358.ARC YES YES 55
                                    D:\EDRIVE\STANDBY\ARC\1_54_815075358.ARC YES YES 54
                                    D:\EDRIVE\STANDBY\ARC\1_53_815075358.ARC YES YES 53
                                    D:\EDRIVE\STANDBY\ARC\1_52_815075358.ARC YES YES 52
                                    D:\EDRIVE\STANDBY\ARC\1_50_815075358.ARC YES YES 50
                                    D:\EDRIVE\STANDBY\ARC\1_51_815075358.ARC YES YES 51
                                    D:\EDRIVE\STANDBY\ARC\1_56_815075358.ARC YES YES 56
                                    D:\EDRIVE\STANDBY\ARC\1_57_815075358.ARC YES YES 57
                                    D:\EDRIVE\STANDBY\ARC\1_58_815075358.ARC YES YES 58
                                    D:\EDRIVE\STANDBY\ARC\1_59_815075358.ARC YES YES 59
                                    D:\EDRIVE\STANDBY\ARC\1_60_815075358.ARC YES YES 60
                                    D:\EDRIVE\STANDBY\ARC\1_61_815075358.ARC YES YES 61
                                    D:\EDRIVE\STANDBY\ARC\1_62_815075358.ARC YES YES 62
                                    D:\EDRIVE\STANDBY\ARC\1_63_815075358.ARC YES YES 63
                                    D:\EDRIVE\STANDBY\ARC\1_64_815075358.ARC YES YES 64
                                    D:\EDRIVE\STANDBY\ARC\1_65_815075358.ARC YES YES 65
                                    PRIMARY YES YES 64
                                    PRIMARY YES YES 65
                                    D:\EDRIVE\STANDBY\ARC\1_66_815075358.ARC YES YES 66
                                    PRIMARY YES YES 66
                                    PRIMARY YES NO 67
                                    D:\EDRIVE\STANDBY\ARC\1_67_815075358.ARC YES YES 67
                                    D:\EDRIVE\STANDBY\ARC\1_68_815075358.ARC YES YES 68
                                    PRIMARY YES NO 68
                                    D:\EDRIVE\STANDBY\ARC\1_69_815075358.ARC YES YES 69
                                    D:\EDRIVE\STANDBY\ARC\1_70_815075358.ARC YES YES 70
                                    D:\EDRIVE\STANDBY\ARC\1_71_815075358.ARC YES YES 71
                                    D:\EDRIVE\STANDBY\ARC\1_72_815075358.ARC YES YES 72
                                    D:\EDRIVE\STANDBY\ARC\1_1_815506630.ARC YES NO 1
                                    D:\EDRIVE\STANDBY\ARC\1_73_815075358.ARC YES YES 73
                                    D:\EDRIVE\STANDBY\ARC\1_74_815075358.ARC YES YES 74
                                    D:\EDRIVE\STANDBY\ARC\1_75_815075358.ARC YES YES 75
                                    D:\EDRIVE\STANDBY\ARC\1_76_815075358.ARC YES YES 76
                                    D:\EDRIVE\STANDBY\ARC\1_77_815075358.ARC YES YES 77

                                    I wonder why in Some cases it is coming as APPLIED=NO and both the Primary and Standby.
                                    Also in Standby D:\EDRIVE\STANDBY\ARC\1_1_815506630.ARC  YES NO                 1 why sequence number 1 is gerenarated an not applied any where?
                                    Could any one of you please help me to know this?

                                    -Regards,
                                    Saha