探索Oracle之資料庫升級五 PSU11.2.0.4.3 rollback 11.2.0.4.0，oracle資料庫升級

探索Oracle之資料庫升級五 PSU11.2.0.4.3 rollback 11.2.0.4.0，oracle資料庫升級
探索Oracle之資料庫升級五PSU11.2.0.4.3 rollback 11.2.0.4.0

 

一、進入PSU目錄，執行opatch rollback

 

[root@db01~]# su - oracle[oracle@db01~]$ lsc18522509  Desktop OPatch p18522509_112040_Linux-x86-64.zip p6880880_112000_Linux-x86-64.zip  PatchSearch.xml  upgrade.log[oracle@db01~]$ cd 18522509/[oracle@db0118522509]$ ls17478514  18031668 18522509  patchmd.xml  README.html README.txt[oracle@db0118522509]$ clear[oracle@db0118522509]$ /home/oracle/OPatch/opatch rollback -id 18522509OracleInterim Patch Installer version 11.2.0.3.6Copyright(c) 2013, Oracle Corporation.  All rightsreserved.  OracleHome       : /DBSoft/Product/11.2.4/db_1CentralInventory : /DBSoft/oraInventory   from           : /DBSoft/Product/11.2.4/db_1/oraInst.locOPatchversion    : 11.2.0.3.6OUIversion       : 11.2.0.4.0Log 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   17478514Thefollowing 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]yUserResponded 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 inventoryOPatchfound 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 - ProductionSystem parameterfile is /DBSoft/Product/11.2.4/db_1/network/admin/listener.oraLogmessages written to /DBSoft/diag/tnslsnr/db01/listener/alert/log.xmlListeningon: (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                     LISTENERVersion                   TNSLSNR for Linux: Version11.2.0.4.0 - ProductionStartDate                04-OCT-2014 07:04:31Uptime                    0 days 0 hr. 0 min. 0 secTraceLevel               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListenerParameter File   /DBSoft/Product/11.2.4/db_1/network/admin/listener.oraListenerLog File        /DBSoft/diag/tnslsnr/db01/listener/alert/log.xmlListeningEndpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db01)(PORT=1521)))Thelistener supports no servicesThecommand completed successfully SQL>startupORACLEinstance started. TotalSystem Global Area 2872786944 bytesFixedSize                  2256712 bytesVariableSize            2634023096 bytesDatabaseBuffers          218103808 bytesRedoBuffers               18403328 bytesDatabasemounted.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 lsinventoryOracleInterim Patch Installer version 11.2.0.3.6Copyright(c) 2013, Oracle Corporation.  All rightsreserved.  OracleHome       : /DBSoft/Product/11.2.4/db_1CentralInventory : /DBSoft/oraInventory   from           :/DBSoft/Product/11.2.4/db_1/oraInst.locOPatchversion    : 11.2.0.3.6OUIversion       : 11.2.0.4.0Log 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.0Thereare 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 a40SQL>col comp_id format a10SQL>col version format a20SQL>col status format a30SQL>col status format a6SQL>set line 300SQL>set pagesize 200SQL>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           VALIDOWB        OWB                                     11.2.0.3.0           VALIDAPEX       Oracle Application Express               3.2.1.00.12          VALIDAMD        OLAP Catalog                             11.2.0.4.0           VALIDSDO        Spatial                                 11.2.0.4.0           VALIDORDIM      Oracle Multimedia                        11.2.0.4.0           VALIDXDB        Oracle XML Database                      11.2.0.4.0           VALIDCONTEXT    Oracle Text                              11.2.0.4.0           VALIDEXF        Oracle Expression Filter                 11.2.0.4.0           VALIDRUL        Oracle Rules Manager                     11.2.0.4.0           VALIDOWM        Oracle Workspace Manager                 11.2.0.4.0           VALIDCATALOG    Oracle Database Catalog Views            11.2.0.4.0           VALIDCATPROC    Oracle Database Packages and Types       11.2.0.4.0           VALIDJAVAVM     JServer JAVA Virtual Machine             11.2.0.4.0           VALIDXML        Oracle XDK                               11.2.0.4.0           VALIDCATJAVA    Oracle Database Java Packages            11.2.0.4.0           VALIDAPS        OLAP Analytic Workspace                  11.2.0.4.0           VALIDXOQ        Oracle OLAP API                          11.2.0.4.0           VALID 18 rowsselected.

 

四、至此我們看到資料庫版本已經復原到了11.2.0.4.0，說明復原成功。