11g 单实例回滚11.2.0.3.4 P14275605 PSU

1.11g升级11.2.3.0.4的PSU后会在$ORACLE_HOME/rdbms/admin目录
会产生catbundle_PSU_ORACLE_SID开头的两个脚本

[oracle@ora_11g ~]$ cd $ORACLE_HOME/rdbms/admin  
[oracle@ora_11g admin]$ ls -al catbundle*
-rw-r----- 1 oracle oinstall  1130 Dec 18 20:13 catbundle_PSU_TEST01_APPLY.sql
-rw-r----- 1 oracle oinstall  1139 Dec 18 20:13 catbundle_PSU_TEST01_ROLLBACK.sql
-rw-r--r-- 1 oracle oinstall 29922 Aug  8  2011 catbundle.sql

2.执行@catbundle_PSU_TEST01_ROLLBACK.sql回滚的SQL
[oracle@ora_11g ~]$ cd $ORACLE_HOME/rdbms/admin
[oracle@ora_11g admin]$ sqlplus  / as sysdba

SQL> @catbundle_PSU_TEST01_ROLLBACK.sql

1K5Yv8zE4fHTm44PjF7jdjo9NqiQTdgAWBoaVCMz+0l19LKtEhB1c3NDQrq5X/X/h4SWPtBFo
.
.
.
.
3115  7Shs+ikxqrHn2WfyvyKQxz+kzeTHI0IIu7WatSzEK8cx
3116  
3117  /

Package body created.

SQL> SHOW ERRORS;
No errors.
SQL> @?/patch/scripts/bug12904308.sql
SQL> Rem
SQL> Rem $Header: rdbms/admin/bug12904308.sql /st_rdbms_11.2.0.3.0dbpsu/1 2012/07/18 04:46:58 vpriyans Exp $
SQL> Rem
SQL> Rem bug12904308.sql
SQL> Rem
SQL> Rem Copyright (c) 2012, Oracle and/or its affiliates. All rights reserved.
SQL> Rem
SQL> Rem    NAME
SQL> Rem      bug12904308.sql - Audit CREATE/DROP DIRECTORY actions by default
SQL> Rem
SQL> Rem    DESCRIPTION
SQL> Rem      This file enables auditing for CREATE/DROP DIRECTORY actions
SQL> Rem
SQL> Rem    NOTES
SQL> Rem      <other useful comments, qualifications, etc.>
SQL> Rem
SQL> Rem    MODIFIED   (MM/DD/YY)
SQL> Rem    vpriyans    07/12/12 - Created
SQL> Rem
SQL> 
SQL> Rem --Enable Audit for CREATE/DROP DIRECTORY actions
SQL> AUDIT DIRECTORY BY ACCESS;

Audit succeeded.

SQL> 
SQL> ALTER SESSION SET current_schema = SYS;

Session altered.

SQL> PROMPT Updating registry...
Updating registry...
SQL> INSERT INTO registry$history
  2    (action_time, action,
  3     namespace, version, id,
  4     bundle_series, comments)
  5  VALUES
  6    (SYSTIMESTAMP, 'ROLLBACK',
  7     SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),
  8     '11.2.0.3',
  9     4,
 10     'PSU',
 11     'PSU 11.2.0.3.4');

1 row created.

SQL> COMMIT;

Commit complete.

3.关闭实例，监听，所有的相关的sqlplus
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down

4.使用opatch回滚14275605 PSU

[oracle@ora_11g ~]$ /opt/oracle/product/db_1/OPatch/opatch  rollback -id 14275605
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /opt/oracle/product/db_1
Central Inventory : /opt/oraInventory
   from           : /opt/oracle/product/db_1/oraInst.loc
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.3.0
Log file location : /opt/oracle/product/db_1/cfgtoollogs/opatch/14275605_Dec_18_2012_21_29_56/rollback2012-12-18_21-29-56PM_1.log


Patches will be rolled back in the following order: 
   14275605   13923374   13696216   13343438
The following patch(es) will be rolled back: 14275605  13923374  13696216  13343438  
Sub-patches of a composite series are being rolled back. The system will be returned to a state where all subpatches are rolled back.
The following bug fixes will be removed: 13099577,14076523,13699124,13612575,13566938,13358781,13773133,13705338,14480675,14409183,13059165,14613900,14664355,13430938,12585543,13624984,12794305,14548763,12594032,13377816,13397104,13080778,13649031,13257247,11708510,14480676,13250244,13476583,12583611,14275605,14480674,13804294,13464002,13484963,13550185,13385346,12693626,13737746,12971775,13384182,13718279,14390252,13572659,13467683,14062793,14062794,14062795,12401111,14062796,13502183,14062797,12797420,12913474,10133521,12678920,13340388,12976376,12617123,13923374,13457582,13103913,11840910,13527323,13035360,12879027,13588248,13419660,14038787,13001379,13370330,12658411,9761357,14063280,9858539,14063281,13981051,13366202,13903046,13657605,13338048,12535346,13916709,12646784,12880299,13326736,14062792,13036331,11877623,12845115,12829021,13554409,12923168,13742464,13332439,12780098,12656535,13070939,12960925,10350832,12612118,13696216,12919564,13632717,12780983,13742433,13742434,13742435,13742436,13742437,13742438,12588744,12748240,12894807,12764337,12582664,12662040,12849688,13354082,13420224,11063191,13772618,13503598,12998795,13466801,13492735,12834027,12620823,13035804,13362079,12718090,13528551,13041324,13343438,12917230,12847466,9703627,12797765,12950644,12905058,13499128,12861463,9873405,12938841

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/opt/oracle/product/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y

Rolling back patch 14275605...

RollbackSession rolling back interim patch '14275605' from OH '/opt/oracle/product/db_1'

Patching component oracle.network.client, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.precomp.common, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms.util, 11.2.0.3.0...
RollbackSession removing interim patch '14275605' from inventory

Rolling back patch 13923374...

RollbackSession rolling back interim patch '13923374' from OH '/opt/oracle/product/db_1'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.network.listener, 11.2.0.3.0...

Patching component oracle.sysman.console.db, 11.2.0.3.0...
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emDB.jar" with "/opt/oracle/product/db_1/.patch_storage/13923374_Jun_13_2012_00_02_44/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SPIAChecklistController.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emDB.jar" with "/opt/oracle/product/db_1/.patch_storage/13923374_Jun_13_2012_00_02_44/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SPIAExadataController.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emDB.jar" with "/opt/oracle/product/db_1/.patch_storage/13923374_Jun_13_2012_00_02_44/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SPIAOptimizerStatsController.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emDB.jar" with "/opt/oracle/product/db_1/.patch_storage/13923374_Jun_13_2012_00_02_44/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SPIAParameterChangeController.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emDB.jar" with "/opt/oracle/product/db_1/.patch_storage/13923374_Jun_13_2012_00_02_44/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SPIAUpgradeController.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emDB.jar" with "/opt/oracle/product/db_1/.patch_storage/13923374_Jun_13_2012_00_02_44/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/StsImExportController.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emDB.jar" with "/opt/oracle/product/db_1/.patch_storage/13923374_Jun_13_2012_00_02_44/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/DBMonitoringObject.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emDB.jar" with "/opt/oracle/product/db_1/.patch_storage/13923374_Jun_13_2012_00_02_44/files//sysman/jlib/emDB.jar/oracle/sysman/emo/perf/bean/spia/TrialsComparisonBean.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emdb_emjsp.jar" with "/opt/oracle/product/db_1/.patch_storage/13923374_Jun_13_2012_00_02_44/files//sysman/jlib/emdb_emjsp.jar/_database/_instance/_spia/_optimizerStats.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emdb_emjsp.jar" with "/opt/oracle/product/db_1/.patch_storage/13923374_Jun_13_2012_00_02_44/files//sysman/jlib/emdb_emjsp.jar/_database/_instance/_spia/_parameterChange.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emdb_emjsp.jar" with "/opt/oracle/product/db_1/.patch_storage/13923374_Jun_13_2012_00_02_44/files//sysman/jlib/emdb_emjsp.jar/_database/_instance/_spia/_sage.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emdb_emjsp.jar" with "/opt/oracle/product/db_1/.patch_storage/13923374_Jun_13_2012_00_02_44/files//sysman/jlib/emdb_emjsp.jar/_database/_instance/_spia/_trialComparison.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emdb_emjsp.jar" with "/opt/oracle/product/db_1/.patch_storage/13923374_Jun_13_2012_00_02_44/files//sysman/jlib/emdb_emjsp.jar/_database/_instance/_spia/_upgrade.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emdb_emjsp.jar" with "/opt/oracle/product/db_1/.patch_storage/13923374_Jun_13_2012_00_02_44/files//sysman/jlib/emdb_emjsp.jar/_database/_instance/_spia/_upgrade2.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emdb_emjsp.jar" with "/opt/oracle/product/db_1/.patch_storage/13923374_Jun_13_2012_00_02_44/files//sysman/jlib/emdb_emjsp.jar/_database/_instance/_sqlset/_stsExport.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emdb_emjsp.jar" with "/opt/oracle/product/db_1/.patch_storage/13923374_Jun_13_2012_00_02_44/files//sysman/jlib/emdb_emjsp.jar/_database/_instance/_sqlset/_stsImport.class"
RollbackSession removing interim patch '13923374' from inventory

Rolling back patch 13696216...

RollbackSession rolling back interim patch '13696216' from OH '/opt/oracle/product/db_1'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Patching component oracle.sysman.console.db, 11.2.0.3.0...
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emCORE.jar" with "/opt/oracle/product/db_1/.patch_storage/13696216_Apr_3_2012_22_02_51/files//sysman/jlib/emCORE.jar/oracle/sysman/eml/ecm/sc/Operator$BuiltInIds.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emCORE.jar" with "/opt/oracle/product/db_1/.patch_storage/13696216_Apr_3_2012_22_02_51/files//sysman/jlib/emCORE.jar/oracle/sysman/eml/ecm/sc/Operator$TokenSeparatorWords.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emCORE.jar" with "/opt/oracle/product/db_1/.patch_storage/13696216_Apr_3_2012_22_02_51/files//sysman/jlib/emCORE.jar/oracle/sysman/eml/ecm/sc/Operator$Parameters.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emCORE.jar" with "/opt/oracle/product/db_1/.patch_storage/13696216_Apr_3_2012_22_02_51/files//sysman/jlib/emCORE.jar/oracle/sysman/eml/ecm/sc/Operator$Tokenizations.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emDB.jar" with "/opt/oracle/product/db_1/.patch_storage/13696216_Apr_3_2012_22_02_51/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/schm/GrantObjPrivsController.class"
Updating jar file "/opt/oracle/product/db_1/sysman/jlib/emDB.jar" with "/opt/oracle/product/db_1/.patch_storage/13696216_Apr_3_2012_22_02_51/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/DBController.class"

Patching component oracle.sysman.oms.core, 10.2.0.4.4...
RollbackSession removing interim patch '13696216' from inventory

Rolling back patch 13343438...

RollbackSession rolling back interim patch '13343438' from OH '/opt/oracle/product/db_1'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
RollbackSession removing interim patch '13343438' from inventory

OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/opt/oracle/product/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
/opt/oracle/product/db_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/opt/oracle/product/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'


OPatch Session completed with warnings.
Log file location: /opt/oracle/product/db_1/cfgtoollogs/opatch/14275605_Dec_18_2012_21_29_56/rollback2012-12-18_21-29-56PM_1.log

OPatch completed with warnings.


到此完成回滚操作