This discussion is archived
14 Replies Latest reply: May 15, 2013 11:13 PM by j_DBA_sourav RSS

Primary database switchover problem

Madhu.149 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    Hi,

    Please post the following from the primary database:

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

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


    in standby


    Switchover_status
    ------------------------
    to primary
  • 4. Re: Primary database switchover problem
    Helios-GunesEROL Oracle ACE
    Currently Being Moderated
    Hi;

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

    Regard
    Helios
  • 5. Re: Primary database switchover problem
    Shivananda Rao Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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