PSU更新之后是否更改数据库版本号呢

    在安装psu补丁之后，登陆数据库发现sqlplus、数据库版本号没有发生变更。查看MOS官方给出如下解释。同时做了一个测试，将打psu补丁后的数据库冷备份到打补丁之前的数据库仍然可以

启动数据库，同时没有任何报错。

select substr(action_time,1,30) action_time, 
substr(id,1,10) id, 
substr(action,1,10) action, 
substr(version,1,8) version, 
substr(BUNDLE_SERIES,1,6) bundle, 
substr(comments,1,20) comments 
from registry$history;

ACTION_TIME                  ID ACTION VERSION  BUNDLE COMMENTS 
---------------------------- -- ------ -------- ------ -------------- 
23-AUG-10 07.28.02.856762 AM 4  APPLY  10.2.0.4 PSU    PSU 10.2.0.4.3 
23-AUG-10 07.31.48.001892 AM 1  APPLY  10.2.0.4 PSU    PSU 10.2.0.4.4

For Windows : You get the output as mentioned below

Example output :

ACTION_TIME                    ID ACTION VERSION  BUNDLE COMMENTS 
----------------------------   -- ------ -------- ------ --------------

30-JUL-12 10.28.44.656000 PM               20   APPLY     11.2.0.2    WINBUN      Patch 20

Note: The registry$history will not contain the row showing the PSU Post Install step was executed unless catbundle.sql is executed.  This means if the Post Install steps were skipped because the db was upgraded or created after installing the PSU, this row will not exist

备注：MOS通过查看registry$history视图，查看DB是否更新psu,同时也可以通过dba_registry_history视图进行查看。

本文出自 “” 博客，请务必保留此出处

PSU更新之后是否更改数据库版本号呢,布布扣,bubuko.com