OracleRAC手动回滚补丁

  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>

    岫岩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:
    <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;

分享名称：OracleRAC手动回滚补丁
文章链接：https://www.cdcxhl.com/article6/pijdog.html

成都网站建设公司_创新互联，为您提供网站策划、网站设计、标签优化、外贸网站建设、动态网站、企业网站制作

广告

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 创新互联

猜你还喜欢下面的内容

外贸网站制作

知识

各行业网站