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. |
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 |