Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an Oracle database running on windows 32 bit. I would like to upgrade to 64 bit (same version of oracle) and would like to use a standby database for a rolling upgrade. Is this possible and can I make the standby the primary so I don't have to have another outage to roll back to the primary?

share|improve this question
Is this a RAC installation? – DCookie Oct 7 '09 at 21:59
No, we are not using RAC. – Leigh Riffel Oct 8 '09 at 17:59
up vote 2 down vote accepted
  1. You will need to used logical standby which can be a bit trickier than physical. However, you can't have a physical standby with a different architecture than the primary.

  2. Yes, you can make the standby primary. It is called role switchover:

share|improve this answer
+1 Thanks for the great answer and the documentation link. I was thinking I would need a logical standby during the upgrade, but I was hoping I could start out with a physical and convert to logical just before the upgrade. I think you are saying that 32 bit and 64 bit are different architectures, so I can't create the physical standby at all. Is that correct? If it is that means I'll have to deal with the statements that don't transfer in a logical standby for a longer period of time. – Leigh Riffel Oct 12 '09 at 13:18
I never actually tried, but as far as I know 32 bit and 64 bit are different architectures and require logical standby only. – chenshap Oct 13 '09 at 14:44

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.