Oracle RAC 手动回滚补丁

1. Stop the CRS managed resources running from DB homes.
   If this is a GI Home environment, as the database home owner execute:
   $ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>
   If this is an Oracle Restart Home environment, as the database home owner execute:
   $ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location>

2. Run the pre root script.
   If this is a GI Home, as the root user execute:
   <GI_HOME>/crs/install/rootcrs.pl -unlock
   If this is an Oracle Restart Home, as the root user execute:
   <GI_HOME>/crs/install/roothas.pl -unlock

3. Roll back the CRS patch. As the GI home owner execute:
   $ <GI_HOME>/OPatch/opatch rollback -local -id <OCW Components_number> -oh <GI_HOME>
   $ <GI_HOME>/OPatch/opatch rollback -local -id <ACFS Components_number> -oh <GI_HOME>
   $ <GI_HOME>/OPatch/opatch rollback -local -id <DB_PSU_number> -oh <GI_HOME>

4. Run the pre script for DB component of the patch. As the database home owner execute:
   $ <UNZIPPED_PATCH_LOCATION>/<GI_PSU_number>/<OCW Components_number>/custom/server/<OCW Components_number>/custom/scripts/prepatch.sh -dbhome <ORACLE_HOME>

5. Roll back the DB patch from the database home. As the database home owner execute:
   $ <ORACLE_HOME>/OPatch/opatch rollback -local -id <OCW Components_number> -oh <ORACLE_HOME>
   $ <ORACLE_HOME>/OPatch/opatch rollback -local -id <DB_PSU_number> -oh <ORACLE_HOME>

6. Run the post script for DB component of the patch. As the database home owner execute:
   $ <UNZIPPED_PATCH_LOCATION>/<GI_PSU_number>/<OCW Components_number>/custom/server/<OCW Components_number>/custom/scripts/postpatch.sh -dbhome <ORACLE_HOME>

7. Run the post script. As the root user execute:
   <GI_HOME>/rdbms/install/rootadd_rdbms.sh
   If this is a GI Home, as the root user execute:
   <GI_HOME>/crs/install/rootcrs.pl -patch
   If this is an Oracle Restart Home, as the root user execute:
   <GI_HOME>/crs/install/roothas.pl -patch

8. If the message, "A system reboot is recommended before using ACFS??? is shown, then a reboot must be issued before continuing. Failure to do so will result in running with an unpatched ACFS\ADVM\OKS driver.

9. Start the CRS managed resources that were earlier running from DB homes.
   If this is a GI Home environment, as the database home owner execute:
   $ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name>
   If this is an Oracle Restart Home environment, as the database home owner execute:
   $ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location>

1.关闭一节点数据库：

$ srvctl  stop home -o $ORACLE_HOME -s /tmp/stophome1.log -n rac2

2.锁定一节点GI：

  /u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock

3.回滚GI HOME下的补丁包，用GI用户执行：

$ $ORACLE_HOME/OPatch/opatch rollback -local -id 27441052 -oh $ORACLE_HOME
$ $ORACLE_HOME/OPatch/opatch rollback -local -id 22502505  -oh $ORACLE_HOME
$ $ORACLE_HOME/OPatch/opatch rollback -local -id 27338049 -oh $ORACLE_HOME 

4.用oracle用户使用脚本检测：

$/u01/app/stage/27475913/27441052/custom/server/27441052/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME 

5.回滚database home下的补丁包，用oracle用户执行：

 $ORACLE_HOME/OPatch/opatch rollback -local -id 27441052 -oh $ORACLE_HOME
 $ORACLE_HOME/OPatch/opatch rollback -local -id 27338049 -oh $ORACLE_HOME

6.执行脚本使用oracle用户：

$/u01/app/stage/27475913/27441052/custom/server/27441052/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME 

7.执行脚本使用root用户：

  /u01/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh 
 /u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch

8.开启节点实例：

$ srvctl start home -o $ORACLE_HOME -s /tmp/stophome1.log -n rac2

9.更新数据字典（单节点运行）：

---更新数据字典
SQL> @?/rdbms/admin/catbundle.sql psu apply
---编译java类
SQL> @?/rdbms/admin/utlrp.sql
 select * from dba_registry_history;