公开(公告)号：US20240126785A1

公开(公告)日：2024-04-18

申请号：US18379684

申请日：2023-10-13

Applicant: Oracle International Corporation

Inventor： Carol Lyndall Colrain ,  Xiaoli Qi ,  Kevin S. Neel ,  Stephen J. Vivian ,  Michael Cusson ,  Yunrui Li ,  Jonathan Giloni

IPC: G06F16/27 ,  G06F11/20 ,  G06F16/23

CPC classification number: G06F16/275 ,  G06F11/2023 ,  G06F16/2322 ,  G06F16/2379 ,  G06F2201/80

Abstract: Techniques are described for preserving the inflight sessions failing over from a primary database to the replicated logical database of the primary database. In an implementation, prior to failover, when the primary database server receives a commit for a transaction, the process stores a commit indication that the transaction has been committed by performing a corresponding SQL command. The commit indication is replicated to the logical replica database by virtue of the replication of the SQL command and its execution on the logical replica database. Accordingly, the standby database server in the failover session may successfully request for the outcome of the transaction. Techniques are also described for the client-side LOB references to be preserved when failing over to the logical replica database, for AS OF queries preserved, and for versioning of checksums, signatures and structures across logical replicas.

公开(公告)号：US12204558B2

公开(公告)日：2025-01-21

申请号：US18379684

申请日：2023-10-13

Applicant: Oracle International Corporation

Inventor： Carol Lyndall Colrain ,  Xiaoli Qi ,  Kevin S. Neel ,  Stephen J. Vivian ,  Michael Cusson ,  Yunrui Li ,  Jonathan Giloni

IPC: G06F16/27 ,  G06F11/20 ,  G06F16/23 ,  G06F16/2455

Abstract: Techniques are described for preserving the inflight sessions failing over from a primary database to the replicated logical database of the primary database. In an implementation, prior to failover, when the primary database server receives a commit for a transaction, the process stores a commit indication that the transaction has been committed by performing a corresponding SQL command. The commit indication is replicated to the logical replica database by virtue of the replication of the SQL command and its execution on the logical replica database. Accordingly, the standby database server in the failover session may successfully request for the outcome of the transaction. Techniques are also described for the client-side LOB references to be preserved when failing over to the logical replica database, for AS OF queries preserved, and for versioning of checksums, signatures and structures across logical replicas.

公开(公告)号：US20250147982A1

公开(公告)日：2025-05-08

申请号：US19014766

申请日：2025-01-09

Applicant: Oracle International Corporation

Inventor： Carol Lyndall Colrain ,  Xiaoli Qi ,  Kevin S. Neel ,  Stephen J. Vivian ,  Michael Cusson ,  Yunrui Li ,  Jonathan Giloni

IPC: G06F16/27 ,  G06F11/20 ,  G06F16/23 ,  G06F16/2455

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.