Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Dynamic Performance (V$) Views, 139 of 211
This view lists information about archived logs that are needed to complete media recovery. This information is derived from the log history view, V$LOG_HISTORY
.
V$RECOVERY_LOG
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_LOG
will be empty to all other Oracle users.
Column | Datatype | Description |
---|---|---|
|
|
Thread number of the archived log |
|
|
Sequence number of the archived log |
|
|
Time of first entry (lowest SCN) in the log |
|
|
Name of the file when archived, using the naming convention specified by "LOG_ARCHIVE_FORMAT" |
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|