探索Oracle之数据库升级五 PSU11.2.0.4.3 rollback 11.2.0.4.0

最新推荐文章于 2021-04-07 07:32:51 发布

PrudentWoo

最新推荐文章于 2021-04-07 07:32:51 发布

阅读量2.9k

点赞数

分类专栏： Oracle 探索系列 Oracle 技术博文

本文链接：https://blog.csdn.net/wuweilong/article/details/41803281

版权

技术博文同时被 3 个专栏收录

190 篇文章 1 订阅

订阅专栏

Oracle

95 篇文章 2 订阅

订阅专栏

Oracle 探索系列

58 篇文章 1 订阅

订阅专栏

探索Oracle之数据库升级五

PSU11.2.0.4.3 rollback 11.2.0.4.0

一、进入PSU目录，执行opatch rollback

[root@db01~]# su - oracle

[oracle@db01~]$ ls

c18522509  Desktop OPatch p18522509_112040_Linux-x86-64.zip p6880880_112000_Linux-x86-64.zip  PatchSearch.xml  upgrade.log

[oracle@db01~]$ cd 18522509/

[oracle@db0118522509]$ ls

17478514  18031668 18522509  patchmd.xml  README.html README.txt

[oracle@db0118522509]$ clear

[oracle@db0118522509]$ /home/oracle/OPatch/opatch rollback -id 18522509

OracleInterim Patch Installer version 11.2.0.3.6

Copyright(c) 2013, Oracle Corporation.  All rightsreserved.

 

 

OracleHome       : /DBSoft/Product/11.2.4/db_1

CentralInventory : /DBSoft/oraInventory

   from           : /DBSoft/Product/11.2.4/db_1/oraInst.loc

OPatchversion    : 11.2.0.3.6

OUIversion       : 11.2.0.4.0

Log filelocation :/DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/18522509_Oct_04_2014_07_00_07/rollback2014-10-04_07-00-07AM_1.log

 

 

Patcheswill be rolled back in the following order: 

   18522509  18031668   17478514

Thefollowing patch(es) will be rolled back: 18522509  18031668 17478514  

Sub-patchesof a composite series are being rolled back. The system will be returned to astate where all subpatches are rolled back.

Thefollowing bug fixes will be removed:17596908,17174582,17648596,17011832,13645875,18096714,17752995,13951456,17655634,16992075,17786518,17393915,13498382,13609098,15861775,16360112,17571306,17477958,16392068,17006570,14458214,14602788,17397545,16268425,17165204,14565184,17883081,18522509,18018515,17672719,16315398,13853126,18554871,17767676,17588480,16542886,17227277,16855292,14054676,17786278,17311728,18247991,18277454,15979965,18681862,18996843,17754782,17892268,17614134,16314254,17478145,18061914,19049453,17238511,17600719,17381384,18744139,17297939,17783588,17716305,16180763,17545847,18203838,17393683,16863422,17389192,17394950,16731148,17761775,10136473,17726838,17186905,17441661,17325413,18203835,13364795,17050888,16472716,17622427,17546761,17468141,17040764,14010183,16837842,16228604,17205719,17284817,17346671,18180390,17235750,14133975,17721717,17082359,17602269,17071721,16613964,16929165,16043574,17080436,17265217,17865671,14852021,16399083,16943711,17375354,17546973,16785708,16956380,18094246,17614227,18031668,17313525,16912439,17385178,16618694,16220077,17016369,18203837,17027426,17341326,18139690,17437634,16875449,17465741,17752121,17344412,17296856,17390431,14338435,17323222,16850630,17551709,13944971,17811447,13866822,17811429,16069901,16721594,17443671,17478514,17612828,17610798,17239687,17501491,17446237,16450169,17811438,17288409,17811456,12905058,17088068,16285691,17332800

 

Pleaseshutdown Oracle instances running out of this ORACLE_HOME on the local system.

(OracleHome = '/DBSoft/Product/11.2.4/db_1')

 

 

Is thelocal system ready for patching? [y|n]

y

UserResponded with: Y

 

Rollingback patch 18522509...

 

RollbackSessionrolling back interim patch '18522509' from OH '/DBSoft/Product/11.2.4/db_1'

 

Patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0...

 

Patchingcomponent oracle.rdbms, 11.2.0.4.0...

Deleting"kzradmape.o" from archive"/DBSoft/Product/11.2.4/db_1/lib/libserver11.a"

 

Patchingcomponent oracle.precomp.common, 11.2.0.4.0...

 

Patchingcomponent oracle.rdbms.rman, 11.2.0.4.0...

 

Patchingcomponent oracle.rdbms.dbscripts, 11.2.0.4.0...

 

Patchingcomponent oracle.rdbms.deconfig, 11.2.0.4.0...

RollbackSessionremoving interim patch '18522509' from inventory

 

Rollingback patch 18031668...

 

RollbackSessionrolling back interim patch '18031668' from OH '/DBSoft/Product/11.2.4/db_1'

 

Patchingcomponent oracle.rdbms, 11.2.0.4.0...

 

Patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0...

 

Patchingcomponent oracle.ldap.rsf, 11.2.0.4.0...

 

Patchingcomponent oracle.rdbms.crs, 11.2.0.4.0...

 

Patchingcomponent oracle.precomp.common, 11.2.0.4.0...

 

Patchingcomponent oracle.ldap.rsf.ic, 11.2.0.4.0...

 

Patchingcomponent oracle.rdbms.deconfig, 11.2.0.4.0...

 

Patchingcomponent oracle.rdbms.dbscripts, 11.2.0.4.0...

 

Patchingcomponent oracle.rdbms.rman, 11.2.0.4.0...

RollbackSessionremoving interim patch '18031668' from inventory

 

Rollingback patch 17478514...

 

RollbackSessionrolling back interim patch '17478514' from OH '/DBSoft/Product/11.2.4/db_1'

 

Patchingcomponent oracle.rdbms, 11.2.0.4.0...

 

Patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0...

 

Patchingcomponent oracle.sdo, 11.2.0.4.0...

 

Patchingcomponent oracle.sysman.agent, 10.2.0.4.5...

 

Patchingcomponent oracle.xdk, 11.2.0.4.0...

 

Patchingcomponent oracle.rdbms.dbscripts, 11.2.0.4.0...

 

Patchingcomponent oracle.sdo.locator, 11.2.0.4.0...

 

Patchingcomponent oracle.nlsrtl.rsf, 11.2.0.4.0...

 

Patchingcomponent oracle.xdk.rsf, 11.2.0.4.0...

 

Patchingcomponent oracle.rdbms.rman, 11.2.0.4.0...

RollbackSessionremoving interim patch '17478514' from inventory

OPatchfound the word "warning" in the stderr of the make command.

Pleaselook at this stderr. You can re-run this make command.

Stderroutput:

ins_emagent.mk:113:warning: overriding commands for target `nmosudo'

ins_emagent.mk:52:warning: ignoring old commands for target `nmosudo'

/DBSoft/Product/11.2.4/db_1/sysman/lib/ins_emagent.mk:113:warning: overriding commands for target `nmosudo'

/DBSoft/Product/11.2.4/db_1/sysman/lib/ins_emagent.mk:52:warning: ignoring old commands for target `nmosudo'

 

 

OPatchSession completed with warnings.

Log filelocation:/DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/18522509_Oct_04_2014_07_00_07/rollback2014-10-04_07-00-07AM_1.log

 

OPatchcompleted with warnings.

[oracle@db0118522509]$

二、启动数据库，执行catbundle_PSU_WOO_ROLLBACK.sql

[oracle@db0118522509]$ sqlplus / as sysdba

 

SQL*Plus:Release 11.2.0.4.0 Production on Sat Oct 4 07:04:28 2014

 

Copyright(c) 1982, 2013, Oracle.  All rightsreserved.

 

Connectedto an idle instance.

 

SQL>!lsnrctl start

 

LSNRCTLfor Linux: Version 11.2.0.4.0 - Production on 04-OCT-2014 07:04:31

 

Copyright(c) 1991, 2013, Oracle.  All rightsreserved.

 

Starting/DBSoft/Product/11.2.4/db_1/bin/tnslsnr: please wait...

 

TNSLSNRfor Linux: Version 11.2.0.4.0 - Production

System parameterfile is /DBSoft/Product/11.2.4/db_1/network/admin/listener.ora

Logmessages written to /DBSoft/diag/tnslsnr/db01/listener/alert/log.xml

Listeningon: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Listeningon: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db01)(PORT=1521)))

 

Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUSof the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version11.2.0.4.0 - Production

StartDate                04-OCT-2014 07:04:31

Uptime                    0 days 0 hr. 0 min. 0 sec

TraceLevel               off

Security                  ON: Local OS Authentication

SNMP                      OFF

ListenerParameter File   /DBSoft/Product/11.2.4/db_1/network/admin/listener.ora

ListenerLog File        /DBSoft/diag/tnslsnr/db01/listener/alert/log.xml

ListeningEndpoints Summary...

 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db01)(PORT=1521)))

Thelistener supports no services

Thecommand completed successfully

 

SQL>startup

ORACLEinstance started.

 

TotalSystem Global Area 2872786944 bytes

FixedSize                  2256712 bytes

VariableSize            2634023096 bytes

DatabaseBuffers          218103808 bytes

RedoBuffers               18403328 bytes

Databasemounted.

Databaseopened.

SQL>

SQL>alter system register;

 

Systemaltered.

 

SQL>@?/rdbms/admin/catbundle_PSU_WOO_ROLLBACK.sql

 

SQL>alter system register;

 

Systemaltered.

 

SQL>alter system register;

 

Systemaltered.

三、检查回滚后的版本：

[oracle@db0118522509]$ /home/oracle/OPatch/opatch lsinventory

OracleInterim Patch Installer version 11.2.0.3.6

Copyright(c) 2013, Oracle Corporation.  All rightsreserved.

 

 

OracleHome       : /DBSoft/Product/11.2.4/db_1

CentralInventory : /DBSoft/oraInventory

   from           :/DBSoft/Product/11.2.4/db_1/oraInst.loc

OPatchversion    : 11.2.0.3.6

OUIversion       : 11.2.0.4.0

Log filelocation : /DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/opatch2014-10-04_07-10-34AM_1.log

 

LsinventoryOutput file location :/DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-10-04_07-10-34AM.txt

 

--------------------------------------------------------------------------------

InstalledTop-level Products (1): 

 

OracleDatabase 11g                                                 11.2.0.4.0

Thereare 1 product(s) installed in this Oracle Home.

 

 

Thereare no Interim patches installed in this Oracle Home.

 

 

--------------------------------------------------------------------------------

 

OPatchsucceeded.

[oracle@db0118522509]$

 

SQL>col comp_name format a40

SQL>col comp_id format a10

SQL>col version format a20

SQL>col status format a30

SQL>col status format a6

SQL>set line 300

SQL>set pagesize 200

SQL>r

  1* select comp_id,comp_name,version,statusfrom dba_registry

 

COMP_ID    COMP_NAME                                VERSION              STATUS

-------------------------------------------------- -------------------- ------

EM         Oracle Enterprise Manager                11.2.0.4.0           VALID

OWB        OWB                                     11.2.0.3.0           VALID

APEX       Oracle Application Express               3.2.1.00.12          VALID

AMD        OLAP Catalog                             11.2.0.4.0           VALID

SDO        Spatial                                 11.2.0.4.0           VALID

ORDIM      Oracle Multimedia                        11.2.0.4.0           VALID

XDB        Oracle XML Database                      11.2.0.4.0           VALID

CONTEXT    Oracle Text                              11.2.0.4.0           VALID

EXF        Oracle Expression Filter                 11.2.0.4.0           VALID

RUL        Oracle Rules Manager                     11.2.0.4.0           VALID

OWM        Oracle Workspace Manager                 11.2.0.4.0           VALID

CATALOG    Oracle Database Catalog Views            11.2.0.4.0           VALID

CATPROC    Oracle Database Packages and Types       11.2.0.4.0           VALID

JAVAVM     JServer JAVA Virtual Machine             11.2.0.4.0           VALID

XML        Oracle XDK                               11.2.0.4.0           VALID

CATJAVA    Oracle Database Java Packages            11.2.0.4.0           VALID

APS        OLAP Analytic Workspace                  11.2.0.4.0           VALID

XOQ        Oracle OLAP API                          11.2.0.4.0           VALID

 

18 rowsselected.

四、至此我们看到数据库版本已经回滚到了11.2.0.4.0，说明回滚成功。