OracleRAC手动回滚补丁

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

   

   岫岩ssl适用于网站、小程序/APP、API接口等需要进行数据传输应用场景，ssl证书未来市场广阔！成为成都创新互联的ssl证书销售渠道，可以享受市场价格4-6折优惠！如果有意向欢迎电话联系或者加微信：18980820575（备注：SSL证书合作）期待与您的合作！

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

3. Roll back the CRS patch. As the GI home owner execute:
   $ /OPatch/opatch rollback -local -id -oh
   $ /OPatch/opatch rollback -local -id -oh
   $ /OPatch/opatch rollback -local -id -oh

4. Run the pre script for DB component of the patch. As the database home owner execute:
   $ ///custom/server//custom/scripts/prepatch.sh -dbhome

5. Roll back the DB patch from the database home. As the database home owner execute:
   $ /OPatch/opatch rollback -local -id -oh
   $ /OPatch/opatch rollback -local -id -oh

6. Run the post script for DB component of the patch. As the database home owner execute:
   $ ///custom/server//custom/scripts/postpatch.sh -dbhome

7. Run the post script. As the root user execute:
   /rdbms/install/rootadd_rdbms.sh
   If this is a GI Home, as the root user execute:
   /crs/install/rootcrs.pl -patch
   If this is an Oracle Restart Home, as the root user execute:
   /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:
   $ /bin/srvctl start home -o -s -n
   If this is an Oracle Restart Home environment, as the database home owner execute:
   $ /bin/srvctl start home -o -s

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;