Using Edition-Based Redefinition for Online Zero-Downtime Schema Changes

Editions are easily created

EBR (Edition-Based Redefinition)

Oracle states:

Edition-based redefinition (EBR) enables online application upgrade with uninterrupted availability of the application.

The Oracle GoldenGate 18c online documentation

Has information regarding the support of this:

 

GoldenGate 18c Chp 12

EBR April 2017 pdf

Oracle 19c EBR

https://docs.oracle.com/database/121/ADFNS/adfns_editions.htm#ADFNS020

http://ermanarslan.blogspot.com/2015/07/ebs-122-and-ebr-lets-make-demo.html

https://oracle-base.com/articles/12c/edition-based-redefinition-enhancements-12cr1

https://www.oracle.com/technetwork/database/features/availability/edition-based-redefinition-1-133045.pdf

Two excellent lessons from the developer of EBR:

https://www.youtube.com/watch?v=bClWlW6tsb4

 

https://www.youtube.com/watch?v=A2JGbQ839us

 

Forward, Reverse Cross Edition Triggers and Editioning Views – An integral part of ADOP

 

Editioning Views

<pre>CREATE OR REPLACE EDITIONING VIEW MRC.EMP# AS
SELECT ID AS ID,
       NAME AS NAME
  FROM EMP;

=========================================================================

youtube video series

Bryn LLewellyn

 

Lesson 1 Part 1       40:54

Lesson 1 Part 2        43:54

Lesson 2                      52:13

Structure of table change 1:30

 

Lesson 3 Part 1          41:20

1:09 What is “safe” in 

Patching is defined as DDL

Describe the experiment

 

Lesson 3 Part 2  48:00

 

Lesson 4 Part 1  41:05

 

Lesson 4 Part 2  50:03

 

Lesson 4 Part 3  57:59


Test