Oracle11gR2以后的補(bǔ)丁升級(jí)兩種方式

以下部分內(nèi)容來(lái)自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都是完整的安裝包，因此可以直接用來(lái)安裝。

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.
 
將升級(jí)文件安裝到原來(lái)的Oracle home目錄，這樣可以節(jié)省磁盤(pán)空間，但是需要更多的停機(jī)時(shí)間，這種方法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目錄，當(dāng)安裝結(jié)束后，舊的database會(huì)遷移到新的Oracle HOME目錄。
這種方法是Oracle推薦的方式，它可以降低停機(jī)時(shí)間，也相對(duì)更安全。但是這種方法需要至少兩倍的磁盤(pán)空間。

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]