2 Replies Latest reply: Aug 3, 2012 7:31 AM by Shivananda Rao RSS

    Reg:Primary Database

    New_To_Oracle_7912
      Hello

      In my primary database i have a problem

      I checked the switchover_status it resulted in "not allowed"

      how to make it as "To Standby"
        • 1. Re: Reg:Primary Database
          mseberg
          Can you run this query and post the results?

          http://www.visi.com/~mseberg/monitor_data_guard_transport.html

          "not allowed" generally means you have a gap. The query should provide the first clues.

          If you are using Standard Edition then this isn't really Data Guard, its a poor mans copy of the database and you should not expect it to have Data Guard features.

          This is also the default for databases not using Data Guard.
          Checking switchover status
          
          
          SWITCHOVER_STATUS                                                                                   
          --------------------                                                                                
          NOT ALLOWED    
          Best Regards

          mseberg

          Edited by: mseberg on Aug 6, 2012 12:24 PM
          • 2. Re: Reg:Primary Database
            Shivananda Rao
            Hi,

            Please close the thread Reg:Primary Database and continue posting here as you are in the right forum.

            Please post the below:

            Primary Database:
            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;