Online Patching With Oracle 11g Release 2 Database

–Functionality leverages native 11g R2 features that allow online application upgrade with uninterrupted availability of the application

–Patches can be applied while the production system is fully operational

–Only a short downtime is required to complete patching process

–The amount of downtime required by any patch will be more predictable

Edition-based redefinition enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time. To upgrade an application while it is in use, you copy the database objects that comprise the application and redefine the copied objects in isolation. Your changes do not affect users of the application—they continue to run the unchanged application. When you are sure that your changes are correct, you make the upgraded application available to all users. Using edition-based redefinition means using one or more of its component features. The features you use, and the down time, depend on these factors:

What kind of database objects you redefine
How available the database objects must be to users while you are redefining them
Whether you make the upgraded application available to some users while others continue to use the older version of the application

Click here for more information.