Oracle 11.2.0.4 DataGuard 环境打PSU,OJVM PSU补丁快速参考(2)

这里尤其注意第三项，备库只有在ADG模式下才可以查询。
主库补丁应用的查询结果：

SQL> r 1* select ACTION_TIME,ACTION,NAMESPACE,VERSION,BUNDLE_SERIES,ID from registry$history ACTION_TIME ACTION NAMESPACE VERSION BUNDLE_SERIES ID --------------------------------------------------------------------------- ------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- 24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 PSU 0 08-JUL-16 02.50.00.349757 PM APPLY SERVER 11.2.0.4 PSU 0 22-SEP-16 03.48.39.295292 PM jvmpsu.sql SERVER 11.2.0.4.160719OJVMPSU 0 22-SEP-16 03.49.37.935537 PM APPLY SERVER 11.2.0.4 PSU 160719 22-SEP-16 03.51.55.999773 PM APPLY SERVER 11.2.0.4.160719OJVMPSU 0 22-SEP-16 03.51.56.010800 PM APPLY 23177551 6 rows selected.

ADG模式下，最终备库补丁应用的查询结果：

SQL> select ACTION_TIME,ACTION,NAMESPACE,VERSION,BUNDLE_SERIES,ID from registry$history; ACTION_TIME ACTION NAMESPACE VERSION BUNDLE_SERIES ID --------------------------------------------------------------------------- ------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- 24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 PSU 0 08-JUL-16 02.50.00.349757 PM APPLY SERVER 11.2.0.4 PSU 0 22-SEP-16 03.48.39.295292 PM jvmpsu.sql SERVER 11.2.0.4.160719OJVMPSU 0 22-SEP-16 03.49.37.935537 PM APPLY SERVER 11.2.0.4 PSU 160719 22-SEP-16 03.51.55.999773 PM APPLY SERVER 11.2.0.4.160719OJVMPSU 0 22-SEP-16 03.51.56.010800 PM APPLY 23177551 6 rows selected.

至此已确定主库备库都已经成功完成应用PSU，OJVM PSU补丁。

Reference

How do you apply a Patchset,PSU or CPU in a Data Guard Physical Standby configuration (文档 ID 278641.1)