重庆思庄Oracle、Redhat认证学习论坛

标题: oracle 12C PSU回退 [打印本页]

作者: miss_puff    时间: 2017-12-21 15:05
标题: oracle 12C PSU回退
12c应用补丁不再使用ocm.rsp文件,回退补丁也不再需要该文件,直接rollback跟psu号就可以了,如下:
[root@rac01 psu]# /u01/app/grid/product/12.2.0/grid/OPatch/opatchauto rollback 26133434/

OPatchauto session is initiated at Wed Aug  2 11:51:16 2017

System initialization log file is /u01/app/grid/product/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2017-08-02_11-51-22AM.log.

Session log file is /u01/app/grid/product/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2017-08-02_11-52-42AM.log
The id for this session is DU38

Executing OPatch prereq operations to verify patch applicability on home /u01/app/grid/product/12.2.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/db_2
Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_2

Patch applicability verified successfully on home /u01/app/grid/product/12.2.0/grid


Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/db_2
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db_2


Preparing to bring down database service on home /u01/app/oracle/product/12.2.0/db_2
Successfully prepared home /u01/app/oracle/product/12.2.0/db_2 to bring down database service


Bringing down CRS service on home /u01/app/grid/product/12.2.0/grid
Prepatch operation log file location: /u01/app/grid/base/crsdata/rac01/crsconfig/crspatch_rac01_2017-08-02_12-00-49AM.log
CRS service brought down successfully on home /u01/app/grid/product/12.2.0/grid


Performing prepatch operation on home /u01/app/oracle/product/12.2.0/db_2
Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/db_2


Start rolling back binary patch on home /u01/app/oracle/product/12.2.0/db_2
Binary patch rolled back successfully on home /u01/app/oracle/product/12.2.0/db_2


Performing postpatch operation on home /u01/app/oracle/product/12.2.0/db_2
Postpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/db_2


Start rolling back binary patch on home /u01/app/grid/product/12.2.0/grid
Binary patch rolled back successfully on home /u01/app/grid/product/12.2.0/grid


Starting CRS service on home /u01/app/grid/product/12.2.0/grid
Postpatch operation log file location: /u01/app/grid/base/crsdata/rac01/crsconfig/crspatch_rac01_2017-08-02_12-10-41AM.log
CRS service started successfully on home /u01/app/grid/product/12.2.0/grid


Preparing home /u01/app/oracle/product/12.2.0/db_2 after database service restarted
No step execution required.........
Prepared home /u01/app/oracle/product/12.2.0/db_2 successfully after database service restarted


Trying to roll back SQL patch on home /u01/app/oracle/product/12.2.0/db_2
SQL patch rolled back successfully on home /u01/app/oracle/product/12.2.0/db_2

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:rac01
RAC Home:/u01/app/oracle/product/12.2.0/db_2
Summary:

==Following patches were SKIPPED:

Patch: /psu/26133434/25586399
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /psu/26133434/26002778
Reason: This Patch does not exist in the home, it cannot be rolled back.


==Following patches were SUCCESSFULLY rolled back:

Patch: /psu/26133434/26123830
Log: /u01/app/oracle/product/12.2.0/db_2/cfgtoollogs/opatchauto/core/opatch/opatch2017-08-02_12-02-38PM_1.log


Host:rac01
CRS Home:/u01/app/grid/product/12.2.0/grid
Summary:

==Following patches were SUCCESSFULLY rolled back:

Patch: /psu/26133434/26002778
Log: /u01/app/grid/product/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-08-02_12-04-14PM_1.log

Patch: /psu/26133434/25586399
Log: /u01/app/grid/product/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-08-02_12-04-14PM_1.log

Patch: /psu/26133434/26123830
Log: /u01/app/grid/product/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-08-02_12-04-14PM_1.log



OPatchauto session completed at Wed Aug  2 12:23:01 2017
Time taken to complete the session 31 minutes, 45 seconds
[root@rac01 psu]#

作者: 郑全    时间: 2017-12-22 11:49
那就是更方便了.但没有看到是否需要回滚的提示,是否容易出现误操作.




欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2