You want to install a database patch on your eight-node cluster by using Opatch with, the minimum amount of down time to your cluster nodes.
You have already been prompted for the first set of nodes and you replied with node names RACNODE1 RACNODE2, and RACNODE3.
Which two statements are true about the procedure for minimizing down time?
A.
The patch must be propagated to, applied, and the inventory updated on all the remaining nodes before restarting the instances on the first set of nodes.
B.
When the first set of nodes has been patched, the instances on the remaining nodes are shut down automatically by opatch.
C.
The instances must be started on the first set of nodes and then stopped on the remaining set to make certain that some nodes are always available.
D.
When the first set of nodes has been patched, the administrator is prompted to shut down the instances on the remaining nodes.
E.
The patch must be propagated to and the inventory updated on all the remaining nodes before restarting the instances on the first set of nodes.
Rolling Patch – OPatch Support for RAC (Doc ID 244241.1)
1 – RAC Patching methods
OPatch supports 3 different patch methods on a RAC environment:
Patching RAC as a single instance (All-Node Patch)
In this mode, OPatch applies the patch to the local node first, then propagates the patch to all the other nodes, and finally updates the inventory. All instances must be down during the whole patching process.
Patching RAC using a minimum down-time strategy (Min. Downtime Patch)
In this mode, OPatch patches the local node, asks users for a sub-set of nodes, which will be the first subset of nodes to be patched. After the initial subset of nodes are patched, Opatch propagates the patch to the other nodes and finally updates the inventory. The downtime would happen between the shutdown of the second subset of nodes and the startup of the initial subset of nodes patched.
Patching RAC using a rolling strategy – No down time (Rolling Patch)
With this method, there is no downtime. Each node would be patched and brought up while all the other nodes are up and running, resulting in no disruption of the system.
Minimum downtime
. Shutdown the Oracle instance on node 1
. Apply the patch to the RAC home on node 1
. Shutdown the Oracle instance on node 2
. Apply the patch to the RAC home on node 2
. Shutdown the Oracle instance on node 3
. At this point, instances on nodes 1 and 2 can be brought up
. Apply the patch to the RAC home on node 3
. Startup the Oracle instance on node 3
C) wrong, always available is not true ( question says minimal downtime, not no downtime )
A. FALSE, some nodes can be patched and up and running, while last set of nodes can be applyng patch while oracle home is down
D and E are the correct answers.
D y E
When you use the minimum down-time patching method, the following actions occur:
• The local node is always patched first.
• The local node is used as a base to patch the other nodes.
• The user is prompted for the first set of nodes to patch.
• For each node in this first set, the user is asked to stop the instance and then the patch is
propagated and applied to that node before continuing to the next node.
• When the first set of nodes has been patched, the user is asked to shut down Clusterware
on the remaining nodes. <<<<< Answer D
• The instances are stopped on the last set of remote nodes.
• The patch is propagated to the last set of nodes and the inventory is updated. <<<<< Answer E
• You can then start up the patched nodes (the first set of nodes) before patching the
remaining nodes.