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.
Point in time to which the recovery has occurred. If no logs have been applied, this is the point in time the recovery starts.
Number of the redo thread currently being processed
Log sequence number of the log needed by the recovery process. The value is 0 if no log is needed.
Low SCN of the log needed by recovery. The value is 0 if unknown or no log is needed.
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.
Filename of the log
Status of the previous log. Contains one of the following values: RELEASE; WRONG NAME; MISSING NAME; UNNEEDED NAME; NONE
Reason recovery is returning control to the user (NEED LOG|LOG REUSED|THREAD DISABLED)