ADG级联备库环境PSU应用验证
2023/5/23 11:52:10
本文主要是介绍ADG级联备库环境PSU应用验证，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！
上篇文章
- 源端为备库的场景下Duplicate失败问题
我只在中间备库环境应用了PSU，解决了级联备库从中间备库duplicate数据库的问题：
细心的朋友已经发现，因为是备库环境，并没有做数据库执行相关脚本部分，所以如果去DB查询补丁应用信息是没有的：
SQL> r 1* select * from dba_registry_history 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.0 04-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/admin sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> STARTUP SQL> @catbundle.sql psu apply SQL> QUIT
再次看状态：
set lines 1000 select * from dba_registry_history; SQL> set lines 1000 select * 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.0 04-APR-23 04.37.58.780922 PM APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.0 22-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> @dg NAME 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:03 apply lag +00 00:00:00 day(2) to second(0) interval 05/22/2023 16:56:04 05/22/2023 16:56:03 apply finish time +00 00:00:00.000 day(2) to second(3) interval 05/22/2023 16:56:04 estimated startup time 9 second 05/22/2023 16:56:04 SQL> set lines 1000 select * 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.0 04-APR-23 04.37.58.780922 PM APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.0 22-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> @dg NAME 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:06 apply lag +00 00:00:48 day(2) to second(0) interval 05/22/2023 16:56:50 05/22/2023 16:56:06 apply finish time day(2) to second(3) interval 05/22/2023 16:56:50 estimated startup time 9 second 05/22/2023 16:56:50 SQL> set lines 1000 select * 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.0 04-APR-23 04.37.58.780922 PM APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.0 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.0 04-APR-23 04.37.58.780922 PM APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.0 22-MAY-23 04.55.20.039373 PM APPLY SERVER 11.2.0.3 15 PSU PSU 11.2.0.3.15 SQL> @dg NAME 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:11 apply lag +00 00:00:00 day(2) to second(0) interval 05/22/2023 16:57:18 05/22/2023 16:57:11 apply finish time day(2) to second(3) interval 05/22/2023 16:57:18 estimated startup time 9 second 05/22/2023 16:57:18 SQL> @dg NAME 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:07 apply lag +00 00:00:56 day(2) to second(0) interval 05/22/2023 16:58:16 05/22/2023 16:58:07 apply finish time day(2) to second(3) interval 05/22/2023 16:58:16 estimated startup time 9 second 05/22/2023 16:58:16
都没问题了，整个过程也符合PSU补丁应用逻辑。
这篇关于ADG级联备库环境PSU应用验证的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！
- 2024-12-26大厂数据结构与算法教程：入门级详解
- 2024-12-26大厂算法与数据结构教程：新手入门指南
- 2024-12-26Python编程入门指南
- 2024-12-26数据结构高级教程：新手入门及初级提升指南
- 2024-12-26并查集入门教程：从零开始学会并查集
- 2024-12-26大厂数据结构与算法入门指南
- 2024-12-26大厂算法与数据结构入门教程
- 2024-12-26二叉树入门教程：轻松掌握基础概念与操作
- 2024-12-26初学者指南：轻松掌握链表
- 2024-12-26平衡树入门教程：轻松理解与应用
