38、Oracle数据库补丁策略与降级方法详解

Oracle数据库补丁策略与降级方法详解

1. Oracle数据库补丁安装

1.1 补丁安装示例

在多租户数据库中执行脚本时，datapatch实用程序会在容器和所有打开的可插拔数据库中执行安装脚本。如果执行期间有可插拔数据库未打开，则可在其打开时单独为该PDB执行datapatch实用程序。以下是一个具体示例：

-- 当前SQL补丁状态
Bundle series PSU:
  ID 160119 in the binary registry and ID 5 in PDB CDB$ROOT, ID 5 in PDB PDB$SEED, ID 5 in 
PDB PDB12102
-- 添加补丁到安装队列并进行先决条件检查
Adding patches to installation queue and performing prereq checks...
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED PDB12102
    Nothing to roll back
    The following patches will be applied:
      21948354 (Database Patch Set Update : 12.1.0.2.160119 (21948354))
-- 安装补丁
Installing patches...
Patch installation complete.  Total patches installed: 3
-- 验证日志文件
Validating logfiles...
Pat