探索Oracle之数据库升级五PSU11.2.0.4.3rollback11.2.0.

页面导航:首页 > 数据库 > oracle > 探索Oracle之数据库升级五PSU11.2.0.4.3rollback11.2.0.

探索Oracle之数据库升级五PSU11.2.0.4.3rollback11.2.0.

来源: 作者: 时间:2016-01-29 09:07 【

探索Oracle之数据库升级五PSU11 2 0 4 3 rollback 11 2 0 4 0 一、进入PSU目录,执行opatch rollback [[email protected]~] su - oracle[[email protected]~]$ lsc18522509 Desktop OPatch p1852250

探索Oracle之升级五

PSU11.2.0.4.3 rollback 11.2.0.4.0

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

[[email protected]~]# su - oracle

[[email protected]~]$ ls

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

[[email protected]~]$ cd 18522509/

[[email protected]]$ ls

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

[[email protected]]$ clear

[[email protected]]$ /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.

[[email protected]]$

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

[[email protected]]$ 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.

三、检查回滚后的版本:

[[email protected]]$ /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.

[[email protected]]$

 

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  Packages            11.2.0.4.0           VALID

APS        OLAP Analytic Workspace                  11.2.0.4.0           VALID

XOQ         OLAP API                          11.2.0.4.0           VALID

 

18 rowsselected.

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

Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<