Past Meetup

Oracle EBR for Zero Downtime Patching and Rollback [WORKSHOP]

This Meetup is past

5 people went

Location image of event venue

Details

This is free, one day workshop geared towards Oracle DBAs, and offered by Bryn Llewellyn, distinguished Oracle Product Manager (https://blogs.oracle.com/author/bryn-llewellyn).

WHAT:
Oracle Edition-Based Redefinition (EBR): Zero Downtime Application Patching and Rollback

WHEN:
December 10th, 9AM – 5PM

COST:
Free

WHERE:
Oracle Columbia Gateway Office

ADDRESS:
7031 Columbia Gateway Drive, Columbia, MD 21046

ROOM:
#1134

REGISTER HERE:
https://natcapoug.org/one-day-in-depth-seminar-on-oracle-databases-edition-based-redefinition/

DETAILS:
This free workshop is offered through the National Capital Area Oracle Users Group, Oracle, and Oraclewizard.com Inc.

In general, patching or upgrading the artifacts in an Oracle Database that jointly implement an application's backend involves changing two or more functionally dependent objects. Because each DDL autocommits, such changes inevitably imply that the system is mutually inconsistent once the patching begins and that its integrity is regained only when patching completes. Moreover, so called "hot patching" - doing CREATE or REPLACE on even a single object, while that object is among the set of objects in ordinary concurrent use by the application, is in general unsafe. Before EBR, your only option, therefore, was to take downtime. EBR allows you to create a semantic copy of the live system within the same database so that you can make your changes to this while the live system remains in uninterrupted use. A copy-on-write scheme is used so that only changed objects occupy space. Of course, the quota-consuming data must be mutually synchronized, transactionally, and without harming performance for ordinary users. EBR supports this too. This workshop explains how it all works.

Here is the URL to register. https://natcapoug.org/one-day-in-depth-seminar-on-oracle-databases-edition-based-redefinition/