2 Replies Latest reply: Aug 6, 2013 7:45 AM by meser RSS

    Issue after restoring of  DR db into QA db

    Meenakshy singh

      Hi Gurus,


      Recently we have cloned DR server and restore it to QA server (including oracle) for testing purpose.After restoration of DR (physical standby) db into QA, I have re-started the db but database open in read only mode.

      My requirement is to change read-only mode to read-write mode so that we can perform testing on QA database.


      Database version is Oracle Database 10g Enterprise Edition Release - 64bit on windows 64bit.


      Can we convert read only mode to read write mode?Is this possible? or Do we need to break dataguard?

      If possible , how to do it?


      Please provide me steps to convert read mode to read-write mode.