6 Replies Latest reply: Aug 6, 2012 8:08 PM by 420678 RSS

    Reg Switch_Over

    New_To_Oracle_7912
      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
          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
            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
              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
                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
                  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
                    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