This discussion is archived
6 Replies Latest reply: Aug 6, 2012 6:08 PM by 420678 RSS

Reg Switch_Over

New_To_Oracle_7912 Newbie
Currently Being Moderated
I have installed Oracle 11g

Version : 11.0.2.1.0

Os: Windows server 2008r2

Is it possible to perform switchover operation in oracle standard edition.

If it is not possible can you please provide me the link.

for that
  • 1. Re: Reg Switch_Over
    CKPT Guru
    Currently Being Moderated
    New_To_Oracle_7912 wrote:
    I have installed Oracle 11g

    Version : 11.0.2.1.0

    Os: Windows server 2008r2

    Is it possible to perform switchover operation in oracle standard edition.

    If it is not possible can you please provide me the link.

    for that
    It is not possible. If it is not possible how to provide link when there is no option?
  • 2. Re: Reg Switch_Over
    New_To_Oracle_7912 Newbie
    Currently Being Moderated
    Thank you for your reply,

    Why it is not possible to perform Switch over operation in standard edition
  • 3. Re: Reg Switch_Over
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    Before talking of switchover, ask how you implement a Standby database in Standard Edition. DataGuard is not available so a Standby Database has to be "scripted". See Oracle Support note "Alternative for standby database in standard edition [ID 333749.1]"


    Hemant K Chitale
  • 4. Re: Reg Switch_Over
    CKPT Guru
    Currently Being Moderated
    Hemant K Chitale wrote:
    Before talking of switchover, ask how you implement a Standby database in Standard Edition. DataGuard is not available so a Standby Database has to be "scripted". See Oracle Support note "Alternative for standby database in standard edition [ID 333749.1]"


    Hemant K Chitale
    Hemanth,

    One question. even if OP created standby database later it wont support Switchover too. Still its manual apply and used for only failover.
  • 5. Re: Reg Switch_Over
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    That is why I point out that he must know how the Standby is created before he even talks of a switchover.

    Hemant K Chitale
  • 6. Re: Reg Switch_Over
    420678 Newbie
    Currently Being Moderated
    It is possible to perform switchover operations in Oracle Standard Edition if you use a product called Dbvisit Standby.

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

    Regards

Legend

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