Re: Backout options after applying patches on 4 node production RAC

I am working in an environment which is a 8 node RAC on 10.2.0.3 with 19 patches . Most of them have been applied in a rolling manner. Tonight I have to apply 4 more patches and all of them will be applied in a rolling manner.    

  The process is simple    

  Shutdown services on node a
  shutdown abort the instance on node a   opatch apply -local -oh /opt/oracle/product/10.2.0/db_1   startup the instance    

  So on and so forth across all 8 nodes.    

  After all 8 nodes are patched check that the checksum of the oracle executable is the same across all nodes.    

  The process will take atmost 2 hours. So I am wondering why it should take 10 hours in your case    

  Thanks
  Fairlie

Roman Podshivalov <roman.podshivalov_at_gmail.com> wrote:

    Hi,    

  Here is what we have done in the past:

• backup of Oracle home + oraInventory before the change on each node
• opatch apply -local on one node at a time - to minimize impact and application downtime because app can still work on unpatched nodes. Also if you hit any installation errors effect will be local to a single node - hopefully.

  The real downtime stats when you approach the last node. But it's still minimal because once you shut it down you can immediately bring up rest of already patched nodes, if you don't need to run anything in the database, but if you do - you can bring up just a single node and do it, especially if you need to do it with clustered_database parameter set to false - like it was the case with earlier security patch installations.    

  And for 10g there is rolling patch apply - but I've never personally tried it.    

  --romas  

  On 2/20/08, Anurag Verma <anuragdba_at_gmail.com> wrote:   Hi All,   

One questions on patching on RAC database.   We will be patching our 4 node production RAC this weekend.    

  The database is in 10.2.0.3.0 and the patches are a couple of one-off streams patches and not any major patches. Only difficulty we found is that long time, it takes for applying each patches. (Total time around 10 hours).   I was thinking about various backout options.   One is rolling back the applied patches, if something goes wrong.   Also, another plan is to take a backup of ORacle home from the production RAC nodes.   And if we need to backout, just untar the Oracle home backup tar file to the oracle home directory.   Please let me know if you have any suggestions.   

Thanks,

-- 

Anurag Verma,
Database Administrator
ERCOT(Electric Reliability Council of Texas),
Texas 76574 




          Fairlie Rego
Senior Oracle Consultant
  http://el-caro.blogspot.com/
  M: +61 402 792 405
   






       
---------------------------------
Get the name you always wanted with the new y7mail email address..
--
http://www.freelists.org/webpage/oracle-l