Phases of a recovery

The phases of a OpenText™ Analytics Database recovery are the same regardless of whether you are recovering by table or node.

The phases of a OpenText™ Analytics Database 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.