8.161 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 can view the relevant information in this view. V$RECOVERY_STATUS
will be empty to all other Oracle users.
Column | Datatype | Description |
---|---|---|
|
|
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 |
|
|
Low SCN of the log needed by recovery. The value is |
|
|
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: |
|
|
Reason recovery is returning control to the user ( |
|
|
The ID of the container to which the data pertains. Possible values include:
|