How to Upgrade Physical Standby 2 Node RAC
edited Jul 28, 2011 9:44AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered ✓
My current environment is (all Oracle Enterprise Linux 5):
Two-node Oracle EE 11.1.0.7 RAC running on Clusterware 11.1.0.7 for my Primary database
Two-node Oracle EE 11.1.0.7 RAC running on Clusterware 11.1.0.7 for my Physical Standby database
I am attempting to upgrade Oracle EE to 11.2.0.2 and Clusterware to Grid Infrastructure 11.2.0.2
I only have one sticking point which I'm not sure of. My plan is to perform the following steps (Note: downtime is not an issue):
1. Stop log shipping and shutdown Standby RAC cluster.
2. Upgrade Standby nodes Clusterware to Grid Infrastructure 11.2.0.2
3. Startup Physical Standby. Database will still be 11.1.0.7 but with GI 11.2.0.2
4. Shutdown Primary RAC database
5. Upgrade Primary nodes Clusterware to Grid Infrastructure 11.2.0.2
Two-node Oracle EE 11.1.0.7 RAC running on Clusterware 11.1.0.7 for my Primary database
Two-node Oracle EE 11.1.0.7 RAC running on Clusterware 11.1.0.7 for my Physical Standby database
I am attempting to upgrade Oracle EE to 11.2.0.2 and Clusterware to Grid Infrastructure 11.2.0.2
I only have one sticking point which I'm not sure of. My plan is to perform the following steps (Note: downtime is not an issue):
1. Stop log shipping and shutdown Standby RAC cluster.
2. Upgrade Standby nodes Clusterware to Grid Infrastructure 11.2.0.2
3. Startup Physical Standby. Database will still be 11.1.0.7 but with GI 11.2.0.2
4. Shutdown Primary RAC database
5. Upgrade Primary nodes Clusterware to Grid Infrastructure 11.2.0.2
-- Cheers, Brian
Author, Oracle guy, and hockey fan
http://www.peasland.net
1