CPC G06F 16/2365 (2019.01) [G06F 16/27 (2019.01)] | 13 Claims |
1. A method for creating a standby database with read/write access capability while also maintaining a data consistency with a primary database, the method comprising:
syncing, by a processor of a computing system, the primary database with a physical standby mirror existing on the standby database, wherein a first data object and a second data object written to the primary database from a live application is synced in a read only access on the physical standby mirror;
creating, by the processor, a first data compartment and a second data compartment on the standby database, the first and second data compartments being standby database instances with direct read-write capability that are separate from the physical standby mirror and created by cloning a compartment of the physical standby mirror;
applying, by the processor, a change made to the first data object on the primary database to the corresponding first data object on the physical standby mirror; and
changing, by the processor, the corresponding first data object stored on the first data compartment in accordance with data merge rules associated with the first data compartment to keep the data stored on the first data compartment updated in real-time and in sync with the physical standby mirror,
wherein the data merge rules associated with the first data compartment and the second data compartment specify which objects, tablespaces, and the schemas stored on the first data compartment and the second data compartment, respectively, should be filtered or excluded from being synchronized with the physical standby mirror to create a redo stream associated with each data compartment, and
wherein the first data compartment and the second data compartment internally dequeues the redo stream in a sequential order and remaps object identifiers of the redo stream.
|