# US 2025/0147982 A1 · Failover of database sessions to a logical replica database

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2025/0147982 A1
- Document ID: US20250147982A1
- Status: Published application
- Kind: A1
- Application number: 19/014,766
- Filed: 2025-01-09
- Published: 2025-05-08
- Earliest claimed: 2022-10-14
- Assignees: Oracle International Corporation
- Applicants: Oracle International Corporation
- Inventors: Carol Lyndall Colrain; Xiaoli Qi; Kevin S. Neel; Stephen J. Vivian; Michael Cusson; Yunrui Li; Jonathan Giloni
- Web page: https://patentgrep.com/patent/US20250147982A1

## CPC

- G06F 11/2097: {maintaining the standby controller/processing unit updated (initialisation or re-synchronisation thereof G06F11/1658 and subgroups)}
- G06F 16/275: {Synchronous replication}
- G06F 11/2023: {Failover techniques}
- G06F 11/2028: {eliminating a faulty processor or activating a spare}
- G06F 11/2038: {with a single idle spare processing component}
- G06F 11/2048: {where the redundant components share neither address space nor persistent storage}
- G06F 11/2094: {Redundant storage or storage space (G06F11/2056 takes precedence)}
- G06F 16/2322: {using timestamps}
- G06F 16/2379: {Updates performed during online database operations; commit processing}
- G06F 16/2455: Query execution
- G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F 2201/80: Database-specific techniques
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## 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.

## Claims

### Claim 1

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, thereby generating a modified object;
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.

### Claim 2 (depends on 1)

The method of claim 1, further comprising:
determining that the object was modified, after the particular database was started, thereby generating the modified object by identifying existence of object metadata associated with the object reference that indicates that the modified object was generated after the particular database was started.

### Claim 3 (depends on 2)

The method of claim 2, wherein the object reference includes the object metadata.

### Claim 4 (depends on 1)

The method of claim 1, wherein the object is a first object, and the object reference is a first object reference, the method further comprising:
receiving a request, from the client system, to retrieve a second object by a second object reference from the particular database;
based, at least in part, on determining that the second object reference is not associated with object metadata or that the second object reference is associated with second object metadata, which indicates that the second object was not modified after the particular database was started, determining that the second object was not modified after the particular database was started;
in response to determining that the second object was not modified after the particular database was started, retrieving the second object from the particular database using the second object reference and providing the second object to the client system, in response to the request to retrieve the second object by the second object reference.

### Claim 5 (depends on 1)

The method of claim 1, wherein the object is an LOB and the object reference is an LOB locator.

### Claim 6 (depends on 1)

The method of claim 1, further comprising:
receiving a request to modify the object on the primary database;
modifying the object to generate the modified object and storing the modified object on the primary database, thereby generating the object reference for the modified object stored on the primary database;
determining that the particular database is started, the particular database being a logical standby database of the primary database;
based, at least in part, on determining that the particular database was started, generating object metadata that indicates that the modified object was generated after the particular database was started.

### Claim 7 (depends on 6)

The method of claim 6, further comprising modifying the object reference to include the object metadata and providing the object reference to the client system.

### Claim 8 (depends on 1)

The method of claim 1, further comprising:
receiving a request to modify the object on the primary database;
modifying the object to generate the modified object and storing the modified object on the primary database, thereby generating the object reference for the modified object stored on the primary database;
determining that no logical standby database of the primary database is started;
based, at least in part, on determining that no logical standby database of the primary database is started, generating and providing the object reference to the client system without object metadata that indicates that the modified object was generated after starting any logical standby database of the primary database.

### Claim 9 (depends on 1)

The method of claim 1, wherein the object reference includes a timestamp.

### Claim 10 (depends on 9)

The method of claim 9, further comprising modifying the timestamp of the object reference to reflect the timestamp of starting the particular database.

### Claim 11

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, thereby generating a modified object;
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.

### Claim 12 (depends on 11)

The one or more non-transitory computer-readable media of claim 11, wherein the set of instructions further includes instructions, which when executed by said one or more hardware processors, cause:
determining that the object was modified, after the particular database was started, thereby generating the modified object by identifying existence of object metadata associated with the object reference that indicates that the modified object was generated after the particular database was started.

### Claim 13 (depends on 12)

The one or more non-transitory computer-readable media of claim 12, wherein the object reference includes the object metadata.

### Claim 14 (depends on 11)

The one or more non-transitory computer-readable media of claim 11, wherein the object is a first object, and the object reference is a first object reference, and wherein the set of instructions further includes instructions, which when executed by said one or more hardware processors, cause:
receiving a request, from the client system, to retrieve a second object by a second object reference from the particular database;
based, at least in part, on determining that the second object reference is not associated with object metadata or that the second object reference is associated with second object metadata, which indicates that the second object was not modified after the particular database was started, determining that the second object was not modified after the particular database was started;
in response to determining that the second object was not modified after the particular database was started, retrieving the second object from the particular database using the second object reference and providing the second object to the client system, in response to the request to retrieve the second object by the second object reference.

### Claim 15 (depends on 11)

The one or more non-transitory computer-readable media of claim 11, wherein the object is an LOB and the object reference is an LOB locator.

### Claim 16 (depends on 11)

The one or more non-transitory computer-readable media of claim 11, wherein the set of instructions further includes instructions, which when executed by said one or more hardware processors, cause:
receiving a request to modify the object on the primary database;
modifying the object to generate the modified object and storing the modified object on the primary database, thereby generating the object reference for the modified object stored on the primary database;
determining that the particular database is started, the particular database being a logical standby database of the primary database;
based, at least in part, on determining that the particular database was started, generating object metadata that indicates that the modified object was generated after the particular database was started.

### Claim 17 (depends on 16)

The one or more non-transitory computer-readable media of claim 16, wherein the set of instructions further includes instructions, which when executed by said one or more hardware processors, cause modifying the object reference to include the object metadata and providing the object reference to the client system.

### Claim 18 (depends on 11)

The one or more non-transitory computer-readable media of claim 11, wherein the set of instructions further includes instructions, which when executed by said one or more hardware processors, cause:
receiving a request to modify the object on the primary database;
modifying the object to generate the modified object and storing the modified object on the primary database, thereby generating the object reference for the modified object stored on the primary database;
determining that no logical standby database of the primary database is started;
based, at least in part, on determining that no logical standby database of the primary database is started, generating and providing the object reference to the client system without object metadata that indicates that the modified object was generated after starting any logical standby database of the primary database.

### Claim 19 (depends on 11)

The one or more non-transitory computer-readable media of claim 11, wherein the object reference includes a timestamp.

### Claim 20 (depends on 19)

The one or more non-transitory computer-readable media of claim 19, wherein the set of instructions further includes instructions, which when executed by said one or more hardware processors, cause modifying the timestamp of the object reference to reflect the timestamp of starting the particular database.
