In this article, we are going to see the steps to rollback a patch from RAC 12c standard cluster. Make sure you have all the cluster services up and running before starting the rollback.
1. Make sure you have all the cluster services up and running.
/u01/app/12.1.0/grid_1/bin/crsctl status res -t
[root@askmrac1 ~]# /u01/app/12.1.0/grid_1/bin/crsctl status res -t2. Use the following syntax to rollback the patch from 12c standard cluster home.
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE askmrac1 STABLE
ONLINE ONLINE askmrac2 STABLE
ONLINE ONLINE askmrac3 STABLE
ora.OCR_VOTE.dg
ONLINE ONLINE askmrac1 STABLE
ONLINE ONLINE askmrac2 STABLE
ONLINE ONLINE askmrac3 STABLE
ora.asm
ONLINE ONLINE askmrac1 Started,STABLE
ONLINE ONLINE askmrac2 Started,STABLE
ONLINE ONLINE askmrac3 Started,STABLE
ora.net1.network
ONLINE ONLINE askmrac1 STABLE
ONLINE ONLINE askmrac2 STABLE
ONLINE ONLINE askmrac3 STABLE
ora.ons
ONLINE ONLINE askmrac1 STABLE
ONLINE ONLINE askmrac2 STABLE
ONLINE ONLINE askmrac3 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE askmrac2 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE askmrac2 169.254.200.16 10.10
.10.232,STABLE
ora.askmrac1.vip
1 ONLINE ONLINE askmrac1 STABLE
ora.askmrac2.vip
1 ONLINE ONLINE askmrac2 STABLE
ora.askmrac3.vip
1 ONLINE ONLINE askmrac3 STABLE
ora.cvu
1 ONLINE ONLINE askmrac2 STABLE
ora.oc4j
1 ONLINE ONLINE askmrac3 STABLE
ora.orcl.db
1 ONLINE ONLINE askmrac1 Open,STABLE
2 ONLINE ONLINE askmrac2 Open,STABLE
3 ONLINE ONLINE askmrac3 Open,STABLE
ora.scan1.vip
1 ONLINE ONLINE askmrac2 STABLE
--------------------------------------------------------------------------------
[root@askmrac1 ~]# /u01/app/12.1.0/grid_1/bin/crsctl status res -t | grep -i offline
[root@askmrac1 ~]#
opatchauto rollback <patch location>
[root@askmrac1 ~]# which opatchauto
/u01/app/12.1.0/grid_1/OPatch/opatchauto
[root@askmrac1 ~]# opatchauto rollback /mnt/software/RAC/1201_PSU/17272829
OPatch Automation Tool
Copyright (c) 2013, Oracle Corporation. All rights reserved.
OPatchauto version : 12.1.0.1.2
OUI version : 12.1.0.1.0
Running from : /u01/app/12.1.0/grid_1
opatchauto log file: /u01/app/12.1.0/grid_1/cfgtoollogs/opatchauto/17272829/opatch_gi_2014-03-08_05-34-09_deploy.log
Parameter Validation: Successful
Grid Infrastructure home:
/u01/app/12.1.0/grid_1
RAC home(s):
/u01/app/oracle/product/12.1.0/dbhome_1
Configuration Validation: Successful
Patch Location: /mnt/software/RAC/1201_PSU/17272829
Grid Infrastructure Patch(es): 17027533 17077442 17303297
RAC Patch(es): 17027533 17077442
Patch Validation: Successful
Stopping RAC (/u01/app/oracle/product/12.1.0/dbhome_1) ... Successful
Following database(s) were stopped and will be restarted later during the session: orcl
Rolling back patch(es) from"/u01/app/oracle/product/12.1.0/dbhome_1" ...
Patch "17027533,17077442" successfully rolled back from "/u01/app/oracle/product/12.1.0/dbhome_1".
Stopping CRS ... Successful
Rolling back patch(es) from"/u01/app/12.1.0/grid_1" ...
Patch "17027533,17077442,17303297" successfully rolled back from "/u01/app/12.1.0/grid_1".
Starting CRS ... Successful
Starting RAC (/u01/app/oracle/product/12.1.0/dbhome_1) ... Successful
[WARNING] SQL changes, if any, could not be rolled back on the following database(s): ORCL ... Please refer to the log file for more details.
Rollback Summary:
Following patch(es) are successfully rolled back:
GI Home: /u01/app/12.1.0/grid_1: 17027533, 17077442, 17303297
RAC Home: /u01/app/oracle/product/12.1.0/dbhome_1: 17027533, 17077442
opatchauto succeeded.
[root@askmrac1 ~]#
Use the above syntax to rollback the patch from grid home and database home on all other cluster nodes.
3. Verify that the patch is rolledback.
From Grid Home:
[root@askmrac1 ~]# su - grid
[grid@askmrac1 ~]$ opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.2
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/12.1.0/grid_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid_1/oraInst.loc
OPatch version : 12.1.0.1.2
OUI version : 12.1.0.1.0
Log file location : /u01/app/12.1.0/grid_1/cfgtoollogs/opatch/opatch2014-03-08_06-11-01AM_1.log
Lsinventory Output file location : /u01/app/12.1.0/grid_1/cfgtoollogs/opatch/lsinv/lsinventory2014-03-08_06-11-01AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Grid Infrastructure 12c 12.1.0.1.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Patch level status of Cluster nodes :
Patching Level Nodes
-------------- -----
0 askmrac3,askmrac2,askmrac1
--------------------------------------------------------------------------------
OPatch succeeded.
[grid@askmrac1 ~]$
From Oracle Home :
[root@askmrac1 ~]# su - oracle
[oracle@askmrac1 ~]$ opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.2
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.1.0.1.2
OUI version : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2014-03-08_06-11-27AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2014-03-08_06-11-27AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.1.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = askmrac1
Remote node = askmrac2
Remote node = askmrac3
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@askmrac1 ~]$
Please see my other articles on how to apply PSU patches to standard cluster and flex cluster.
RAC 12c : JAN2014 PSU to 4 node flex cluster
RAC : Apply PSU patch to Standard Cluster 12c
Hope This Helps
SRI
Posts
Post a Comment
Thank you for visiting our site and leaving your valuable comment.