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;

相关内容

热门资讯

女子身份证丢失后名下出现“吸毒... 四川籍的庞女士定居浙江宁波多年,她怎么也没想到,因丢失身份证一事,竟让她陷入长达7年“自证清白”的困...
省农科院成功研发我省首个高粱全... 近日,记者从省农科院获悉,该院作物资源研究所、农业生物技术研究所联合石家庄博瑞迪生物,成功研制出省内...
消息称AMD与Anthropi... IT之家 7 月 22 日消息,据华尔街日报消息,AMD 与 Anthropic 达成了一项价值数百...
独家!苹果iPhone18系列... 7月22日,中国证券报记者从产业链人士处独家获悉,进入7月,苹果iPhone 18系列手机已在量产,...
29岁的党鑫蕊倒在广西泥泞山路... 7月11日晚一通叮嘱,成了父子最后的对话;几天后父亲在殡仪馆见到一身泥的儿子,才知道“他走得有多难。...
时隔一年,英国国防大臣斯特里廷... 一年前,当时还是英国卫生大臣的韦斯·斯特里廷(Wes Streeting)曾公开指责以色列犯下战争罪...
微软与Mistral宣布扩大战... 【CNMO科技消息】7月22日,据韩媒报道,微软与法国AI企业Mistral正式宣布大幅扩大双方战略...
东方空间引力一号(遥四)运载火... 本报讯 (记者袁传玺)北京时间7月22日10时54分,东方空间引力一号(遥四)·星联体号运载火箭在我...
“你的手上沾满鲜血”,美防长出... 当地时间21日,美国国防部长赫格塞思在出席国会参议院听证会时表示,根据最新估算,美国对伊朗战事的花费...
Kimi K3让美国羡慕又不甘... 北京时间7月17日凌晨,月之暗面公司发布开源大模型Kimi K3。据报道,该模型总参数规模达2.8万...