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:
Dec. 27, 2011
Filed:
Dec. 12, 2007
Joydip Kundu, Derry, NH (US);
Anthony Adams, Mason, NH (US);
Goutam Kulkarni, Nashua, NH (US);
Roger Macnicol, Hollis, NH (US);
Douglas Voss, Nashua, NH (US);
Qinqin Wang, Nashua, NH (US);
Joydip Kundu, Derry, NH (US);
Anthony Adams, Mason, NH (US);
Goutam Kulkarni, Nashua, NH (US);
Roger MacNicol, Hollis, NH (US);
Douglas Voss, Nashua, NH (US);
Qinqin Wang, Nashua, NH (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
A method and system that annotates a redo log to provide information concerning the execution of a procedure at a primary database. The annotations include entry and exit markers that indicate the beginning and the end of the execution along with any arguments passed to the procedure, and whether the execution of the procedure was successful. At the standby database, these markers are used to create a logical transaction associated with the procedure. The operations performed by the procedure are grouped into individual transactions, and these individual transactions are grouped as belonging to the logical transaction. If the execution of the procedure was successful at the primary database, then the individual transactions are discarded, and the logical transaction is applied by executing the procedure at the standby database. If the execution of the procedure failed at the primary database, then the individual transactions and the logical transaction are discarded.