探索Oracle之資料庫升級五 PSU 11.2.0.4.3 rollback 11.2.0.4.0

dbhelper發表於2015-01-17
Oracle資料庫

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


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8494287/viewspace-1405559/，如需轉載，請註明出處，否則將追究法律責任。

相關文章