# MV\_RECOVERY\_STATUS

This view includes information about the status of the current recovery process.

This view is also available as an LMV (local view per node) view.

| Column Name             | Description                                                                                                    |
| ----------------------- | -------------------------------------------------------------------------------------------------------------- |
| DATABASE\_NAME          | The name of the database being recovered.                                                                      |
| DATABASE\_ID            | The internal ID for the database being recovered.                                                              |
| NODE\_ID                | The ID of the node from which the database is being recovered.                                                 |
| REPLAY\_ETA             | The replay % completion and an estimated time to completion.                                                   |
| REPLAY\_STATUS          | The status of the replay. Possible values: "Recovering snapshot from disk" or "Recovering log files from disk" |
| REPLAYED\_LSN           | The Log Sequence Number indicating the position to which changes have been applied to the replica.             |
| STARTUP\_COMMITTED\_LSN | The Log Sequence Number indicating the position up to which each transaction has been committed.               |
| RECOVERY\_TYPE          | Possible values: Attach, Restart node, Restore                                                                 |

***

Modified at: November 5, 2024

Source: [/db/v9.1/reference/information-schema-reference/backup-and-restore/mv-recovery-status/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/backup-and-restore/mv-recovery-status/)

(An index of the documentation is available at /llms.txt)