Oracle MRP补丁

参考文档：

Oracle Database Oracle Database Patch Maintenance, Release 19c and Later Releases

Introducing Monthly Recommended Patches (MRPs) and FAQ (Doc ID 2898740.1)    -
Sunsetting of 19c RURs and FAQ (Doc ID 2898381.1).   
Primary Note for Database Proactive Patch Program (Doc ID 888.1)  
Oracle Database 19c Important Recommended One-off Patches (Doc ID 555.1)  
Release Schedule of Current Database Releases (Doc ID 742060.1) 
当前数据库版本的发行时间表 (Doc ID 1626244.1)
Database Patch Conflict Resolution (Doc ID 1321267.1) 
数据库补丁冲突解决方案 (Doc ID 1674432.1) 
How to confirm applied MRP (Doc ID 2941520.1) 
Should I ask for a one-off bug fix or wait for the next Release Update (Doc ID 2648544.1)

关于Oracle MRP补丁。官方解释是这样的

• Monthly Recommended Patches (MRP)
  Starting with update 19.17, Oracle is providing MRPs for Linux x86-64 to provide proactive patching between Release Updates.

所以，从19.16开始 ，看不到Oracle Database Update Revisions 补丁了。从MOS上的下图可以看到。因为被MRP补丁取代了。（这个补丁，是在原来每个季度的RU的基础上，再修订2个版本）

 

 如何查看MRP补丁，可以参考How to confirm applied MRP (Doc ID 2941520.1) 

RU是每个季度发行一次，官方参考文档内容如下：

每个季度发行一个版本的RU

Example 1-1 Apply the next RU each quarter

The following table shows an example of how you can apply a release update each quarter. Starting in October, you install RU 19.17.0. In January, you install RU 19.18.0. In April, you install RU 19.19.0. In July, you install RU 19.20.0. In October, you install RU 19.21.0.

Patch Type	October	January	April	July	October
RU	19.17.0	19.18.0	19.19.0	19.20.0	19.21.0

而MRP补丁是在RU补丁基础上，每个月发行一次。官方文档的内容如下：

比如：19.17的RU补丁，每个月的MRP补丁在19.17基础上更新，持续6个月。19.18的补丁，同理。

Table 1-1 Patch Schedule for RU 19.17.0

MRP	October 2022	November 2022	December 2022	January 2022	February 2022	March 2022	April 2022
MRP for 19.17.0 RU	n/a	221115	221220	230117	230221	230321	23418

Table 1-2 Patch Schedule for RU 19.18.0

MRP	January 2023	February 2023	March 2023	April 2023	May 2023	June 2023	July 2023
MRP for 19.18.0 RU	n/a	230221	230321	230418	230516	230620	230718

MRP补丁的格式，官方文档内容如下：

For example:

CopyPatch 34522319 - DATABASE MRP 19.17.0.0.221115

 

其他问题，可以参考官方文档或MOS。

END

2023.05.20 PM ,Linux Mint。