Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need suggestions on minimizing downtime due to patching (ideally Zero downtime)

User_3JKO9May 26 2016 — edited May 31 2016

A customer has a large RAC installation but business pressure is now requiring the IT group to really deliver High Availability for their database.

The problem is that current crop of CPU patches have included OJVM patches which require a downtime. Customer is not happy that they have to take an outage even after implementing an MAA.

Are there any options for getting away from the downtime for applying OJVM patches? As per doc Id 1929745.1, OJVM patches cannot be applied in Rolling fashion in a RAC environment nor in a Standby First in a dataguard setup.


How about using GoldenGate to keep a standby database copy updated which can be shutdown for patch application and then brought up and the applications switched to that db? It will also probably need some application downtime to switch but I am assuming that is much smaller than 3-5 hours which the customer goes through every quarter.


Thanks in advance.


Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 28 2016
Added on May 26 2016
3 comments
1,144 views