In the event of a system failure in Ingres, it is standard procedure to recover the database from checkpoints. If journals, log files, or dump areas are lost, a gap of data on the failed database occurs. This same gap can still exist on one of the replicated databases. Use the Reconciler to attempt to recover the data gap using the shadow and archive tables for one or more peer databases.

Visual DBA: You perform the reconcile procedure by choosing the Reconciler command from the Operations menu. For more information, see the online help topic Reconciling a Replicated Database.

Command Line: Use the reconcil command to recover the gap of data on the failed database using the shadow and archive tables from one or more full peer databases. For more information, see the Command Reference Guide.