• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 336
  • Last Modified:

DataGuard | Switchover Question?

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;



0
sventhan
Asked:
sventhan
  • 2
1 Solution
 
Mark GeerlingsDatabase AdministratorCommented:
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.
0
 
sventhanAuthor Commented:
Thanks Mark.

< The reverse situation is more common (with a RAC primary and a non-RAC standby) and that is documented

In this situation the standby is really a backup DB and can be used only as a DR.

I think you're right, we cannot really do the DG switchover from Non-RAC to Single Instance.


0
 
sventhanAuthor Commented:
thanks.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now