The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jan. 21, 2025
Filed:
Oct. 13, 2023
Oracle International Corporation, Redwood Shores, CA (US);
Carol Lyndall Colrain, Kansas City, KS (US);
Xiaoli Qi, Palo Alto, CA (US);
Kevin S. Neel, San Mateo, CA (US);
Stephen J. Vivian, Londonderry, NH (US);
Michael Cusson, Woburn, MA (US);
Yunrui Li, Los Altos, CA (US);
Jonathan Giloni, Foster City, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
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.