首页 > 数据库技术 > 详细

探索Oracle之数据库升级五 PSU 11.2.0.4.3 rollback 11.2.0.4.0

时间：2014-12-19 02:21:01      阅读：483      评论：0      收藏：0      [点我收藏+]

探索Oracle之数据库升级五

PSU 11.2.0.4.3 rollback 11.2.0.4.0

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

  1. [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

  1. [oracle@db0118522509]$ sqlplus / as sysdba

  3. SQL*Plus:Release 11.2.0.4.0 Production on Sat Oct 4 07:04:28 2014
  4. Copyright(c) 1982, 2013, Oracle. All rightsreserved.

  6. Connectedto an idle instance.

  8. SQL>!lsnrctl start

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

  12. Copyright(c) 1991, 2013, Oracle. All rightsreserved.
  13. Starting/DBSoft/Product/11.2.4/db_1/bin/tnslsnr: please wait...

  15. TNSLSNRfor Linux: Version 11.2.0.4.0 - Production
  16. System parameterfile is /DBSoft/Product/11.2.4/db_1/network/admin/listener.ora
  17. Logmessages written to /DBSoft/diag/tnslsnr/db01/listener/alert/log.xml
  18. Listeningon: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  19. Listeningon: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db01)(PORT=1521)))

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

  23. STATUSof the LISTENER
  24. ------------------------

  26. Alias LISTENER
  27. Version TNSLSNR for Linux: Version11.2.0.4.0 - Production
  28. StartDate 04-OCT-2014 07:04:31
  29. Uptime 0 days 0 hr. 0 min. 0 sec
  30. TraceLevel off
  31. Security ON: Local OS Authentication
  32. SNMP OFF
  33. ListenerParameter File /DBSoft/Product/11.2.4/db_1/network/admin/listener.ora
  34. ListenerLog File /DBSoft/diag/tnslsnr/db01/listener/alert/log.xml
  35. ListeningEndpoints Summary...
  36.  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  37.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db01)(PORT=1521)))
  38. Thelistener supports no services
  39. Thecommand completed successfully

  41. SQL>startup

  43. ORACLEinstance started.

  45. TotalSystem Global Area 2872786944 bytes
  46. FixedSize 2256712 bytes
  47. VariableSize 2634023096 bytes
  48. DatabaseBuffers 218103808 bytes
  49. RedoBuffers 18403328 bytes
  50. Databasemounted.
  51. Databaseopened.
  52. SQL>

  54. SQL>alter system register;

  56. Systemaltered.

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

  60. SQL>alter system register;

  62. Systemaltered.

  64. SQL>alter system register;

  66. Systemaltered.

三、检查回滚后的版本:

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

  3. OracleInterim Patch Installer version 11.2.0.3.6
  4. Copyright(c) 2013, Oracle Corporation. All rightsreserved.

  6. OracleHome : /DBSoft/Product/11.2.4/db_1
  7. CentralInventory : /DBSoft/oraInventory
  8.    from :/DBSoft/Product/11.2.4/db_1/oraInst.loc
  9. OPatchversion : 11.2.0.3.6
  10. OUIversion : 11.2.0.4.0
  11. Log filelocation : /DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/opatch2014-10-04_07-10-34AM_1.log
  12. LsinventoryOutput file location :/DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-10-04_07-10-34AM.txt

  14. --------------------------------------------------------------------------------
  15. InstalledTop-level Products (1):
  16. OracleDatabase 11g 11.2.0.4.0
  17. Thereare 1 product(s) installed in this Oracle Home.
  18. Thereare no Interim patches installed in this Oracle Home.
  19. --------------------------------------------------------------------------------
  20. OPatchsucceeded.

  22. [oracle@db0118522509]$

  24. SQL>col comp_name format a40
  25. SQL>col comp_id format a10
  26. SQL>col version format a20
  27. SQL>col status format a30
  28. SQL>col status format a6
  29. SQL>set line 300
  30. SQL>set pagesize 200
  31. SQL>select comp_id,comp_name,version,statusfrom dba_registry;

  33. COMP_ID COMP_NAME VERSION STATUS
  34. -------------------------------------------------- -------------------- ------

  36. EM Oracle Enterprise Manager 11.2.0.4.0 VALID
  37. OWB OWB 11.2.0.3.0 VALID
  38. APEX Oracle Application Express 3.2.1.00.12 VALID
  39. AMD OLAP Catalog 11.2.0.4.0 VALID
  40. SDO Spatial 11.2.0.4.0 VALID
  41. ORDIM Oracle Multimedia 11.2.0.4.0 VALID
  42. XDB Oracle XML Database 11.2.0.4.0 VALID
  43. CONTEXT Oracle Text 11.2.0.4.0 VALID
  44. EXF Oracle Expression Filter 11.2.0.4.0 VALID
  45. RUL Oracle Rules Manager 11.2.0.4.0 VALID
  46. OWM Oracle Workspace Manager 11.2.0.4.0 VALID
  47. CATALOG Oracle Database Catalog Views 11.2.0.4.0 VALID
  48. CATPROC Oracle Database Packages and Types 11.2.0.4.0 VALID
  49. JAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 VALID
  50. XML Oracle XDK 11.2.0.4.0 VALID
  51. CATJAVA Oracle Database Java Packages 11.2.0.4.0 VALID
  52. APS OLAP Analytic Workspace 11.2.0.4.0 VALID
  53. XOQ Oracle OLAP API 11.2.0.4.0 VALID

  55. 18 rowsselected.

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


探索Oracle之数据库升级五 PSU 11.2.0.4.3 rollback 11.2.0.4.0

原文：http://blog.itpub.net/20674423/viewspace-1371541/
踩
(0)
赞
(0)
   
举报
评论 一句话评论（0）
分享档案
更多>
2021年09月23日 (328)
2021年09月24日 (313)
2021年09月17日 (191)
2021年09月15日 (369)
2021年09月16日 (411)
2021年09月13日 (439)
2021年09月11日 (398)
2021年09月12日 (393)
2021年09月10日 (160)
2021年09月08日 (222)
最新文章
更多>
教程昨日排行
更多>
友情链接
汇智网   PHP教程   插件网  
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣，分享程序人生！