(资料图)
上篇文章
源端为备库的场景下Duplicate失败问题我只在中间备库环境应用了PSU，解决了级联备库从中间备库duplicate数据库的问题：
细心的朋友已经发现，因为是备库环境，并没有做数据库执行相关脚本部分，所以如果去DB查询补丁应用信息是没有的：
SQL> r 1* select * from dba_registry_historyACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS--------------------------------------------------------------------------- ------------------------------ ------------------------------ ------------------------------ ---------- ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------17-SEP-11 10.21.11.595816 AM APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.004-APR-23 04.37.58.780922 PM APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.0本篇文章就继续把级联备库以及主库的PSU软件补丁打上，步骤和上篇无区别，不再赘述。最后要在主库按照readme执行对应脚本（只需在主库执行哦，通过ADG基理会将这些改变自动同步到备库）：
cd $ORACLE_HOME/rdbms/adminsqlplus /nologSQL> CONNECT / AS SYSDBASQL> STARTUPSQL> @catbundle.sql psu applySQL> QUIT再次看状态：
set lines 1000select * from dba_registry_history;SQL> set lines 1000select * from dba_registry_history;SQL>ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS--------------------------------------------------------------------------- ------------------------------ ------------------------------ ------------------------------ ---------- ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------17-SEP-11 10.21.11.595816 AM APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.004-APR-23 04.37.58.780922 PM APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.022-MAY-23 04.55.20.039373 PM APPLY SERVER 11.2.0.3 15 PSU PSU 11.2.0.3.15最后去备库，以及级联备库分别确认同步状态：
备库状态：已有11.2.0.3.15信息
[oracle@db11gadg ~]$ SQL> @dgNAME VALUE UNIT TIME_COMPUTED DATUM_TIME---------------------- ---------------------- ------------------------------ ------------------------------ ------------------------------transport lag +00 00:00:00 day(2) to second(0) interval 05/22/2023 16:56:04 05/22/2023 16:56:03apply lag +00 00:00:00 day(2) to second(0) interval 05/22/2023 16:56:04 05/22/2023 16:56:03apply finish time +00 00:00:00.000 day(2) to second(3) interval 05/22/2023 16:56:04estimated startup time 9 second 05/22/2023 16:56:04SQL> set lines 1000select * from dba_registry_history;SQL>ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS--------------------------------------------------------------------------- ------------------------------ ------------------------------ ------------------------------ ---------- ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------17-SEP-11 10.21.11.595816 AM APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.004-APR-23 04.37.58.780922 PM APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.022-MAY-23 04.55.20.039373 PM APPLY SERVER 11.2.0.3 15 PSU PSU 11.2.0.3.15级联备库状态：在主库切日志后也会有11.2.0.3.15信息：
[oracle@db11gcas ~]$SQL> @dgNAME VALUE UNIT TIME_COMPUTED DATUM_TIME---------------------- ---------------------- ------------------------------ ------------------------------ ------------------------------transport lag +00 00:00:48 day(2) to second(0) interval 05/22/2023 16:56:50 05/22/2023 16:56:06apply lag +00 00:00:48 day(2) to second(0) interval 05/22/2023 16:56:50 05/22/2023 16:56:06apply finish time day(2) to second(3) interval 05/22/2023 16:56:50estimated startup time 9 second 05/22/2023 16:56:50SQL> set lines 1000select * from dba_registry_history;SQL>ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS--------------------------------------------------------------------------- ------------------------------ ------------------------------ ------------------------------ ---------- ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------17-SEP-11 10.21.11.595816 AM APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.004-APR-23 04.37.58.780922 PM APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.0SQL> /ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS--------------------------------------------------------------------------- ------------------------------ ------------------------------ ------------------------------ ---------- ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------17-SEP-11 10.21.11.595816 AM APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.004-APR-23 04.37.58.780922 PM APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.022-MAY-23 04.55.20.039373 PM APPLY SERVER 11.2.0.3 15 PSU PSU 11.2.0.3.15SQL> @dgNAME VALUE UNIT TIME_COMPUTED DATUM_TIME---------------------- ---------------------- ------------------------------ ------------------------------ ------------------------------transport lag +00 00:00:00 day(2) to second(0) interval 05/22/2023 16:57:18 05/22/2023 16:57:11apply lag +00 00:00:00 day(2) to second(0) interval 05/22/2023 16:57:18 05/22/2023 16:57:11apply finish time day(2) to second(3) interval 05/22/2023 16:57:18estimated startup time 9 second 05/22/2023 16:57:18SQL> @dgNAME VALUE UNIT TIME_COMPUTED DATUM_TIME---------------------- ---------------------- ------------------------------ ------------------------------ ------------------------------transport lag +00 00:00:56 day(2) to second(0) interval 05/22/2023 16:58:16 05/22/2023 16:58:07apply lag +00 00:00:56 day(2) to second(0) interval 05/22/2023 16:58:16 05/22/2023 16:58:07apply finish time day(2) to second(3) interval 05/22/2023 16:58:16estimated startup time 9 second 05/22/2023 16:58:16都没问题了，整个过程也符合PSU补丁应用逻辑。
标签：
上篇文章-[源端为备库的场景下Duplicate失败问题](https: www cnblogs com jyzhao p 17420831 html)我只在
专访：中国－中亚峰会助力乌兹别克斯坦与中国深挖合作潜力——访乌外交部国际关系信息分析中心主任达尼...
证券时报网讯，为维护银行体系流动性合理充裕，2023年5月23日央行公开市场开展20亿元7天期逆回购操作，中标
日前，银登网发布《已开立不良贷款转让业务账户机构统计表》显示，今年以来，已有47家城商行及其分支机构和
原标题：甘肃省首张个体工商户“一业一证”行业综合许可证颁发近日，兰州新区市场监管局将甘肃首张个体...
实施财政资金直达机制是创新宏观调控的重大举措
农行西藏分行一季度累计发放实体贷款达215.86亿元
