Online repair of a replicated table

摘要

Techniques are provided for resynchronizing instances of a replicated table. In one embodiment, a database server is provided as a member of a plurality of communicatively coupled database servers. Each database server is configured to support a replicating mode of operation and a non-replicating mode of operation. The instances of the replicated table are resynchronized responsive to a user request, without stopping any of the plurality of database servers and without requiring any of the plurality of database servers to operate in the non-replicating mode of operation.

主权项

1. A computer-implemented method to resynchronize replicating tables, comprising:
providing a database server as a member of a plurality of communicatively coupled database servers, wherein each database server is configured to support:
a replicating mode of operation characterized by providing access to a respective instance of a replicated table while replicating any changes to the replicated table; anda non-replicating mode of operation characterized by providing access to the respective instance of the replicated table without replicating any changes to the replicated table; and responsive to a request and while the plurality of database servers is operating in the replicating mode of operation and subsequent to the respective instances becoming desynchronized:
by operation of one or more computer processors, resynchronizing the respective instances of the replicated table on the database server without stopping any of the plurality of database servers and without requiring any of the plurality of database servers to operate in the non-replicating mode of operation.