Patent ID: 8799216

Claim:
A method of mirror resynchronization of bulk load tables written to by online transactions in a mirrored pair of databases comprising a primary database and a mirror database, comprising: creating a bulk load target file; writing transaction data from an online transaction into said target file; determining whether said primary database and said mirror database remained in a synchronized state during said writing; upon determining that said primary database and said mirror database remained in said synchronized state during said writing, concurrently bulk loading said target file directly to both a primary page table in said primary database and to a mirrored page table corresponding to said primary page table in said mirror database; otherwise, upon determining said primary database and said mirror database were in an unsynchronized state during at least part of said writing, bulk loading said target file only to said primary page table and catching up said mirror database as part of said transaction during mirror resynchronization; checking the synchronization state of said mirror database during transaction commit preparation; and upon determining that said primary database and said mirror database were in said unsynchronized state, said catching up further comprises copying changes to said primary database page table data to the mirror database and flushing the mirror to disk.