Oracle RAC 手动回滚补丁
admin
2023-01-25 18:24:09
0
  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

  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;

相关内容

热门资讯

德国总理:美国正在被伊朗羞辱 德国之声4月27日报道,德国总理默茨在访问一所学校时表示,在当前的持续冲突中,伊朗领导层正试图羞辱美...
理响中国|“长”歌以行,风云激... 光阴如梭,东方潮阔。这里是中国的长三角,世界的长三角。无论过去、现在还是未来,这片土地都因时代而生,...
白宫:特朗普及其国安团队开会讨... 新华社华盛顿4月27日电 美国白宫新闻秘书莱维特27日在记者会上证实,总统特朗普及其国家安全团队当天...
人民日报刊文:日本放开杀伤性武... 日本放开杀伤性武器出口推高地缘冲突风险(国际论坛)常思纯《人民日报》(2026年04月28日 第 0...
医疗保障法草案二审:明确生育保... 满足多样化健康保障需求本报记者 彭 波4月27日,医疗保障法草案二审稿提请十四届全国人大常委会第二十...
天津一景区发生自转旋翼机事故1... 澎湃新闻记者 吕新文中国民用航空华北地区管理局4月22日公布《豪客通航“10•1”天津长芦汉盐旅游区...
卡塔尔埃米尔与美国总统特朗普通... 当地时间24日,卡塔尔埃米尔塔米姆与美国总统特朗普通电话,重点就中东地区局势以及伊朗与美国谈判问题交...
男子30年前被扣押2859克黄... 澎湃新闻记者 王鑫家住辽宁省大连市的潘永嘉近日向澎湃新闻反映称,三十年前,他在大连周水子机场被盖州市...
商务部:取消反制欧盟两家金融机... 中华人民共和国商务部令二〇二六年 第1号鉴于欧盟已取消对中国两家金融机构的制裁措施,现公布《关于取消...
过去24小时共有5艘船只通过霍... 总台记者当地时间24日获悉,过去24小时内,共有5艘船只通过霍尔木兹海峡,其中包括一艘伊朗油轮。(总...