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?
2
- Is this a RAC installation?DCookie– DCookie2009-10-07 21:59:46 +00:00Commented Oct 7, 2009 at 21:59
- No, we are not using RAC.Leigh Riffel– Leigh Riffel2009-10-08 17:59:15 +00:00Commented Oct 8, 2009 at 17:59
Add a comment |
1 Answer
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.
Yes, you can make the standby primary. It is called role switchover: http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/role_management.htm#i1026400
- +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– Leigh Riffel2009-10-12 13:18:19 +00:00Commented Oct 12, 2009 at 13:18
- 1I never actually tried, but as far as I know 32 bit and 64 bit are different architectures and require logical standby only.chenshap– chenshap2009-10-13 14:44:03 +00:00Commented Oct 13, 2009 at 14:44