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 is able to 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) |