Oracle11gR2以后的補丁升級兩種方式

以下部分內容來自patchset文檔。
 
Oracle® Database Patch Set Notes 11gRelease 2 (11.2.0.3) Patch Set 2 E24903-01
Patch Set Overview
Oracle Database patch set, release 11.2.0.3 is a full installation of the Oracle Database software. This means that you do not need to install Oracle Database 11gRelease 2 (11.2.0.1) before installing Oracle Database 11gRelease 2 (11.2.0.3).-
 

See Also:
"Oracle Database 11gRelease 2 (11.2.0.3) New Features" inOracle Database New Features Guide
Note the following changes with the new patch set packaging:
New installations consist of installing the most recent patch set, rather than installing a base release and then upgrading to a patch release.
Direct upgrades from previous releases to the most recent patch set are supported.
Out-of-place patch set upgrades recommended, in which you install the patch set into a new, separate Oracle home. In-place upgrades are supported, but not recommended.

11.2.0.3 (包括Oracle 11.2.0.2)的patchset都是完整的安裝包，因此可以直接用來安裝。

In-Place Upgrade
This feature enables you to upgrade an existing installation of Oracle database to Oracle Database 11gRelease 2 (11.2.0.3) into the same Oracle home directory by replacing the existing database files. The patch set application requires more downtime and is not recommended. This upgrade type requires less disk space.
Note:
If you select In-place upgrade to upgrade Oracle database to the latest version, then you must:
Review "Optionally Performing an In-Place Upgrade (Into the Same Oracle Home)" inOracle Database Upgrade Guide.
Take a complete backup of your Oracle home directory before you perform. the upgrade.
 
將升級文件安裝到原來的Oracle home目錄，這樣可以節省磁盤空間，但是需要更多的停機時間，這種方法Oracle并不推薦。

Out-of-Place Upgrade
This feature enables you to install Oracle Database 11gRelease 2 (11.2.0.3) in a new, separate Oracle home directory. After the installation is complete, the data from the database in the old Oracle home directory is migrated to the database in the new Oracle home directory.
Out-of-place upgrade process is similar to Oracle database upgrade from one version to another and is the recommended type. The benefits of this upgrade type is that the patch set application requires much less downtime, and is safer when the patch set application must be aborted. This upgrade type requires more disk space to accommodate two Oracle home directories simultaneously.

可以將Oracle Database安裝的新的OracleHome目錄，當安裝結束后，舊的database會遷移到新的Oracle HOME目錄。
這種方法是Oracle推薦的方式，它可以降低停機時間，也相對更安全。但是這種方法需要至少兩倍的磁盤空間。

服務器租用/服務器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質保障！--億恩科技[ENKJ.COM]