9 Replies Latest reply on Apr 28, 2017 12:31 PM by da*306939*la

    switchover back primary to standby and standby to primary

    3414508

      Hello,

       

      I succeed to switchover from primary(a) to standby and my standby(b) to primary. however now i want to reverse the situation and then when i try to switch my primary(b) to standby i receive error.

       

      First i checked what is switchover_status:

       

      SWITCHOVER_STATUS

      --------------------

      NOT ALLOWED

       

      but I decided to contiune but error shows up:

       

      alter database commit to switchover to physical standby with session shutdown;

       

      alter database commit to switchover to physical standby with session shutdown

      *

      ERROR at line 1:

      ORA-16416: No viable Physical Standby switchover targets available

       

      I found some old thread here ORA-16416: No viable Physical Standby switchover targets available

      but i dont quite understand what i have to do now, there might be a problem with log_archive_dest_n however i have no idea why, because i did this operation previously and it worked. I have to change the value from primary log_archive_dest to standby and vice versa?

      and of course there is an issue because when on new primary database i switch logfile, standby do not recognize it and do not update v$archived_log list. I cant use broker as its paid feature. Thank you in advance for your prompt respond.

       

      Best Regards,

      Anon