探索Oracle之数据库升级五 PSU11.2.0.4.3 rollback 11.2.0.4.0
来源:互联网 发布:网络被限制了怎么办 编辑:程序博客网 时间:2024/05/26 02:55
探索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,说明回滚成功。
0 0
- 探索Oracle之数据库升级五 PSU11.2.0.4.3 rollback 11.2.0.4.0
- 探索Oracle之数据库升级四 11.2.0.4.0 PSU 11.2.0.4.3
- 探索Oracle之数据库升级二 11.2.0.3升级到11.2.0.4完整步骤
- 探索Oracle之数据库升级三 回退升级操作(11.2.0.4Downgrade 11.2.0.3)
- 探索Oracle之数据库升级二11.2.0.3升级到11.2.0.4完整步骤
- 探索Oracle之数据库升级六 11.2.0.4.3 Upgrade12c(12.1.0.1)
- 探索Oracle之数据库升级一 升级补丁修复概述
- 探索Oracle之数据库升级二 11.2.0.3升级到11.2.0.4完整步骤--测试成功版本
- 如何如何打PSU补丁(11g RAC 升级11.2.0.2.1到最新的PSU11.2.0.2.4)
- 探索Oracle之数据库升级七 11gR2 to 12c 升级完成后插入PDB
- 探索Oracle之数据库升级八 12c Downgrade 11gR2
- 探索Oracle之数据库升级九 12.1.0.1 Update 12.1.0.2
- 探索Oracle之数据库升级十 12c(12.1.0.2)CPU 19774304
- oracle数据库升级11.2.0.3升级到11.2.0.4
- oracle数据库中commit和rollback命令
- Oracle数据库中commit和rollback命令
- Oracle性能优化之Rollback Segment优化
- MIDP2.0仕样探索之五
- dataload简单用法
- 加载UFT场景恢复
- mysql多表连接
- 第13条:以对象来管理资源
- 利用autobench测试web服务器极限并发数
- 探索Oracle之数据库升级五 PSU11.2.0.4.3 rollback 11.2.0.4.0
- C++ 异常
- IOS 监控网络变化
- XCode6.0中,如何使用XCode生成.ipa文件,以确定包尺寸?
- android开发一些实用类和方法
- FrangmentActivity和Activity的区别
- 程序设计:两个复数和差计算
- CSS让图片垂直居中的几种技巧
- MFC添加消息