Oracle 视图 V$RECOVERY_STATUS 官方解释,作用,如何使用详细说明

本站中文解释

(Oracle视图及用途)

V$RECOVERY_STATUS视图是一个内部视图,用于显示当前实例正在进行的恢复任务的状态。该视图中可以看到恢复任务的进度、待恢复的SCN等其他信息。

V$RECOVERY_STATUS视图可以用于查看当前正在进行数据库恢复的状态。用户可以使用该视图查看当前数据库正在进行的恢复任务的状态,如果正在进行数据库恢复,也可以看到相应的恢复状态。比如正在进行日志恢复的状态,恢复的SCN,用于恢复的日志空间,以及恢复所花费的时间等。

官方英文解释

V$RECOVERY_STATUS contains statistics of the current recovery process. This view contains useful information only for the Oracle process doing the recovery. When Recovery Manager directs a server process to perform recovery, only Recovery Manager can view the relevant information in this view. V$RECOVERY_STATUS will be empty to all other Oracle users.
Column Datatype Description

RECOVERY_CHECKPOINT

DATE

Point in time to which the recovery has occurred. If no logs have been applied, this is the point in time the recovery starts.

THREAD

NUMBER

Number of the redo thread currently being processed

SEQUENCE_NEEDED

NUMBER

Log sequence number of the log needed by the recovery process. The value is 0 if no log is needed.

SCN_NEEDED

VARCHAR2(16)

Low SCN of the log needed by recovery. The value is 0 if unknown or no log is needed.

TIME_NEEDED

DATE

Time when the log was created. The value is midnight on 1/1/88 if the time is unknown or if no log is needed.

PREVIOUS_LOG_NAME

VARCHAR2(513)

Filename of the log

PREVIOUS_LOG_STATUS

VARCHAR2(13)

Status of the previous log. Contains one of the following values: RELEASE; WRONG NAME; MISSING NAME; UNNEEDED NAME; NONE

REASON

VARCHAR2(13)

Reason recovery is returning control to the user (NEED LOG|LOG REUSED|THREAD DISABLED)

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

See Also:

Oracle Database Backup and
Recovery User’s Guide


数据运维技术 » Oracle 视图 V$RECOVERY_STATUS 官方解释,作用,如何使用详细说明