Oracle International Corporation

Ian Stuart Neall

Yunrui Li

Mahesh Baburao Girkar

Yi Ding

Giridhar Ravipati

Nitin Karkhanis

Sadhana Kyathappala

Jing Zheng

David Gagne

Shanshan Song

Qingguang Cui

Frank De Lange

German Shegalov

Steven J Mcgee

Herein is high availability for online transaction processing with redundancy and redo for a federation of pluggable databases and container databases. In a federation of container database management systems that includes a first container database, first redo data of a first pluggable database in a second container database is obtained based on a database dictionary in the first container database. To the first pluggable database in the first container database, the first redo data of the first pluggable database in the second container database is applied. Based on the database dictionary in the first container database, second redo data of a second pluggable database in a third container database is obtained. To the second pluggable database in the first container database, without modifying content of the first pluggable database in the first container database, the second redo data of the second pluggable database in the third container database is applied.

Data guard at PDB (pluggable database) level

A computer program product, system, and computer implemented method for automatic maintenance of standby databases for non-logged workloads, the process comprising: maintaining a redo stream of redo records sent from a primary database to a standby database, identifying a change made at the primary database for which a redo record was not created, inserting a placeholder redo record into the redo stream corresponding to the change identified at the primary database for which the redo record was not created, sending, to the standby database, a copy of one or more data blocks corresponding to the change that is associated with the placeholder redo record, receiving the placeholder redo record from the redo stream, identifying the copy of the one or more data blocks sent from the primary database corresponding to the placeholder redo record, and applying the copy of one or more data blocks to update the standby database.

Method and system for automatic maintenance of standby databases for non-logged workloads

Growing community of inventors

Kingwood, United Kingdom

Ian Stuart Neall