Non-RAC : How to Perform out of Place Patching to Minimize DB Downtime
Last updated on APRIL 19, 2018
Applies to:Oracle Universal Installer - Version 10.2.0.1 and later
Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 24-SEP-2015***
Starting with 11gR2 patch set 1 (i.e 188.8.131.52.0), patch set installations can be done into either...
- existing Oracle Database home (In Place) where previous version of the same release (i.e. 11.2.0.x) exists
- new Oracle Database home location (Out Of Place)
Using Out Of Place option , we can minimize the downtime of the database environment, i.e time spent installing the software can be saved/reduced from the total database downtime required. However, some downtime is required for switching database services to the new oracle database home.
These database down time savings can also be achieved for previous releases, i.e. 11.1.0.x or 10.2.0.x using the clone option. A basic overview of the steps include...
- Clone the existing database home
- Apply required patch set to the cloned database home
- Switch the database services to the cloned database home
- Complete the post installation tasks for the patch set applied
This logic can also be used to perform application of interim patches (PSU/CPU/one-off patches) to minimize database downtime, and can be thought of as Out Of Place patching.
This article provides the steps to perform the Out Of Place patching to minimize the database downtime required for interim patch (PSU/CPU/one-off-patches) activities. As of now, this logic can be used to patch Oracle Database homes running with versions 10.2.0.x, 11.1.0.x and 11.2.0.x.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms