Failover of database sessions to a logical replica database
AssigneeOracle International Corporation
InventorsCarol Lyndall Colrain, Xiaoli Qi, Kevin S. Neel, Stephen J. Vivian, Michael Cusson, Yunrui Li, Jonathan Giloni
Life of this patent
Estimating the term…
Abstract
Techniques are described for failing over from a primary database to the replicated logical database of the primary database. Techniques are also described for the client-side object references to be preserved when failing over to the logical replica database, for AS OF and other queries preserved, and for versioning of checksums, signatures and structures across logical replicas.
Claims20
A computer-implemented method comprising:
- receiving a request, from a client system, to retrieve an object by an object reference from a particular database;
- determining that the object was modified, after the particular database was logically replicated and that a modified object was generated;
- wherein the particular database was replicated as a logical replica database of a primary database;
- based, at least in part, on determining that the object was modified after the particular database was replicated:
- determining whether the modified object was generated at the particular database or the primary database;
- if it is determined that the modified object was generated at the particular database rather than at the primary database, retrieving the modified object from the particular database using the object reference and providing the modified object to the client system, in response to the request to retrieve the object by the object reference;
- if it is determined that the modified object was generated at the primary database rather than at the particular database, responding, to the client system, with failure, in response to the request to retrieve the object by the object reference.
One or more non-transitory computer-readable media storing a set of instructions, wherein the set of instructions includes instructions, which when executed by one or more hardware processors, cause:
- receiving a request, from a client system, to retrieve an object by an object reference from a particular database;
- determining that the object was modified, after the particular database was logically replicated and that a modified object was generated;
- wherein the particular database was replicated as a logical replica database of a primary database;
- based, at least in part, on determining that the object was modified after the particular database was replicated:
- determining whether the modified object was generated at the particular database or the primary database;
- if it is determined that the modified object was generated at the particular database rather than at the primary database, retrieving the object from the particular database using the object reference and providing the object to the client system, in response to the request to retrieve the object by the object reference;
- if it is determined that the modified object was generated at the primary database rather than at the particular database, responding, to the client system, with failure, in response to the request to retrieve the object by the object reference.
Dependencies are inferred from the claim text.