Home / server / Questions / 72210
Accepted
Leigh Riffel
Asked: 2009-10-08 08:12:44 +0800 CST

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

  • 772

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?

oracle

1 Answers

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

    • 2