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