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.
Actually you could do a failover senario.
7.2.2 Failovers Involving a Physical Standby Database