Patent ID: 8676752

Claim:
A method for replication of one or more procedures stored at a primary database to a standby database, wherein a procedure can correspond to multiple transactions executed as a unit, comprising for each procedure: when the procedure executes at the primary database, writing one or more entry markers as entries into a redo log at the primary database, the one or more entry markers comprising: procedure information, argument data for the procedure if any, and a corresponding transaction identifier; writing a plurality of redo records as entries into the redo log, at least one of the redo records comprising a copy of a change to the primary database and a corresponding transaction identifier; and when the procedure is done executing, writing an exit marker as an entry into the redo log, the exit marker comprising an exit status for the procedure indicating whether the procedure was successfully executed at the primary database, wherein the entry markers, the redo records, and the exit marker are sent to the standby database which is configured to group the transactions associated with the redo records into a procedure based at least in part upon the entry and exit markers such that the changes of the procedure are applied or discarded at the standby database as a whole.