Rolling Upgrade of Oracle 11g from 32 bit to 64 bit

32-bit64-bitoracleoracle-11g

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?

Best Answer

  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_01/server.102/b14239/role_management.htm#i1026400

Related Topic