Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: Strategies to Apply Patch to RAC Instances

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

    Strategies to Apply Patch to RAC Instances

    1) Patching Oracle RAC Nodes Individually - High Availability (Rollover Patching)

    In Rolling Patching, each node is shut down, the patch is applied, then each node is brought back up again. This is done node by node separately until all nodes in Oracle RAC are patched. This is the most efficient mode of applying an interim patch to an Oracle RAC setup because this results in no downtime. Only some patches can be applied in this mode. The type is generally specified in the patch metadata.

    The main advantage of this type of patching is that there is absolutely no downtime while applying patches because only one system is brought down at any given time.

    This is best suited when we are applying one-off patches that support this methodology, and want to maintain high availability of your targets, so when one node is being patched, the other nodes are available for service.


    2) Patching Oracle RAC in Offline Mode

    a) Patching Oracle RAC Nodes Individually when each node has its own ORACLE_HOME (individual)

    Option 1 : In All Node Patching, all Oracle RAC nodes are initially brought down and the patch is applied on all the nodes, then all the nodes are brought back up. This mode is normally used for very critical patches and it leads to maximum downtime. OPatch uses this mode as the default for patch applications unless specified otherwise.

    Option 2 : In Minimum Downtime Patching, the nodes are divided into sets. Initially, the first set is shut down and the patch is applied to it. After this, the second set is shut down. The first set is brought up and patch is applied to the second set. The second set is also brought up now. All the nodes in the Real Application Clusters are now patched. This mode leads to less downtime for the Real Application Clusters when both the sets are brought down.


    b) Patching Oracle RAC Nodes Collectively - This needs to be done when we need to patch a shared ORACLE_HOME
    All Oracle RAC nodes are brought down and the patch is applied on one of the nodes, then all the nodes are brought back up.

    For details on how to use opatch refer to : Applying-database-patch-using-opatch-and-opatch-options&p=540#post540

+ Reply to Thread

Similar Threads

  1. Error in Starting the Apache after CU2 patch apply
    By mdmasood in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 4
    Last Post: 01-20-2012, 04:17 PM
  2. Apply Oracle Database Patch using opatch and opatch options
    By sneha in forum Database Installation,Upgrades,Migration,Patching and Cloning
    Replies: 3
    Last Post: 11-23-2011, 10:34 AM
  3. Distributed AD to apply a patch
    By Hemant in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 11-12-2011, 11:51 AM
  4. Apply HOT patch (without enabling maintenance mode / while services are running)
    By Amit in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 11-04-2011, 09:55 AM
  5. Apply the latest AutoConfig Template patch in 11i
    By Amit in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 11-03-2011, 05:46 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics