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

Was this article helpful?