<div>
The reverse situation is more common (with a RAC primary and a non-RAC standby) and that is documented. &nbsp;I don't remember seeing examples of a RAC standby for a non-RAC primary. &nbsp;I'm not saying that I know it can't be done, but I would say that it is doubtful.
</div>


The reverse situation is more common (with a RAC primary and a non-RAC standby) and that is documented.  I don't remember seeing examples of a RAC standby for a non-RAC primary.  I'm not saying that I know it can't be done, but I would say that it is doubtful.

<div>
<div class="content wysiwyg-content">
Experts -<br />
<br />
<br />
Can we SWITCHOVER from SINGLE Instance PRIMARY (non-rac) datagurad to RAC (2-node) physical standby setup? If this is &nbsp;possible can you &nbsp;provide some links, docs, etc? I'm having hard time to find the answers for this question.<br />
<br />
Primary : NON-RAC<br />
Standby : RAC (2 node)<br />
<br />
Is switchover possible?<br />
sql&gt; ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;<br />
<br />
<br />
<br />

</div>
</div>


Experts -


Can we SWITCHOVER from SINGLE Instance PRIMARY (non-rac) datagurad to RAC (2-node) physical standby setup? If this is  possible can you  provide some links, docs, etc? I'm having hard time to find the answers for this question.

Primary : NON-RAC
Standby : RAC (2 node)

Is switchover possible?
sql> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;





DataGuard | Switchover Question?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.