探索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，说明回滚成功。
