Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 1 down vote favorite

I have an Oracle 11.1.0.7 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

1 Answer

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: http://download.oracle.com/docs/cd/B19306%5F01/server.102/b14239/role%5Fmanagement.htm#i1026400

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
1  
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

 
discard

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.