9 Replies Latest reply: Jan 30, 2013 8:22 AM by 988112 RSS

    Standby to Primary database switching problem

    443560
      hi,
      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.
      Khawar