This discussion is archived
2 Replies Latest reply: Aug 6, 2013 5:45 AM by meser RSS

Issue after restoring of  DR db into QA db

Meenakshy singh Newbie
Currently Being Moderated

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 10.2.0.1.0 - 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.

 

Thanks,

Meena

Legend

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