9 Replies Latest reply on Jan 30, 2013 2:22 PM by 988112

    Standby to Primary database switching problem

      I have created standby database through RMAN (I have Oracle STANDARD edition on both primary and standby server,

      beware of its restrictions) and open it in read only( I applied archives by manually copying it to standby database and giving

      this command
      "alter database recover automatic standby database until cancel" ) now what I want to switch it physical primary database

      and open it in "write and read" normally when I am giving this command it gives this error.

      SQL> alter database commit to switchover to primary nowait;
      ERROR at line 1:
      ORA-16139: media recovery required

      plz, help me whats wrong I am doing, give me suggestions and links for guidance, Thanks in advance.