Phases of a recovery
The phases of a Vertica recovery are the same regardless of whether you are recovering by table or node.
The phases of a Vertica recovery are the same regardless of whether you are recovering by table or node. In the case of a recovery by table, tables become individually available as they complete the final phase. In the case of a recovery by node, the database objects only become available after the entire node completes recovery.
When you perform a recovery in Vertica, each recovered table goes through the following phases:
| Order | Phase | Description | Lock Type |
|---|---|---|---|
| 1 | Historical | Vertica copies any historical data it may have missed while in a state of DOWN or INITIALIZING. | none |
| 2 | Historical Dirty | Vertica recovers any DML transactions that committed after the node or table began recovery. | none |
| 3 | Current Replay Delete | Vertica replays any delete transactions that took place during the recovery. | T-lock |
| 4 | Aggregate Projections | Vertica recovers any aggregate projections. | T-lock |
After a table completes the last phase, Vertica considers it fully recovered. At this point, the table can participate in DDL and DML operations.