Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

V$RECOVERY_STATUS

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.

See Also:

Oracle9i Recovery Manager User's Guide

Column Datatype Description

RECOVERY_CHECKPOINT

DATE

The 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

The 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)

The 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(257)

The filename of the log

PREVIOUS_LOG_STATUS

VARCHAR2(13)

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

REASON

VARCHAR2(13)

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