This discussion is archived
9 Replies Latest reply: Mar 18, 2013 11:04 PM by $phinx19 RSS

Not allowed Issue while DR switchover.

$phinx19 Newbie
Currently Being Moderated
Hi All,

OS:windows
DB:11.2.0.1
Same BOX

I am testing a switchover, everything is achieved with no error only that at my new primary database I am getting the below mentioned siwtchover status:

SQL> select name ,open_mode, database_role, switchover_status from v$database;

NAME OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS
--------- -------------------- ---------------- --------------------
MAN MOUNTED PHYSICAL STANDBY NOT ALLOWED

Both the primary and the Standby databases are in sync and when I am switching a logfile at Primary it is getting successfully applied and the MRP0 and the RFS process are also up.

Is it normal to have this switchover status, if not how to get out of this?

Regards,
  • 1. Re: Not allowed Issue while DR switchover.
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Please post this on Primary :

    SQL> select switchover_status from v$database;

    Also Proof the both are sync ?
  • 2. Re: Not allowed Issue while DR switchover.
    $phinx19 Newbie
    Currently Being Moderated
    Hi ,

    Here is the output:
    SQL> select name ,open_mode, database_role, switchover_status from v$database;

    NAME OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS
    --------- -------------------- ---------------- --------------------
    MAN READ WRITE PRIMARY TO STANDBY

    SQL> select max(sequence#) from v$archived_log;

    MAX(SEQUENCE#)
    --------------
    56

    At DR:
    SQL> select max(sequence#) from v$log_history;

    MAX(SEQUENCE#)
    --------------
    56
  • 3. Re: Not allowed Issue while DR switchover.
    vlethakula Expert
    Currently Being Moderated
    Whether your REDO is getting shipped to stand by?

    show parameter log_archive_dest
  • 5. Re: Not allowed Issue while DR switchover.
    $phinx19 Newbie
    Currently Being Moderated
    Yes I have checked that the redos are getting transferred to the Standby.

    AT DR:
    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest string
    log_archive_dest_1 string location=D:\app2\man\archives\
    log_archive_dest_10 string
    log_archive_dest_11 string
    log_archive_dest_12 string
    log_archive_dest_13 string
    log_archive_dest_14 string
    log_archive_dest_15 string
    log_archive_dest_16 string
    log_archive_dest_17 string
    log_archive_dest_18 string

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest_19 string
    log_archive_dest_2 string
    log_archive_dest_20 string
    log_archive_dest_21 string
    log_archive_dest_22 string
    log_archive_dest_23 string
    log_archive_dest_24 string
    log_archive_dest_25 string
    log_archive_dest_26 string
    log_archive_dest_27 string
    log_archive_dest_28 string

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest_29 string
    log_archive_dest_3 string
    log_archive_dest_30 string
    log_archive_dest_31 string
    log_archive_dest_4 string
    log_archive_dest_5 string
    log_archive_dest_6 string
    log_archive_dest_7 string
    log_archive_dest_8 string
    log_archive_dest_9 string
    log_archive_dest_state_1 string enable

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest_state_10 string enable
    log_archive_dest_state_11 string enable
    log_archive_dest_state_12 string enable
    log_archive_dest_state_13 string enable
    log_archive_dest_state_14 string enable
    log_archive_dest_state_15 string enable
    log_archive_dest_state_16 string enable
    log_archive_dest_state_17 string enable
    log_archive_dest_state_18 string enable
    log_archive_dest_state_19 string enable
    log_archive_dest_state_2 string DEFER

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest_state_20 string enable
    log_archive_dest_state_21 string enable
    log_archive_dest_state_22 string enable
    log_archive_dest_state_23 string enable
    log_archive_dest_state_24 string enable
    log_archive_dest_state_25 string enable
    log_archive_dest_state_26 string enable
    log_archive_dest_state_27 string enable
    log_archive_dest_state_28 string enable
    log_archive_dest_state_29 string enable
    log_archive_dest_state_3 string enable

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest_state_30 string enable
    log_archive_dest_state_31 string enable
    log_archive_dest_state_4 string enable
    log_archive_dest_state_5 string enable
    log_archive_dest_state_6 string enable
    log_archive_dest_state_7 string enable
    log_archive_dest_state_8 string enable
    log_archive_dest_state_9 string enable

    At Primary:SQL> sho parameter log_archive_dest_

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest_1 string location=D:\app2\mandr\archive
    s\
    log_archive_dest_10 string
    log_archive_dest_11 string
    log_archive_dest_12 string
    log_archive_dest_13 string
    log_archive_dest_14 string
    log_archive_dest_15 string
    log_archive_dest_16 string
    log_archive_dest_17 string
    log_archive_dest_18 string

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest_19 string
    log_archive_dest_2 string service=man
    log_archive_dest_20 string
    log_archive_dest_21 string
    log_archive_dest_22 string
    log_archive_dest_23 string
    log_archive_dest_24 string
    log_archive_dest_25 string
    log_archive_dest_26 string
    log_archive_dest_27 string
    log_archive_dest_28 string

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest_29 string
    log_archive_dest_3 string
    log_archive_dest_30 string
    log_archive_dest_31 string
    log_archive_dest_4 string
    log_archive_dest_5 string
    log_archive_dest_6 string
    log_archive_dest_7 string
    log_archive_dest_8 string
    log_archive_dest_9 string
    log_archive_dest_state_1 string enable

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest_state_10 string enable
    log_archive_dest_state_11 string enable
    log_archive_dest_state_12 string enable
    log_archive_dest_state_13 string enable
    log_archive_dest_state_14 string enable
    log_archive_dest_state_15 string enable
    log_archive_dest_state_16 string enable
    log_archive_dest_state_17 string enable
    log_archive_dest_state_18 string enable
    log_archive_dest_state_19 string enable
    log_archive_dest_state_2 string ENABLE

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest_state_20 string enable
    log_archive_dest_state_21 string enable
    log_archive_dest_state_22 string enable
    log_archive_dest_state_23 string enable
    log_archive_dest_state_24 string enable
    log_archive_dest_state_25 string enable
    log_archive_dest_state_26 string enable
    log_archive_dest_state_27 string enable
    log_archive_dest_state_28 string enable
    log_archive_dest_state_29 string enable
    log_archive_dest_state_3 string enable

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    log_archive_dest_state_30 string enable
    log_archive_dest_state_31 string enable
    log_archive_dest_state_4 string enable
    log_archive_dest_state_5 string enable
    log_archive_dest_state_6 string enable
    log_archive_dest_state_7 string enable
    log_archive_dest_state_8 string enable
    log_archive_dest_state_9 string enable

    Regards
  • 6. Re: Not allowed Issue while DR switchover.
    CKPT Guru
    Currently Being Moderated
    SQL> select name ,open_mode, database_role, switchover_status from v$database;

    NAME OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS
    --------- -------------------- ---------------- --------------------
    MAN MOUNTED PHYSICAL STANDBY NOT ALLOWED

    Both the primary and the Standby databases are in sync and when I am switching a logfile at Primary it is getting successfully applied and the MRP0 and the RFS process are also up.
    Is it normal to have this switchover status, if not how to get out of this?
    NOT ALLOWED - Either this is a standby database and the primary database has not been switched first or this is a primary database and there are no standby databases.
    >

    You mean that after performing Switchover first time, still the status is same? usually from primary should be "TO STANDBY" or "SESSION",
    When the status is not allowed, can you see any jobs are running?

    Can you also check what is the database role of the both primary and standby?
  • 7. Re: Not allowed Issue while DR switchover.
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    You can use the below command :
    SQL>alter database commit to switchover to physical standby with session shutdown
    in the above command the primary will generate special marker will be replaced in the header of Online Redolog, which mean all will send to standby , after that the status should be changed.
  • 8. Re: Not allowed Issue while DR switchover.
    $phinx19 Newbie
    Currently Being Moderated
    Thanks CKPT,

    Yes.

    There are no jobs that are running currently.
    The database roles are also proper.

    Edited by: $phinx19 on Mar 18, 2013 11:02 PM
  • 9. Re: Not allowed Issue while DR switchover.
    $phinx19 Newbie
    Currently Being Moderated
    Thanks Osama,

    This is the very command that i used on Primary database to switch it over to Physical standby database.

Legend

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