Best Practices for Planned Maintenance (MAA)

Posted at Wednesday, February 13, 2008
Oracle users have bought into the MAA strategy in droves, however, the technology has yet to fully reward their efforts. The future of Oracle's MAA's (Maximum Availablility Architecture) ability to reduce maintenance outages seems to focus on 'Rolling Upgrades' and 'Online Patching'.

Here is a great presentation from a recent webcast, which outlines some of Oracle's efforts to reduce the effects of planned maintenance outages: Maximum Availability Architecture (MAA) Best Practices for Planned Maintenance: Online Patching and Rolling Upgrades with Oracle Database.

The presentation mentions 'Online Patching'; however, there aren't any such patches available at the time of this post so we will have to wait until a later time to test this out.

We don't have to wait, however, on the 'Rolling Upgrade' feature, since this is available as part of 10g Release 2. It basically leverages Logical Standbys in order to reduce the downtime normally associated with infrastructure patches as well as anything that requires catupgrd.sql, etc.

Here are a couple of good resources:

SQL Apply Rolling Upgrade Best Practices Oracle Database 10g Release 2

There is also a demo - as part of Oracle By Example - which shows how to do one of these 'Rolling Upgrades' blow-by-blow, with screenshots: Oracle By Example (OBE) Series Demos, simply click on the 'Oracle Database 10g Release 2' link and then select 'Rolling Release Upgrade to'.