This discussion is archived
2 Replies Latest reply: Aug 3, 2012 5:31 AM by Shivananda Rao RSS

Reg:Primary Database

New_To_Oracle_7912 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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;

Legend

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